(03) 9999 7780

(03) 9999 7780

Call For Queries?

Training Centre

View on Map

Keystroke Learning - Main Menu

(03) 9999 7780

Call For Queries?

(03) 9999 7780

Training Centre

[email protected]

Keystroke Learning - Main Menu
Keystroke Learning - Microsoft Excel Training Course

Microsoft Excel 
Intermediate

Microsoft Excel Intermediate

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.

Course Details

Course Skill Level

Intermediate

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
Tue, 20 Apr 2021
Book Training Course Now
Face to Face training delivery Course delivery as Face to Face training
Suite 513/1 Queens Road Melbourne 3004
Wed, 28 Jul 2021
Book Training Course Now
Face to Face training delivery Course delivery as Face to Face training
Suite 513/1 Queens Road Melbourne 3004
Wed, 15 Sep 2021
Book Training Course Now
Face to Face training delivery Course delivery as Face to Face training
Suite 513/1 Queens Road Melbourne 3004
Tue, 23 Nov 2021
Book Training Course Now
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.

Download Course Outline (PDF)
Download

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
Index and Match Functions
  • Using Index
  • Using Match
  • Using Index and Match Together
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.
Contact Us
Go
Keystroke Learning - Building Computer Skills to Enable Success

© 2016 Onwards – Keystroke Learning – ABN 11 620 050 759

Privacy Policy      Terms and Conditions

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???

Call (03) 9999 7780

Keystroke Learning - Building Computer Skills to Enable Success

Log in