This course is for experienced users of Excel who wish to explore some of the more specialist formula, list and formatting tools Excel has to offer.
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)
Previous knowledge of Excel is essential including the ability to construct formulas and basic functions.