Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Create rich and interactive Dashboard using Microsoft Excel.
Rating: 4.2 out of 5(3 ratings)
7 students

Create rich and interactive Dashboard using Microsoft Excel.

Learn how to build a fully interactive and a self-service business intelligence dashboard using Microsoft Excel.
Created byFestMan Learning Hub, Thomas Festus Cudjoe
Last updated 1/2023
English

What you'll learn

  • Analyze data using PivotTables
  • Visualize insights using advanced charts in Excel
  • Customize report themes and backgrounds in Excel
  • Work with slicers and reports connection
  • Design interactive dashboards and reports
  • Protect workbooks and worksheets
  • Design custom visuals in Excel

Course content

3 sections • 29 lectures • 2h 37m total length

  • Introduction1:26
  • Prerequisites0:16
  • Datasets and walkthrough3:38
  • Project Overview2:19
  • Project Roadmap1:52
  • Demo: Explore Datasets3:38
  • Demo: Adding Calculated Columns5:23

Requirements

  • You need Microsoft Excel 2010 or later version for Windows or Mac. This course is filmed with Excel for windows, However, if you are Mac user, you can still follow the lessons.
  • You know how to work with basic formulas and functions in Excel.
  • Basic knowledge of PivotTables is required.

Description

Data visualization and Dashboard design skills have become a sought-after skill and valuable to businesses in almost all industries.

A dashboard is a visual representation of key metrics that allow users to quickly view and analyze data in one place.

Dashboards not only provide consolidated data views, but serves as a self-service business intelligence tool, where users are able to explore data and discover insights quickly.


Using Data Analytics tools like Microsoft Excel, you can develop rich and interactive dashboards and reports. In this course, you will learn how to use Microsoft Excel to analyze and visualize data to design interactive and automate reports and dashboards.

Your ability to design and develop a compelling and automated dashboards and reports will help you stand out at the workplace and help you accelerate your career.


This course is designed for individuals and analysts who use data in the business setting. If you are responsible for presenting data in your day-to-day job, or a data analyst, then this course is for you. You will learn how to design interactive and visually striking dashboard using Microsoft Excel.


We will adopt a guided learning approach to help you learn and master the concept and the process for designing rich and dynamic dashboards.


Who this course is for:

  • Microsoft Excel users
  • Professionals who work with Excel to develop reports and dashboards
  • Data Analysts
  • Accounting and Finance professionals
  • Data Science professionals
  • Data analytics enthusiasts

Report abuse