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 

• Creating 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