(08) 9383 8000
Excel - Data Analytics
Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.
1 Day
Overview
Descriptive, predictive and prescriptive analytics are interrelated, helping companies make the most out of their data. Excel is a tool that can be used for analysis; to collect, clean, transform and analyse data and generate reports.
Content
- Understand the different types of analytics techniques
- Use advanced sorting for descriptive analysis
- Use advanced conditional formatting for descriptive analysis
- Work with advanced analytic functions such as SUMPRODUCT and analytic database functions such as DSUM AND DAVERAGE
- Learn how to use What-If Analysis tools:
- Goal Seek to calculate a single value needed to achieve a known outcome
- Scenario Manager to switch between different calculations with different variables
- Data Tables to view multiple results from one or two variables
- Solver to calculate multiple values needed to achieve a known outcome.
- Gain an understanding of the Excel Analysis ToolPak.
Learning Outcomes
Participants should be able to:
- Understand which analytics tools are available in Excel
- Use advanced sorting and advanced conditional formatting for descriptive analysis
- Use selected analytics functions such as DSUM, DAVERAGE, DMAX and AGGREGATE
- Understand the What-If Analysis Tools and their uses
- Understand the set of statistical analysis tools available in the Excel Analysis Toolpak.
Level - Intermediate
Do you want to create presentations with a difference? Including movie clips and sound tracks is easier than you might think. They bring presentations to life and can make your message truly memorable.
This course provides an in-depth understanding of the advanced features of Teams, enabling participants to enhance workplace collaboration, communication, and effectiveness.
Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.
Level - Fundamental
Using Microsoft Word efficiently will help you create good looking documents quickly. This course develops essential Word skills needed to create, edit, format and print documents.