Excel Advanced

For individuals who are already using Excel to an advanced level. This course will teach you how to use Excel to analyse, collaborate and validate. These tools are extremely useful for auditing and streamlining your workflow.

What you will learn:

Macros

• Editing & Deleting Macros
• Record Macros
• Customising 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 – If Analysis
• Drawing Diagrams Recommended Pivot Tables

Additional Items

• IfAnd/IfOr FormulaIfNa Formula
• Convert to Table Screenshots
• Removing Duplicates Filter Timeline
• IfError, HLookups, Sparklines, Pivot Tables, Flash Fill

Tel 0131 556 5650

Tel 0141 223 0090

Duration: 1 Day

We now deliver this workshop in shorter sessions over a virtual classroom – delivered live from our tutor in 2 half day sessions.