Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Click Here to Get Started Advanced Excel Introduction page 2 Filter the Data page 3 Sort & Filter page 5 Create Subtotals page 6 Group and Outline Data page 8 Create a lookup table page 10 Name a Range page 13 Use the VLookup Function page 14 Calculate the Bonus page 17 SmartArt! page 18 Activity: Analyze data and use the Lookup Function Work Smarter, Not Harder Level 11: Get Smart
Click Here to Get Started
Advanced Excel Introduction page 2
Filter the Data page 3
Sort & Filter page 5
Create Subtotals page 6
Group and Outline Data page 8
Create a lookup table page 10
Name a Range page 13
Use the VLookup Function page 14
Calculate the Bonus page 17
SmartArt! page 18
Activity: Analyze data and use the
Lookup Function