Microsoft Excel Intermediate
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
Course delivery via our
Live Online Training Tue, 01 Sep 2020
Course delivery as
Face to Face training Tue, 20 Oct 2020
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
Today
Face to Face
Online
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