Excel Crash Course Dashboards, Data Analysis & Heatmaps

[Prohibitive]

Excel Crash Course: Dashboards, Data Analysis & Heatmaps
Duration: 1h 46m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 44100 Hz, 2ch | Size: 1.24 GB
Genre: eLearning | Language: English

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
Description
This is a 100% project-based Microsoft Excel crash course with a special focus on data analysis, designing simple dashboards and creating heatmap visuals and other charts. Maximizing office productivity is a key skill to learn. By working with modern Excel tables and learning how to extract insights from data, you'll achieve a leap in your Excel skills in 2 hours.

Supercharge your Microsoft Excel skills rapidly in this Crash Course!

As a Business Intelligence consultant, I designed the curriculum based on some of the skills needed to get you powering through your daily business needs, and I've designed the courses to achieve specific objectives. This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time.

Students will work on two different datasets - Twitter data and fuel prices data - to design dashboards and extract insights using Pivot tables and beautiful heat maps.

In this course you will learn how to:

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

Use the Power Query tool to manipulate and mashup data

Use certain 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

Download
http://nitroflare.com/view/27C4003622F3573/Excel_Crash_Course_Dashboards.part1.rar
http://nitroflare.com/view/2A094E572C8572A/Excel_Crash_Course_Dashboards.part2.rar

or
https://rapidgator.net/file/d2b3dfd2d89fd3245d3f428e1e4c1004/Excel_Crash_Course_Dashboards.part1.rar
https://rapidgator.net/file/c4d29f7c36df25720a6867cb10d0ba30/Excel_Crash_Course_Dashboards.part2.rar