Building Computer Skills to Enable Success

(03) 9999 7780

Call for Queries?

Close this search box.
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel Intermediate

Microsoft Excel


Microsoft Excel Computer Training Course

Course Overview

Students on this Microsoft Excel Intermediate 1 day course will build on their existing knowledge to gain an understanding of Excel analysis using more complex functions and formulas. You will also learn a number of tips and shortcuts to help you save time in your daily Excel tasks.

This course is designed for participants who already have a good understanding of the fundamentals of Excel and wish to progress to the next level.

What you need to Bring

  • Laptop with the relevant software installed.

People feel more comfortable using their own laptop, since they will be familiar with its layout and options. Having access to all of your applications and customisations will come in handy through the training.

  • No laptop? Please get in contact with us.

If you don’t have a laptop, please let us know beforehand so we can supply one on the training day.

Am I Ready For This Training?

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

Once you’ve completed this course, you may like to progress to one of our Excel Advanced, or Excel Advanced Data Analysis courses.

Course Details

Course Skill Level


Class Size

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

Course Duration

1 Day Training Course

Class Times

9:00am – 4:00pm

Your Course Includes



Upcoming Public Courses


Course Delivery Style

Face to Face Training Delivery

Face 2 Face 

Online Training Delivery


Still Need Approval?

Want to reserve a seat but you still need approval?

No problem, simply call us on (03) 9999 7780 and we will hold a seat for you.  There’s zero risk, if you don’t get approval, we’ll cancel the reservation.

Course Content

Cell Referencing
  • Relative and Absolute References
    What’s the difference?
  • Relative References
  • Absolute References
  • Mixed References
Linking and 3D Formulas
  • Thinking in 3 Dimensions
  • Working with Multiple Worksheets
  • Building 3D Formulas
  • Creating Linked Workbooks
  • Updating Links
Lists, Tables and Subtotals
  • Sorting Lists
  • Filtering Lists
  • Lists vs Tables
  • Working with Subtotals
IF Functions
  • Logical Functions
  • Using True and False
  • Using Comparison Operators
Nested IF Functions
  • Logical Functions
Conditional Formatting
  • About Conditional Formatting
  • Applying Conditional Formatting
  • Using Data Bars and Colour Scales
  • Modifying Formatting Rules
  • Finding and Clearing Formats
Choose Function
  • Using the Choose Function
Lookup Functions
  • Using Lookup Functions
  • Lookup
  • VLookup
  • HLookup
  • XLookup
Index and Match Functions
  • Using Index
  • Using Match
  • Using Index and Match Together

*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