Microsoft Excel 2013 Advanced

Course Details

This Excel course is aimed at those who wish to gain expert knowledge of Excel 2013 and gain knowledge of advanced techniques for its usage.

Our Microsoft Excel 2013 courses are delivered in over 50 locations nationwide. The course is accredited by Microsoft and includes all course materials, a manual and a certificate.

Course Contents

The course includes the following modules:

Outlining, Grouping & Subtotals

  • Outlining and Grouping Data 
  • Using the Subtotals Tool

What-If Analysis

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

PivotTables

  • Getting Started with PivotTables
  • Displaying Data in a PivotTable 
  • Formatting a PivotTable 
  • Using the Classic PivotTable Layout 
  • Slicers

Charting Pivoted Data

  • Getting Started with Pivot Charts 
  • Using the PivotChart Tools Tabs 
  • Formatting a PivotChart

Advanced Excel Tasks

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

VLOOKUP and HLOOKUP Functions

  • Using the VLOOKUP Function 
  • Using the LOOKUP Function

Introduction to Macros

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

FAQ's

What are the prerequisites for this course?

The course has no prerequisites.

What am I provided on the course?

You will be provided with an official courseware folder, detailed user-friendly manual, pre/post course email support, refreshments and a certificate of completion.

Who will be instructing me?

You will be a taught by a qualified, knowledgeable instructor with years of experience in their field.

When should I arrive to the venue?

You should aim to arrive at 9am.