Microsoft Excel II

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.

Course content:

- 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.

Email training@chamber.co.nz for more information, or visit the website.

Event listed by Chamber of Commerce

View their other events or contact promoter