(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 
Beyond the Basics

Microsoft Excel
Beyond the Basics

Microsoft Excel Computer Training Course

Course Overview

Participants in this half day Microsoft Excel – Beyond the Basics course will gain an insight into relative and absolute references as well as working with lists, subtotals, linking formulas and worksheet protection.

You can learn all of this without having to be away from the office for a full day.

The course assumes you have a working knowledge of Excel fundamentals, however people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.

Course Details

Course Skill Level


Class Size

6 Students (max)

Course Duration

½ Day Training Course

Class Times

9:00am -12:30pm



Upcoming Public Courses

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

Cell Referencing
  • Relative and Absolute References What’s the difference?
  • Relative References
  • Absolute References
  • Mixed References
Lists, Tables and Subtotals
  • Sorting Lists
  • Filtering Lists
  • Lists vs Tables
  • Working with Subtotals
Linking and 3D Formulas
  • Thinking in 3 Dimensions
  • Working with Multiple Worksheets
  • Building 3D Formulas
  • Creating Linked Workbooks
  • Updating Links
Workbook Protection
  • Types of Protection
  • Protecting Worksheets
  • Protecting Workbooks
  • Protecting Files
Keystroke Learning - Building Computer Skills to Enable Success

Face to Face 
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

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