Excel training files
Medium difficulty activities.
7 Find out how to freeze worksheet panes to make your data easier to read.
9 Learn about absolute and relative cell references. (complex formulas)
13 Narrow down your data by adding one or more filters.
16 Create new documents using templates to save time.
More Advanced training materials
20 Learn the basics of creating and manipulating PivotTables.
21 Make your PivotTables even more powerful by adding filters, slicers and PivotCharts
Web address to access more training material.
Smartphone app for further training.
GCF Excel 2010 Tutorial App for Android and iPhones.
Training files from the GCF site
7 xl support sheet
9 Using formulas
xl support sheet 1
support sheet (filled in)
xl support sheet
14 Formatting tables
16 Using templates
20 Pivot tables
21 Pivot charts and analysis
Click here for more information.