Working with Functions and Formulas
Creating Formulae in Excel, general calculations
The Function Wizard
Using Functions in Excel: The 5 Popular functions
Working with Names and Ranges
- Vlookup, Hlookup, Index, Match
Working with Tables
Working with Records and Fields
Filters and Sorting, Freeze panes, split, protecting and unprotecting
Using Excel as a Database
Advanced filter: copy only specified rows and columns from a large data set, auto mate this selective copy
Create Pivot Table, Amend, Filter, Sort, Format Pivot Tables, Add additional folmulas, Refresh Data.
Charts and Sparklines
Brief Overview of Charts and Sparklines
Sign up to receive lessons, tips, examples, quizzes and other training materials.