This is an advanced-level MS Excel program designed to teach you about Advanced Pivot Table, graphs and formatting, advanced conditional formatting, audit formulas Vlookup, advanced formulas, filters and much more.
Outline:
Advanced Graphs and Formatting
Advanced Pivot Table
Advanced Formatting
Recording Macros
Data Validation & Formatting
Advanced Filters and Automation
Data Table, Inserting objects
Advanced Conditional Formatting & Charts
Top Ten Advanced Formulas
Goal Seek, Audit formulas
Grouping and outlining Data
Vlookup, Visio, Hlookup, Slicer
Features:
Hand-outs and course materials will be given
Quiz with simulation included
Cost effective with best quality
Expert trainers
Course completion certificate