Transforming Data Into Insights with Excel (sf)

• Able to collect data from relevant data sources and select appropriate visualisation techniques to interpret and convey findings
• Able to organise data in a table format to display information to reflect trend and correlations
• Able to transform and contextualise data according to requirements to be displayed dynamically
• Able to represent data into a proper data model that will in due course lead to data visualisation
• Able to process data using tools and techniques for data display and visualisation purposes
• Able to utilise visual objects, charts and dashboards for data interpretation and presentation to stakeholders

What You'll Learn

This course is intended for anyone who wants to stretch their data analysis capabilities using Microsoft Excel starting with a block of data to a table of data, going beyond just functions and formulas, and picking up more advanced capabilities leading to data preparation, data modelling and data visualisation using power query, power pivot, pivot charts, conditional formatting, slicers, timelines and dashboards.

Minimum Entry Requirement

It is recommended that the participant would have used or have basic working knowledge of Microsoft Excel.