Excel Beyond the Basics

Length: 0.5 Day(s)     Cost:$315 + GST

= Scheduled class     = Guaranteed to run     = Fully booked

Please wait as we are loading the schedules...
LOCATION September October November December
Auckland
Hamilton
Christchurch
Wellington
Virtual Class

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.


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.

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.


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