Excel Crash Course: Dashboards, Data Analysis & Heatmaps
Learn core, business-focused Excel skills for data analysis and data visualisation in 2 hours
What you’ll learn
-
Explore Microsoft Excel from a data science, data visualisation and data analysis perspective
-
Work with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etc
-
Manipulate pivot tables to design effective and beautiful charts and heatmap visuals
-
Design and customise pivot charts by adding custom images
-
Tips and tricks to fine tune your Excel dashboards and visuals to supercharge your data visualisation skills
-
Test your data analysis skills by working on data retrieved from Twitter API
-
Learn HOW to maximize office productivity and potentially increase your pay
Requirements
-
Preferably Excel on Office 365 for Windows. Microsoft Excel 2010-2019 (PC/Windows)
-
Mac users are welcome, but note that the interface of Pivot Tables varies across platforms
-
Knowledge of Excel for basic reporting is an added advantage but not required
-
Be ready to make a leap. It’s a crash course
Who this course is for:
- Beginner in Excel interested in data analysis
- Business students curious about data visualization
- business professionals interested in data analysis and modelling
- crash course beginners
- python developer interested in data analysis and Excel
