Microsoft Excel 2013 – Advanced

Duration

1 day

Pre Requisites

Delegates should first attend the Microsoft Excel Intermediate course or have attained a similar level of expertise.

Objectives

By the end of this one day course delegates will feel confident in their ability to use the more advanced features of Excel including lookup tables, advanced formulae, PivotTables and macros.

Other Versions Available

2007, 2010

Further Learning

Excel with PowerPivot

Excel VBA

Course Content

Advanced Functions

  • Using SUMIF, AVERAGEIF & COUNTIF
  • Multiple conditions
  • Lookup Tables
  • Text Functions

Outlining and Views

  • Outlining a Worksheet
  • Creating Custom Views

Controlling Data Input

  • Data Validation

Advanced Filtering

  • Text to Columns
  • Advanced Filtering

PivotTables

  • Creating PivotTables
  • Formatting the Pivot Table
  • Using Slicers
  • Adding a Timeline
  • Calculations in PivotTables
  • Grouping & Ungrouping
  • Creating a PivotChart
  • Create PivotTables based on Multiple Tables

Macros

  • Recording a Macro
  • Viewing Macros
  • Adding a Macro to the Ribbon
  • Assigning a Macros to an Object
  • Accessing the Developer Tab
  • Macro Security Settings

What-If Analysis (time permitting)

  • Goal Seek
  • Data Tables
  • Scenarios