Microsoft Excel

Excel Advanced (2007, 2010 & 2013)


Product Description

This intensive hands-on one-day training course has been designed for users with a good understanding of Microsoft Excel 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Enquire Now!

This course covers Microsoft Excel 2007, 2010 and 2013.

Content covered:

Grouping & Outlining and Subtotals

  • Outlining and Grouping Data
  • Using the Subtotals Tool

What-If Analysis

  • Exploring Scenarios
  • Goal Seek and Data Tables
  • Using Solver


  • Getting Started with PivotTables
  • Displaying Data in a PivotTable
  • Formatting a PivotTable
  • Using the Classic PivotTable Layout
  • Slicers
  • Charting Pivoted Data
  • Getting Started with PivotCharts
  • Using the PivotChart Tools Tabs
  • Formatting a PivotChart

Advanced Excel Tasks

  • Excel and Hyperlinks
  • Using Custom AutoFill Lists
  • Sharing Workbooks

Creating HLOOKUP and VLOOKUP Functions

  • Using the VLOOKUP Function
  • Using the LOOKUP Function

Introduction to Macros in Excel

  • Recording and Playing Macros
  • Copying and Deleting Macros
  • Visual Basic and Macros


There are no reviews yet.

Be the first to review “Excel Advanced (2007, 2010 & 2013)”