(03) 9999 7780

Call for Queries?

Training Centre

View on Map

Keystroke Learning - Google Sheets Training Course

Google Sheets Intermediate

Google Sheets

Intermediate

Google Sheets Computer Training Course

Course Overview

Students on this Google Sheets Intermediate 1 day course will build on their existing skills to gain a deeper understanding of Google Sheets analysis by exploring IF functions and Lookup formulas.

You will also explore conditional formatting to enhance visual representation of data as well as tips and shortcuts to help you save time in your daily tasks.

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

Am I Ready For This Training?

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

Course Details

Course Skill Level

Intermediate

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

Price

$470+GST

Upcoming Public Courses

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
  • What are Relative and Absolute References?
  • Relative References
  • Absolute References
Linking and 3D Formulas
  • Thinking in 3 Dimensions
  • Working with Multiple Worksheets
  • Building 3D Formulas
  • Linking with IMPORTRANGE
Checking Formulas
  • Checking the References
  • Breaking it up
  • Check the Arguments
  • Walk Through the Order of Operations
Sorting and Filtering
  • Types of Sorting
  • Creating Filters
  • Applying Multiple Filters
IF Functions
  • Logical Functions
  • Using True and False
  • Using Comparison Operators
Nested IF Functions
  • Building Nested Functions
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
Conditional Formatting
  • About Conditional Formatting
  • Applying Conditional Formatting
  • Colour Scale Function

*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

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