Excel 2010 Advanced

Date Location Price / Members Price Places Trainer Book Online or Enquire

Overview

This course covers aspects of Excel beyond building basic workbooks. It deals with workbook automation, productivity features, data analysis tools and automating workbook using macros.

 

Content


Section One: Working with Data

  • Outlining and Grouping Data
  • Exploring Scenarios¬†
  • Using Goal Seek
  • Using Solver
  • Using Hyperlinks


Section Two: Pivoting Data

  • Getting Started with PivotTables
  • Working with PivotTable Data
  • Formatting a PivotTable
  • Using Classic PivotTable Layout
  • Creating and Formatting a PivotChart¬†
  • Using Slicers
  • Advanced PivotTable and PivotChart Tasks
  • Using PowerPivot


Section Three: Advanced Excel Tasks

  • Using Advanced Functions (PMT & FV Functions, IF AND or Functions and IFERROR Functions)
  • Using VLOOKUP Function
  • Using Array Formulas
  • Using Custom AutoFill Lists
  • Linkin, Consolidating and Combining Data

 

Section 4: Macros

  • Recording Macros
  • Assigning a Macro to the QAT
  • Viewing a Macro
  • Deleting a Macro


Who Should Attend:

  • This course is designed for Microsoft Excel users who have a good knowledge and understanding of Excel but are not yet at expert level
  • It will suit users who wish to extend their knowledge and skills


Prerequisites:

  • It is also recommended that proposed delegates have attended a Microsoft Excel 2010 Introduction and Excel Intermediate course¬†
  • Those who have obtained comparable knowledge from workplace and work Excel on a daily basis.