Programme Overview
The training focuses on the more advanced features within Excel, in particular, functions and formatting of worksheets; and using multiple worksheets. We will assume that you already have a basic, working knowledge of Excel (see Excel Foundation course).
Gain a greater understanding of the working of Microsoft Excel, including how to work between multiple worksheets and workbooks. Learn how to import Excel information into other Microsoft Office applications.
Course Benefits
The greatest benefit? Feel more confident. Ditch the frustration and become more competent in your work.
Skills Taught
- the interface, tabs and ribbons
- absolute and relative cell referencing
- inserting objects – tables, pivot charts and sparklines
- the ‘if’ functions, including ‘sumif’ and ‘countif’
- worksheet consolidation
- lookup function and its implementation
- formulas
- the ‘developer tab’
- managing data
- conditional formatting.
Course Presenter
Dr Pip Lynch
Upcoming Course Details
Next Course: Wednesday's 27 November and 4 December 2019
Time: 11am - 2pm
Investment: $425 + GST
Designed for
People already familiar with the basic features of Microsoft Excel and who want to develop their skills and expertise.
What to Expect
This workshop is delivered over two sessions to small groups, not exceeding five, with each person having their own computer to work with and a manual to support the learning. This training can be tailored to meet organisational needs.
Testimonial
Thank you so much for the course, I really enjoyed it and I am sure I will be able to utilize the Excel skills in my role. Stacey is a great teacher, really friendly and happy to answer any weird and interesting questions that were thrown her way.
Latania Leach, Cawthron Institute
