Excel Advanced

For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow.

What you will learn:

• Macros – Editing and deleting macros, recording macros, customizing ribbon.
• Review Data – track changes, auditing tools, watch window, review changes, restricting data area.
• Utilities – Goal seek, data consolidation, power view reports, create scenarios, What -Ifanalysis, drawing diagrams, recommended pivot tables.
• Additional – IfAnd/IfOr formula, IfNa formula, Convert to table, screenshots, removing duplicates, filter timeline, IfError, HLookups, Sparklines, Pivot tables, flash fill.