Skip to content
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 
Advanced

Microsoft Excel Advanced

Microsoft Excel Computer Training Course

Course Overview

On this 1 day Excel Advanced course, participants will add to their already extensive knowledge to gain an understanding of Excel’s advanced features, including PivotTables and Data Consolidation, Protection, as well as Recording Macros.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding some automation to their workbook tasks.

Course Details

Course Skill Level

Advanced

Class Size

10 Students (max)

Course Duration

1 Day Training Course

Class Times

9:00am -4:00pm

Price

$480+GST

Upcoming Public Courses

online training deliveryCourse delivery via our Live Online Training
Mon, 07 Sep 2020
Face to Face training deliveryCourse delivery as Face to Face training
Wed, 28 Oct 2020

Course Content

Data Consolidation
  • Linking to Source Data
  • Consolidate by Position
  • Consolidate by Category
Creating PivotTables
  • Building a PivotTable Shell
  • Adding Fields
  • Grouping Items
  • Filtering
  • Drilling Down
  • Changing Layouts
Advanced PivotTable Features
  • Using Slicers
  • Creating Calculated Fields
  • GetPivotData Function
  • Show Report Filter Pages
Recording Macros
  • Preparing Excel for Recording
  • Recording Macros
  • Storing Macros
  • Adding Comments
  • Testing Macros
Absolute vs Relative Macros
  • Absolute and Relative Recording
  • Testing types of Recording
  • Viewing and Editing Macros
Workbook Protection
  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files
Building Templates
  • Using Existing Templates
  • Creating Templates
  • Modifying Templates
Keystroke Learning - Building Computer Skills to Enable Success

Learn 
Today
Face to Face
Online
 with Keystroke Learning

Learn with Keystroke Learning

Our training approach is professional yet friendly, motivating participants to learn quickly and easily. 

When you complete our training course, you will be ready to apply your new skills right away. 

If you have a customised training solution in mind or need to schedule our popular computer courses

call (03) 9999 7780 or email us @ info@keystrokelearning.com.au

Melbourne Training Venue

Level 2 / 52 Albert Rd
South Melbourne, VIC, 3205

Venue Access Hours

Monday – Friday 8:30am – 5:00pm

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success

Log in