Course Details

Auckland Chamber of Commerce

Auckland Chamber of Commerce, Level 1, 100 Mayoral Drive, Auckland.

Full Day
9.00am - 4.00pm

This course introduces Excel features that save you time. It is designed primarily for those who spend many hours formatting and updating data in spreadsheets.

This course is aimed at a person who is proficient in the fundamentals of using Excel. It will suit users who now wish to use Excel functions and commands to promote a more efficient use of time spent formatting and updating data.

You will learn how to:
Create and copy calculations using absolute and relative addressing, e.g. $A$4 vsA4
Manipulate the view to easily work with multiple worksheets and large tables of data
Set the print options to print titles on each page and Headers and Footers
Sort and Filter large lists of data
Link, move and copy information between worksheets and workbooks
Save time and reduce errors using simple Functions
Control results using Goal Seek
Format and protect workbooks so you can confidently share with other users
Create and use macros to cut down on processing time

Sharyn Baine