Microsoft Excel’s ability to integrate and visualise data is the focus of this one-day course, using the latest features in Excel. Work through multiple exercises to learn to master the tools of data modelling, analysis, and building visuals for effective dashboards.
Participants will create a data model with a range of data sources using Power Pivot and use Get and Transform to connect and manipulate a range of data sources including cloud databases, websites and Facebook. Learn how to fully utilise Excel to create interactive Dashboards, Charting tools and Visualisation techniques.
We complete the course by working through a Case Study, pulling together all the aspects taught on the day.
Business Case Study – We start with raw sales data for a Comedy Roadshow. We model the data using PowerPivot, creating relationships and the necessary calculations to build our interactive Dashboard for assessing Sales performance and profitability across various cities.
Note: Excel 2016, Excel 2019, Excel 2021, and Excel 365 are all desktop application versions of Microsoft Excel. Excel 2016, Excel 2019, and Excel 2021 are the perpetual, bought-outright, stand-alone versions of the software; Excel 365 is the subscription-based version. Anyone working with any of these versions will be able to successfully complete this course. Throughout this course you will be using the desktop app; the course does not cover use of the web/online app.
Nexacu Public Schedule
With the recent acquisition of Nexacu, we're pleased to now offer you the largest public schedule of end user applications training in Australia and New Zealand. As we move to consolidate our End User offering with Nexacu, as an interim measure, you can now access the schedule of the most closely aligned courses and book, by clicking on the link below. Pricing of some courses may vary when booking directly through Nexacu.