(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

Keystroke Learning - Main Menu
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

6 Students (max)

Course Duration

1 Day Training Course

Class Times

9:00am -4:00pm

Price

$350+GST

Upcoming Public Courses

Face to Face training deliveryCourse delivery as Face to Face training
Wed, 28 Apr 2021
Face to Face training delivery Course delivery as Face to Face training
Suite 513/1 Queens Road Melbourne 3004
Tue, 03 Aug 2021
Face to Face training delivery Course delivery as Face to Face training
Suite 513/1 Queens Road Melbourne 3004
Wed, 22 Sep 2021
There are no upcoming courses at this time.
However, we can add extra courses on demand. This generally occurs once 3 or more people are interested in a course.
 

Call (03) 9999 7780 or email us with your contact details if you would like us to get in touch when we have enough participants.

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

Melbourne Training Venue

Suite 613, Level 6,   1 Queens Road Melbourne, VIC 3004

Venue Access Hours

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

Are you Running Late???

Keystroke Learning - Building Computer Skills to Enable Success

Log in