Short Courses

CORPORATE TRAINING

Microsoft Excel Advanced

DURATION: 3 Days
NEXT DATES: TBA
COST: $985 + gst
BYO Device: Yes
PREREQUISITS: Basic Computing skills, plus a sound knowledge of Excel level 2 skills

About this Course

This course covers aspects of Microsoft Excel beyond building basic workbooks and deals with workbook automation and productivity features. Instructors teach advanced techniques in areas such as workbook and worksheet consolidation, data validation, lookup and reference functions, PivotTables, linking, Solver and macros.

Who should do this course?

TThis course is intended for experienced Microsoft Excel users who wish to extend their knowledge and skills beyond building and formatting simple workbooks. Upon successful completion of the course, students should be able to use Excel’s advanced data analysis tools and automate workbook operations.

Prerequisites

Learners undertaking this course should have foundation computing skills including basic file managment.

BYO Device

Each participants is required to attend sessions with a laptop or suitable device with Microsoft Excel installed and ready to undertake learning. When available a laptop can be supplied for an additional fee.

Additional Learning

If you are jsut starting out with Excel try our these;

Limited Positions Available

Objectives:

Advanced functions and formulas
Nesting Functions
Work with multiple worksheets and workbooks
Forecast data
Introduction to Pivot Tables and Pivot Charts
Introduction to VBA programming

Overview:

Build on your Microsoft Excel to become the authority in your worplace. This course aims to expand your Excel skills by exploring some of Excels’ more advanced features to streamline workflows and automation techniques. Participants can build upon skills gained to eventually become an expert in Microsoft Excel and data automation.