If you prefer a more traditional approach
An email will be sent through this form. Your data will therefore not be processed in any way, pursuant to Regulation (EU) 2016/679.
PAY-BACK 17990
Excel Crash Course - Data Analysis, Dashboards and Heatmaps
Business
English
29 lectures
3 hours
Certificates
179.90 €
Buy course
Excel Crash Course - Data Analysis, Dashboards and Heatmaps

Business ► Data Science
Software ► Office

English
Certified skills you will learn
Skills legend
Levels
Skills have 3 levels to communicate the right grade of competence.
Beginner
Intermediate
Advanced

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.
4.0
Based on 1 reviews
Most helpful
Please, help us understand the problem
What's wrong with this message?