Auckland Chamber of Commerce, Level 1, 100 Mayoral Drive, Auckland.
Full Day 9.00am - 4.00pm
$240.00 Members $240.00 + GST, Non-members $360.00 + GST
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