Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
Excel Fundamentals Academy
Course Content
Expand All
Welcome to the Course!
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Getting Started
Course Schedule
Course Introduction
Who’s Ken
Excel Essentials
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Basic Navigation
Navigational Keyboard Shortcuts
Entering and Clearing Data
Useful Keyboard Shortcuts
Formula and Function Review
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Introduction to Formulas
Unlocking Excel’s Formula Power
Anatomy of a Function
Mathematical and Statistical Functions
Logical Functions
Text Parsing Functions
Working with Dates
Structuring Data in Excel
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Structuring Data in Excel
Excel Tables
Benefits of Excel Tables
VLOOKUP Deep Dive
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
What is VLOOKUP
VLOOKUP Approximate Match
VLOOKUP Exact Match
Understanding VLOOKUP Matches
Common VLOOKUP Issues
Text vs Number Conversions
Guarding Against NA Results
Data Visualization
10 Lessons
Expand
Module Content
0% Complete
0/10 Steps
Conditional Formatting
Sparklines
Chart Types
Five Rules of Effective Charting
Effective Pie Charts
Effective Bar Charts
Effective Column Charts
Effective Line Charts
Practice Lab – Lucky Acres Farm
Practice Solution – Lucky Acres Farm
From Ad-Hoc to Tabular
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Introduction to PivotTables
Creating PivotTables
Understanding PivotTable Mechanics
Formatting PivotTables
PivotTable Design Options
Intermediate PivotTable Skills
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Grouping Data in PivotTables
Sorting Data in PivotTables
PivotTable Aggregations
PivotTable Calculation Options
Filtering PivotTables
Custom Calculations in PivotTables
PivotTable Dangers
The Trouble with Data
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Building Modern BI Solutions
The Trouble with Data
Classic Excel Cleanup
Power Query Adds ETL to Excel
Dealing with Data in Modern Excel
Basic Importing with Power Query
4 Lessons
Expand
Module Content
0% Complete
0/4 Steps
Accessing Power Query
How Systems Import Dates
Importing a CSV File
Update Options
Reshaping Tabular Data
10 Lessons
Expand
Module Content
0% Complete
0/10 Steps
Basic Append Operations
Unpivot With Ease
Unpivot Subcategorized Tables
Pivoting Stacked Data
Pivoting Multi Column Vertical Pairs
Pivoting Multi Column Horizontal Pairs
Data Grouping Recipe
Ordinal Ranking
Standard Competition Ranking
Dense Ranking
Merging Data
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Merging Tables with Power Query
7 Ways to Join Your Data
Semi Joins
Cartesian Products
Merging with an Approximate Match
Conditional Logic
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Creating Conditional Logic
Conditional Logic – Advanced
Columns From Examples
Advanced Append Operations
8 Lessons
Expand
Module Content
0% Complete
0/8 Steps
Append all Tables in the Current Workbook
Importing a Folder of Files – Overview
Importing a Folder of Files – Step 0
Importing a Folder of Files – Step 1
Importing a Folder of Files – Step 2
Importing a Folder of Files – Step 3
Importing a Folder of Files – Step 4
Update Options Revisited
Practical Skill Application
7 Lessons
Expand
Module Content
0% Complete
0/7 Steps
Practice Lab – Cudaso Products
Benford Analysis – Extracting First Number
Benford Analysis – Calculating Distribution Percentage
Benford Analysis – Create Benford Table
Benford Analysis – Create Comparison Table
Benford Analysis – Visualize the Results
Benford Analysis – Applying to Other Data Sets
Help Resources
6 Lessons
Expand
Module Content
0% Complete
0/6 Steps
Free Help Forums
Power Query Articles
Power Query Books
Power Query Recipes
Power Query Academy
Free Newsletters
Rate the Course
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Course Feedback
Ask Ken Sessions
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Ask Ken Anything
AKA Content Index
AKA Session Recordings