Microsoft Excel Beyond the Basics
Beyond the Basics
Microsoft Excel
Beyond the Basics
Course Overview
Participants in this half day Microsoft Excel – Beyond the Basics course will gain an insight into relative and absolute references as well as working with lists, subtotals, linking formulas and worksheet protection.
You can learn all of this without having to be away from the office for a full day.
The course assumes you have a working knowledge of Excel fundamentals, however people with limited exposure to the software and those who are entering data into spreadsheets created by others will also benefit from attending this course.
Course Details
Intermediate
10 Students (max)
½ Day Training Course
9:00am -12:30pm
$350+GST
Upcoming Public 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
- Relative and Absolute References What’s the difference?
- Relative References
- Absolute References
- Mixed References
Lists, Tables and Subtotals
- Sorting Lists
- Filtering Lists
- Lists vs Tables
- Working with Subtotals
Linking and 3D Formulas
- Thinking in 3 Dimensions
- Working with Multiple Worksheets
- Building 3D Formulas
- Creating Linked Workbooks
- Updating Links
Workbook Protection
- Types of Protection
- Protecting Worksheets
- Protecting Workbooks
- Protecting Files
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