Review Topics (optional)
Entering and editing data efficiently
Basic formatting
Arithmetic calculations
Creating and filtering lists and creating subtotals
Creating and editing default charts
General features
Freezing panes
Splitting windows
Inserting, copying and moving sheets
Hiding and protecting data
Formulae and Functions
Absolute and relative references
Basic functions; MIN, MAX, AVERAGE, IF
Rounding
Basic date functions; using date functions in formulae
List functions; VLOOKUP, MATCH, INDEX and advanced filters
Names
Naming sheets, cells, ranges, constants and formulae
Using names for navigation
Using names in formulae, and the Intersection Reference Operator
Links
Creating external references
Creating links using Paste Special
Updating links
Editing links
Printing
Setting and clearing print areas
Printing named ranges
Page Break Preview - controlling page breaks
Page Set-up - repeating rows and columns, creating headers and footers
Pivot tables
Creating Pivot Tables
Modifying Pivot Tables
Templates
Creating and using templates
Charts
Chart wizard
Editing embedded charts
Formatting charts
|
