Excel Crash Course - Dashboards, Data Analysis & Heatmaps (Updated 9 - 2020)

[ FreeCourseWeb.com ] Excel Crash Course: Dashboards, Data Analysis & Heatmaps (Updated 9/2020)



Download More Latest Courses Visit -->> https://FreeCourseWeb.com







Duration: 2h 59m | Video: .MP4 1280x720, 30 fps(r) | Audio: AAC, 44100 Hz, 2ch | Size: 1.94 GB

Genre: eLearning | Language: English

Learn core, business-focused Excel skills for data analysis, data visualisation and dashboard modelling in 3 hours

What you'll learn

Explore Microsoft Excel from a data science & data visualisation and data analysis perspective

Design three dashboard systems in Excel - Twitter Activity Heatmap, Advanced Currency Converter, Business Invoicing Dashboard

Learn to use Excel dynamic arrays with other functions like a pro to build automated systems

Manipulate pivot tables to design beautiful, custom charts and heatmap visuals

Work with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etc

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 3 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.



Use Winrar to Extract. And use a shorter path when extracting, such as C: drive



ALSO ANOTHER TIP: You Can Easily Navigate Using Winrar and Rename the Too Long File/ Folder Name if Needed While You Cannot in Default Windows Explorer. You are Welcome ! :)



Download More Latest Courses Visit -->> https://FreeCourseWeb.com



Get Latest Apps Tips and Tricks -->> https://AppWikia.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...