Microsoft Excel - Advanced Course

Overview

Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the advanced features of this powerful spreadsheet application.

     

This is best for

Power end Excel users who want to develop their skills using a range of formulas and use various advanced techniques to manipulate Excel data.

     

Content

Review of Intermediate concepts

  • Overview of topics covered during Intermediate Excel course
       

Working with Multiple Sheets & Workbooks

  • Add, remove and copy sheets
  • Grouping sheets for editing & linking data from multiple sheets
  • Create 3 dimensional formulae
       

Advanced Data Tools

  • Consolidating data with identical and different layouts
  • Filter data - auto & advanced filter
  • Data validation & conditional formatting
  • Sensitivity analysis with goal seek, scenarios & data tables
  • Using outlines
       

Excel Functions

  • Working with specific function groups
  • Nesting & combining functions
  • Using named ranges
          

 Charts & Pivot Tables

  • Apply advanced concepts to Excel charts
  • Create pivot tables & charts
  • Using calculated fields and other pivot table techniques

Excel Automation

  • Working with templates & styles
  • Creating and editing simple Excel macros
  • Assigning macros to buttons, toolbars and other objects
  • Customising toolbars & ribbons
  • Applying protection to worksheets & workbooks
   

Learning outcomes

On completion of this course, participants will be able to use multiple files, link these with formulas, and work with three dimensional ranges; as well as perform Data distribution analysis, attach passwords and have a fuller understanding of the features of Excel.

  

Prerequisites

Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.

  

Duration

Two days: 9am to 4pm

Investment

$890 GST free per person

Includes:

  • Experienced facilitator
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up

 

Enjoy Real People, Real Conversations, Real Results 

     

Certification Options - Microsoft Office Specialist

Microsoft Core Certification in Excel.

   

Software versions

Available for 2010, 2013, 2016 & 365


  

Is this the right course for you?

Find out here > 

 

 

When

19 February 2020 (Two days)
19 March 2020 (Two days)
30 April 2020 (Two days)
21 May 2020 (Two days)
30 June 2020 (Two days)
20 July 2020 (Two days)