Courses
Excel Beyond the Basics
Length: 0.5 Days Cost: $285 + GST Version: Digital Training Hub
= Scheduled class 
= Guaranteed to run 
= Fully booked| Centre | Mar | Apr | May | Jun |
|---|---|---|---|---|
| Auckland | -- | 21 | -- | -- |
| Hamilton | -- | 22 | -- | -- |
| Christchurch | -- | 15 | -- | -- |
| Wellington | 17 | -- | 31 | -- |
| Virtual Class | -- | -- | -- | -- |
Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.
About this Course
This course is designed for existing users of Microsoft Excel who are looking to build confidence and increase their skillset. We will cover data analysis tips such as sorting, filter, and autofill.
We will review basic formulas and calculations and introduce the concept of absolute references ($A$1) to see how this can help calculate percentages.
Audience
Great if you’ve got the basics covered but want to up your game. If you find yourself still breaking out the phone calculator because it is faster than working out the calculation in Excel, then this is the course for you.
Prerequisites
You should be comfortable with the topics covered in our Excel Basics course such as entering and editing data, printing, basic formulas to calculate totals and basic formatting.
At Course Completion
Expect to leave this course with a better understanding of Excel that will allow you to use it skilfully and analytically to manage data and glean insights. This course will provide you with the knowledge and confidence to create and edit professional spreadsheets and prepare you for our Excel Timesaving Features course.
Course Outline
The Excel Window
Office Backstage
Working with Worksheets
Sorting & Filtering
Using Functions
Inserting & Deleting Rows & Columns
Cut, Copy and Paste
Using Drag and Drop, Fill and AutoFill
Using Absolute References
Using Charts
