Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Close this search box.
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.

Am I Ready For This Training?

Participants should have a good understanding of the fundamentals of Microsoft Excel. Ideally you will have completed our Getting Started with Excel training course, or have some prior experience using simple Excel Spreadsheets, including entering and editing data, and creating formulas.

Once you’ve completed this course, you may wish to attend our Charting with Excel course.

Course Details

Course Skill Level


Class Size

Public Courses 6 Students (Max)
Client Site Courses 10 Students

Course Duration

½ Day Training Course

Class Times

9:00am – 12:30pm or 1:00pm – 4:30pm

Your Course Includes



Upcoming Public Courses


We currently do not have this course on our public schedule, but don’t let that deter you!

Exciting news! We are currently offering special prices for one-on-one training for this program.

Call us on (03) 9999 7780 or email us to discuss you options.

Psst… We can also organise group training sessions.

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

*Our outlines are a guide to the content covered in a typical class.
 We may change the course topics to meet the objectives of a particular class.

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
Interested in learning more about our offerings?
Our team will take the time to discuss your requirements and help you make smart decisions that best meet your needs.
© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759
Keystroke Learning - Building Computer Skills to Enable Success

Log in

Keystroke Learning - Building Computer Skills to Enable Success in Melbourne

Melbourne Training Centre

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

Venue Access Hours

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

Are you Running Late???

Skip to content