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