If you have used Microsoft Excel for some time and need to learn more, this Perth based training course provides you with additional skills. Take your basic knowledge to the next level and learn how to improve your Microsoft Excel skills.
2 Days
This hands-on course lays the foundations for building a stronger, more advanced understanding of Microsoft Excel and will coach you to be confident with Microsoft Excel functions commonly used in the workplace.
Learn how to identify ranges with names, use workbooks with multiple sheets, protect worksheets and files, link worksheets, audit files and create templates. Work interactively with functions such as IF and VLOOKUP.
To benefit from this short course, you should be a confident user of Microsoft Excel. This course provides you with further skills in Microsoft Excel.
If you are experienced in creating and modifying spreadsheets and can work with basic formulas and functions, the Intermediate Excel training course will help you to build additional skills.
Participants should be able to:
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!
A vast majority of projects that suffer cost and time overruns do so because they lack professional scheduling. This course focuses on key tools of Microsoft Project needed by schedulers and planners; the Work Breakdown Structure (WBS) and the Critical Path Method (CPM).
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.
This course highlights the concepts of project management and introduces Microsoft Project’s key features of how to set up a schedule and a resource pool, how to assign resources to tasks and how to track a project.