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
How Do You Know If You're Working With Data?
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Login