Microsoft Excel Intermediate Training

This short course is perfect for those wanting to learn Excel beyond simple workbooks to help drive efficiency and perform more complex tasks. You will learn how to construct formulas using Absolute and Relative addressing. This level will expose you to some of the in-built functions of Excel, such as, financial, database and logical function.

At the conclusion of this course, you will have gained skills in:

• A more in-depth look at autofilling
• Sequential filling
• Creating a custom list
• Editing a custom list
• Deleting a custom list
• Creating formulas using Relative addressing
• Creating formulas using Absolute addressing
• Using functions
• Using the VLOOKUP function
• Using the IF function
• Sorting
• Auto filtering
• Calculations in an auto filtering

A customised user manual and certificate of attendance will be provided to delegates on completion of the training.

Device Requirement: This is a BYOD(Bring Your Own Device) event. You must bring a device with Microsoft Excel 2016 or higher to attend this event.

Catering: Coffee and tea, morning tea, lunch and afternoon tea will be provided.

Facilitator: Terrence Yakub

Terrence has over 25 years of experience in Training and Management. His success is in developing an interest and aspiration for learning within people and to assist individuals to develop competence and confidence in using software programs in a relevant, enjoyable, and interactive manner. Terrence delivers courses and manages multi-national projects both overseas and in Australia for clients such as Australia Post, ANZ Bank, Telstra and Realestate.com.au. He also incorporates training needs analysis and creates and develops software training programs for the retail, manufacturing, educational, finance, and the food industries, as well as government departments.

Host or Publisher Jobs Australia