Skip to content
Dashboard
Menu
Dashboard
Courses
Discussions
My Account
Contact Us
Course Overview
IntroMediate Excel Techniques
Course Content
Expand All
Platform Introduction
3 Lessons
Expand
Module Content
0% Complete
0/3 Steps
Course Examples
Who’s Ken
Extend Your Access
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 & 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
Conditional Formatting
1 Lesson
Expand
Module Content
0% Complete
0/1 Steps
Conditional Formatting
Introduction to PivotTables
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Introduction to PivotTables
Creating PivotTables
Understanding PivotTable Mechanics
Formatting PivotTables
PivotTable Design Options
Help Resources
5 Lessons
Expand
Module Content
0% Complete
0/5 Steps
Free Help Forums
M is for (Data) Monkey
Power Query Academy
Free Newsletters
User Groups