Home Courses Excel Beyond the Basics

Courses


Excel Beyond the Basics

Length: 0.5 Days    Cost: $285 + GST    Version: Digital Training Hub

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreAprMayJunJul
Auckland
21
----
22
Hamilton
22
----
01
Christchurch----
25
--
Wellington--
31
--
09
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


 Print this page