As an advanced Excel user, you may need to perform many varied tasks. In this course you will manage external data using tables, analyse data using advanced functions and formula auditing tools and PivotTables.
Learn how to cleanse data imported from external sources and perform what-if analysis using Goal Seek, Solver and advanced Data Tables. Automate repetitive tasks using Macros and VBA. For a more comprehensive use of VBA, refer to our Excel Visual Basic Course outline.
The course has been designed for experienced users of Excel who wish to used the advanced features of Excel.
Participants must be confident users of Excel who are able to create and manage multiple sheet workbooks.
|Event End Date||05-02-2018|
|Location||Corporate Training Solutions Australia|