This one-day course has been designed for those users who wish to discover the advanced features of Excel.
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.
Microsoft Office 2010 / 2013
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
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
Displaying and tracing formulas | Understanding formula errors
Recording a macro | Playing and deleting a macro | Adding a macro to the Quick Access Toolbar | Editing a macro’s visual basic code
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
Simply complete the form below and we'll come back to you as soon as possible