YoVDO

How to Create Impactful Dashboards in Excel for Business Analytics

Offered By: Great Learning via YouTube

Tags

Data Visualization Courses Data Analysis Courses Data Cleaning Courses Pivot Tables Courses Data Organization Courses Dynamic Charts Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Discover how to create powerful and impactful dashboards using Excel in this comprehensive 54-minute tutorial. Learn to leverage pivot tables, charts, slicers, and timelines for building dynamic dashboards. Master the art of designing user-friendly interfaces with conditional formatting and dynamic charts. Explore data cleaning techniques using functions like TRIM and COUNTIF. Gain insights on maintaining dashboard effectiveness through regular updates and security measures. Understand how to combine data from various sources and utilize cloud tools such as Google Sheets or Power BI for real-time collaboration. Dive into the different phases of a Data Analytics project, data cleaning processes, and essential Excel functions for data analysis. Cover topics including types of Excel functions, pivot tables, data organization, and dashboard construction.

Syllabus

- Introduction
- Types of Functions in Excel
- Pivot Tables in Excel
- Organizing Data in Excel
- Building Excel Dashboards


Taught by

Great Learning

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX