Formulas and Functions

• Revision of the If function

• Nested Ifs

• Using the And & Or functions

• Naming ranges for use in formulas

• Retrieving data using vLookup

 

Advanced Formatting

• Creating new cell styles

• Conditional formatting

 

Lists

• Revision of sort & AutoFilter

• Advanced filtering

 

Pivot Tables

• Creating & manipulating a pivot table

• Refreshing a pivot table

• Formatting a pivot table

 

Data Validation

• Controlling data input & drop-down lists

• Creating data input alerts & prompts

• Checking validity of existing data

• Circling invalid data

• Clearing data validation

• Protecting worksheets & workbooks

 

Data Tools

• Grouping & outlining

• Subtotals

• Data consolidation

 

Macros

• Recording a macro

• Running a macro

• Assigning the macro to a button

• Editing a macro

• Deleting a macro (& the button)