Duration: 1 day
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of Excel tools and concepts in order to further increase their knowledge and productivity.
Who Should Attend?
Users with a solid understanding of, and experience with, Microsoft Excel who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.
Advanced Conditional Formatting
- Editing Standard Formatting Rules
- Input Validate rules
- Using Formulas in Conditional Formatting
Using Form Controls and Templates
- Using Form Controls
- Creating Templates
- Advanced Calculations
- Goal seek, consolidate and scenarios
Advanced Lookup Functions
- Using Hlookup and VLookup Functions
- Using the Index Function
- Using the Match Function
- Using Index and Match Together
- Using the Indirect Function
- Using Error Functions
- Using Logical Functions
- Using Array Formulas
- Using Rounding Functions
Advanced Pivot Table Tools
- Importing Pivot Table Data
- Calculated Fields in Pivot Tables
- Showing Pivot Data as a Percentage
- Creating Custom Pivot Tables Styles