Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn Excel 2016 Intermediate Level - Beyond the Basics
Chapter 1: Excel Intermediate Introduction
Course Introduction (2:51)
Course Exercise Files
Course Support Files
Reviewing Excel Terminology (8:55)
Tips and Tricks in the Ribbon (4:54)
Escaping the "Mouse"-Trap (6:30)
Common Hotkeys (4:33)
Special Hotkey Commands (6:51)
Defining Your Excel View (6:26)
Chapter 2: Indexing and Lookups
Using MATCH (5:55)
Defining Lookups and Arrays (3:38)
Using VLOOKUP and HLOOKUP (8:09)
Using INDEX (6:28)
Mixing LOOKUPS, INDEX, and MATCH (7:40)
Chapter 3: Named Ranges
What is important to you? (3:41)
Simple and Quick Name Definitions (6:32)
Accessing and Using the Name Manager (3:46)
What can Names do? (9:26)
Chapter 4: Dynamic Formula
What is a Reference? (4:11)
Using Indirect (9:26)
Using Offset (6:46)
Using Row, Column, and Cell (5:23)
Creating Dynamic Named Ranges (9:42)
Best Practices Regarding Dynamic Functions (9:29)
Colon Operator (4:21)
Chapter 5: Charts and Graphs
Charts and Graphs Terminology (10:46)
Line, Scatter, and Bar Charts (11:31)
Radar and Surface Plots (3:41)
Waterfall, Pie, and Sunburst Charts (7:30)
The Box and Whisper Plot and Histograms (Statistical) (6:26)
Chart Formatting In Detail (8:27)
Mixing Chart Types (3:57)
The Bing Maps App (3:52)
Chapter 6: Working with Data
How Do You Know If You're Working With Data? (10:32)
Introducing DataTables (9:15)
Excel Data Model Relationships (7:07)
Data Slicers (6:40)
PivotTables (11:34)
Power Query / Get And Transform (10:23)
Pivot Charts (5:39)
The GETPIVOTDATA Function (6:36)
Course Conclusion (3:08)
Course Quiz and Certificate of Completion
Mixing LOOKUPS, INDEX, and MATCH
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock