TPG Full Version 6a 25 MAY 2023 (For Digital PDF) - Flipbook - Page 186
Productivity
Excel Intermediate
COURSE OVERVIEW
Delivery mode: In person and Virtual
Duration: 1 Day
Does your role require in depth analysis to make effective and efficient business decisions?
Would it be helpful to be able to read, manage and understand how to create complex formulas
in Excel?
In this training we will cover how to create and use advanced formulas, analyse data, organise
worksheet data with tables, visualise data with charts, insert graphics, and enhance workbooks.
Learning Outcomes
What’s Included?
•
Analysing Data with Logical and
Lookup Functions
Participants learn how to use text
functions to manage and manipulate
text, as well as date functions to return
date information. Additionally, they
will learn about the many different
financial functions that are available
and how they operate.
•
•
•
•
Ability to understand and create
spreadsheets to represent data and
influence business decisions
Knowledge required to create complex
formulas to make sense of detailed
information
Present information in visually digestible
charts making data easy to understand for
everyone
Understand how to get multiple
spreadsheets talking to each other, to
gather and summarise key information
Source external information to back up
and support presented data
To find out more go to ChooseYourCourse.com.au
Leadership and Management
Human Resources
Communication
Health Safety & Wellbeing
