Advanced Excel Course

Overview 

Turn unorganized data into useful information and quickly make spreadsheets your colleagues. The course starts with advanced topics like functions, PivotTables, and macros.

Working with Pivot Tables
  • Creating a PivotTable
  • Specifying 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
  • Using Slicers
  • Sharing Slicers Between PivotTables
Analysing Data
  • Creating Scenarios
  • Creating a Scenario Report
  • Working with Data Tables
  • Using Goal Seek
  • Using Solver
  • Using Text to Columns
  • Grouping and Outlining Data
  • Using Subtotals
  • Consolidating Data by Position or Category
  • Consolidating Data Using Formulas
Working with the Web and External Data
  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections
Max Number of Delegates

10

Menu

Hello! We are able to offer the vast majority of our courses online in a virtual classroom via your preferred video conferencing platform. All of our course contents have been updated to reflect the current COVID-19 situation. To enquire about any of our courses to be delivered online please go to our ‘Contact Us’ page