TPG Full Version 6a 25 MAY 2023 (For Digital PDF) - Flipbook - Page 188
Productivity
Excel Advanced
COURSE OVERVIEW
Delivery mode: In person and Virtual
Duration: 1 Day
Do you need to save time to achieve everything required in your role?
Would you like to be able to track and trouble shoot incorrect data?
Would it save time if you could import and export data with confidence?
In this course participants will cover how to automate worksheet functionality, audit worksheets,
analyse data, work with multiple workbooks, export Excel data and import/export XML data.
Learning Outcomes
• Time saving data analysis
• Create complex formulas to present
information in an easy-to-understand way
• Troubleshoot data issues without having to
call the IT Department
What’s Included?
Auditing Worksheets
Learn how to: trace cells, troubleshoot
invalid data and formula errors, watch
and evaluate formulas, and create a data
list online.
Analysing and Presenting Data
Learn how to: create Sparklines, create
scenarios, perform a what-if analysis,
perform statistical analysis with the
Analysis ToolPak, and create interactive
data with Power View.
Using PivotTables
Learn how to create and manipulate a
PivotTable and its data as well as how to
sort and filter it.
To find out more go to ChooseYourCourse.com.au
Leadership and Management
Human Resources
Communication
Health Safety & Wellbeing
