Level - Advanced
Working with long documents in Microsoft Word can be a challenge. We will show you how to format documents quickly and consistently, how to add numbered headings, create a table of contents, an index, table or figure captions and cross-references.
1 Day
This course assists you to efficiently create, modify and manage long documents in Microsoft Word and shows how to develop consistency of layout in complex documents.
Learn how to avoid formatting problems when copying text between different documents.
To benefit from this course, you should have a sound knowledge of Word.
Participants should be able to:
Level - Advanced
This course introduces Power Query to discover, connect to and import data into Microsoft Excel. It also focuses on using PowerPivot to remodel and enhance the imported data by writing queries through Power Query M language.
Level - Intermediate
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.
Level - Advanced
This course will introduce and extend VBA programming within Microsoft Excel. Participants will be able to create and manage complicated macros.
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.