Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js HTML5 PHP Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel Analytics

Excel Crash Course: Dashboards, Data Analysis & Heatmaps

Learn core, business-focused Excel skills for data analysis, data visualisation and dashboard modelling in 3 hours
Rating: 4.1 out of 54.1 (258 ratings)
18,456 students
Created by Tobi Williams
Last updated 9/2020
English
English [Auto]

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.


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:

  1. Explore Microsoft Excel from a data science, data visualisation and data analysis perspective

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

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

  4. Manipulate pivot tables to design effective and beautiful charts and heatmap visuals

  5. Design and customise pivot charts by adding custom images

  6. Use the Power Query tool to manipulate and mashup data

  7. Use certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skills

  8. Test your data analysis skills by working on data retrieved from Twitter API

  9. Learn HOW to maximize office productivity and increase your salary with automation skills


Why Excel skills matter

Advanced Microsoft Excel skills can open up a whole myriad of career opportunities in business analysis, product management, data analysis, operations and strategy roles. As a skilled Excel user that is able to extract insights from data, you will be comfortable in working in industries such as finance, consulting, manufacturing, pharmaceutical, analytics or other business roles. Excel is the primary spreadsheet application used in financial modelling and ad-hoc data analysis.

In this 100% example-based and project-based course, you’ll develop highly marketable business-focused Excel skills in data analysis and data visualisation to help you outperform competing candidates for promotions, job opportunities, and internships. You’ll learn what it means to be the Excel go-to person having an unfair advantage in analytical skills.


How is the course structured?

The course curriculum has been designed as a project-based, crash course. You will learn rapidly by working through the Twitter dataset to understand rudimentary data analysis and design novel heatmaps. Then in the latter half of the course, you will learn how to work with modern Excel tables and manipulate them using the Power Query tool, structured referencing, and using the functions available on Office 365 version of Excel to craft automated calculations and dashboards.

The course builds on itself, meaning that as we continue forward in the course we’ll re-use the concepts from previous sections to further reinforce them. All of the material is 100% example-based and we’ll use multiple real-life examples throughout the course.

The course is composed of 18 short lectures each of which covers one concept at a time, and 2 problem-solving sessions (data challenges). The full course length is 1.8 hours of well thought out, deliberate content to get you building and designing within Excel. You will also get over 1 hour of practice problems which are very detailed and cover real-life analytical scenarios.

I designed this course to be as practical and as relatable as possible by using sample data from real-life activities. The course is complete with working files, you’ll be able to follow along practising each concept and receive a verifiable certificate of completion when you finish the course!

It's a crash course so be ready to take a leap!

Are there any course requirements or prerequisites?

  • 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

  • More advanced users looking to learn how to improve office productivity

  • Business students curious about data visualization

  • Business professionals interested in data analysis and modelling

  • Crash course enthusiasts

  • Python developers and coders interested in data analysis and Excel

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
  • Business owners
  • Accountants

Instructor

Tobi Williams
Founder at Resagratia, Consultant, Information Architect
Tobi Williams
  • 3.8 Instructor Rating
  • 266 Reviews
  • 18,508 Students
  • 2 Courses

Tobi possesses a Bachelor’s degree in Electrical & Electronics Engineering from the University of Sheffield, and a Master’s degree from Loughborough University, UK, and Universidad de Zaragoza, Spain. He worked as a renewable energy researcher and data analyst in the UK shortly before joining KPMG Nigeria as an Audit Analyst.

He has 10+ years of experience working with Excel and programming in multiple languages. He has also worked as a project manager handling industrial - FMCGs, restaurants and banks - and residential energy projects.

Tobi is a data scientist with a passion for data analysis and modelling, data warehousing, data viz, and management. He's an avid fan of Open Analytics and loves to wrangle data and use data visualization to unravel never-seen-before insights.

He is the principal consultant at Resagratia and has consulted for many international companies.

He is currently an Analytics Product Manager for a German company leveraging digital platforms to positively transform the educational experience of millions of children all over the world.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.