PAY-BACK
17990
Excel Crash Course - Data Analysis, Dashboards and Heatmaps
Business ► Data Science
Software ► Office
English 
Certified skills you will learn
Business
Data analysis
Business
Problem-solving
Business
Analytical skills
Computer Science
Excel power user
Skills legend
Levels
Skills have 3 levels to communicate the right grade of competence.
29 lectures
3 hours
Certificates
179.90 €
Excel Crash Course - Data Analysis, Dashboards and Heatmaps
Business ► Data Science
Software ► Office
English
Certified skills you will learn
Business
Data analysis
Business
Problem-solving
Business
Analytical skills
Computer Science
Excel power user
Skills legend
Levels
Skills have 3 levels to communicate the right grade of competence.
Learn core, business-focused Excel skills for data analysis, data visualisation, data modelling and dashboard design in 3 hours.
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.
Course Objectives
- 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
- Manipulate pivot tables to design effective and beautiful charts and heatmap visuals
- Use the Power Query tool to manipulate and mashup data
- Learn HOW to maximize office productivity and increase your salary with automation skills
- Work with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etc
Course Target
This course is perfect for beginners in Excel interested in data analysis. It is also adapted for more experienced users who are looking to improve their office productivity and automate tasks.
Finally, the data science concepts and data visualisation tricks covered here will be relevant to Python developers, software engineers and coders.
How to access this course
In order to follow this course you'll need to register a personal account on GAMeDU, proceed to the check-out and pay the stated price.
Once bought, the course will be accessible by clicking the "MY COURSES" button on the toolbar placed on top of the website, or accessing to the "Learn" section on your Student Dashboard.
The course price includes: lifetime access to the course material (including attachments and handouts), access to the course's Thread board where you can get in touch with the teacher and other fellow students eduCoins and eXP (variable values directly related to the price of this course), Certificate of Completion when the course is fully completed.
Once bought, the course will be accessible by clicking the "MY COURSES" button on the toolbar placed on top of the website, or accessing to the "Learn" section on your Student Dashboard.
The course price includes: lifetime access to the course material (including attachments and handouts), access to the course's Thread board where you can get in touch with the teacher and other fellow students eduCoins and eXP (variable values directly related to the price of this course), Certificate of Completion when the course is fully completed.
4.5
Based on 2 reviews
Most helpful
18 January 2022 - 10:42
top
bellissimo per imparare, facile e molto efficiente. sempre al top
Report
Vote as useful
0 people found this helpful
26 October 2020 - 22:15
Excel Crash Course - Data Analysis, Dashboards and Heatmaps
Truly a beautiful course
Report
Vote as useful
0 people found this helpful
Please, help us understand the problem
What's wrong with this message?