Microsoft Excel Advanced

Microsoft Excel Advanced



Next Date



One Day

Microsoft Excel Advanced

Course Description

This one-day course has been designed for those users who wish to discover the advanced features of Excel.

Course Objectives

By the end of the course you will be confident in using some of Excel’s more advanced features. You will be able to do more complex “what if” scenarios and use conditional formula and pivot tables to manipulate information.

Course Content

Microsoft Office 2010 / 2013

Working with PivotTables

Creating a PivotTable | Specifying a PivotTable data | Changing a PivotTable’s calculation | Filtering and sorting a PivotTable | Working with PivotTable layout | Grouping PivotTable items  Updating a PivotTable  Formatting a PivotTable | Creating a PivotChart

Analysing and organising data

Creating scenarios | Creating a scenario report |Working with data tables | Using goal seek | Using data validation | Using text to columns | Removing duplicates | Grouping and outlining data | Using subtotals | Consolidating data by position or category | Consolidating data using formulas

Auditing your work

Displaying and tracing formulas | Understanding formula errors

Working with macros

Recording a macro | Playing and deleting a macro | Adding a macro to the Quick Access Toolbar | Editing a macro’s visual basic code

Time-saving features

Customising the Quick Access Toolbar | Using and customising AutoCorrect | Creating custom views | Changing Excel’s default options | Recovering your documents | Creating a custom AutoFill list | Creating a custom number format

Related courses

Microsoft Excel Intermediate

Microsoft Word Advanced

Microsoft Excel Introduction


Simply complete the form below and we'll come back to you as soon as possible