MICROSOFT EXCEL ADVANCED COURSE, PRIVATE 1-TO-1
Excel Advanced is for Excel Experts - you work daily with Excel and your work revolves around spreadsheets and Excel databases. This course is offered one-to-one, because we understand that individuals have varying skill levels and varying applications. Read more
EXCEL COURSE OUTLINE
General
- Editing Standard Formatting Rules
- Input Validate rules
- Using Formulas in Conditional Formatting
- Group and Outline
- Filter and Sorting
Data Insights with Pivot Tables
File and sheet Linking
- Referring to multiple sheets and external files within formulae and functions
- Working with multiple sheets
- Linking external files
Excel Tables and Advanced Filter
- Working with Excel tables
- Selectively Copy specific datasets, selective rows and columns from sheets, workbooks or external data
- Automate this process and integrate with data importing
Consolidate Goal seek, consolidate and scenarios Using Form Templates
Advanced Excel Lookup Functions
- VLookup Function
- Hlookup Function
- Using the Index Function,
- Using the Match Function,
- Index and Match Together
- Using the Indirect Function
Excel Advanced Functions
- Using Error, Logical, Array, Rounding Functions
Excel Macros
- Creating, amending and deleting macros
- Relative and Absolute recording of cell references
- Running macros
- Creating Macro menus, toolbars and shortcuts to execute macros by the click of a button
WHAT IS INCLUDED:
- Excel Course Certificate on completion
- Excel Course notes
- Practical Excel Class exercises, Excel Course Homework / Excel Course Revision work
- To assist after the course, 1 free session for questions online
