Microsoft Excel Intermediate in Melbourne

Microsoft Excel
Intermediate

Microsoft Excel Intermediate

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

Intermediate

10 Students (max)

1 Day Training Course

9:00am -4:00pm

$480+GST

Upcoming Public Courses

Tue, 02 Mar 2021

Tue, 20 Apr 2021

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

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

call (03) 9999 7780 or email us @ info@keystrokelearning.com.au

(03) 9999 7780

Training Centre

(03) 9999 7780

(03) 9999 7780

Training Centre

[email protected]