Microsoft Excel Level 4 (Advanced)

Versions: All earlier versions, 2013 and 2016 available

On-site training or public courses available in Paulshof, Sandton

Description

The advanced course helps you to automate spreadsheets, work with advanced functions and reports using pivot tables and pivot charts

Duration

1 day 

Outcomes

You will be able to analyse, manage and report on large spreadsheets using advanced functions and data commands 

Prerequisites

The advanced course assumes that you are working with Excel on a daily basis and have done sofor some period of time. You have used most of the features covered in the Beginners and Intermediate courses. If you are not sure then our Ms Excel level 2 course is a prerequisite for the advanced course.

Module 1: Customise defaults

  •  Change default settings

Module 2: Excel tools

  •  Insert hyperlinks
  •  Create and use Range Names
  •  Set Data Validation

Module 3: Advanced functions

  •  =Vlookup
  •  =Iferror 
  •  =Sumif and =Countif 
  •  =Sumifs and Countifs
  •  Nested IF statements

Module 4: Pivot Table Reports

  •  Create a pivot table
  •  Filter, Show and Hide Pivot Table data
  •  Use slicers 
  •  Rearrange Pivot Tables:
  •  Group fields
  •  Move fields
  •  Collapse and expand fields
  •  Refresh Data
  •  Create separate pivot table reports
  •  Use Show Value As
  •  Perform calculations within a pivot table
  •  Add Subtotals and Grand Totals
  •  Format field settings
  •  Apply a pivot table style
  •  Create a new custom Pivot table Style
  •  Create a Pivot Chart
  •  Modify a Pivot Chart
  •  Use conditional formatting with pivot tables

Module 5:  Macros

  •  Record a macro
  •  Relative and Absolute References
  •  Edit and Delete macros
  •  Run a macro
  •  Assign macros to objects
  •  Assign macros to a toolbar

 

Request a quotation

Please type your full name.

Invalid email address.

Invalid Input

Individual or company?

How many people require training?

Download course details