__STYLES__

/

/

Excel Crash Course | Step-by-Step Dashboard Tutorial for Beginners

Excel Crash Course | Step-by-Step Dashboard Tutorial for Beginners

MAVEN CRASH COURSE

MAVEN CRASH COURSE

MAVEN CRASH COURSE

Excel Crash Course | Step-by-Step Dashboard Tutorial for Beginners

Excel Crash Course | Step-by-Step Dashboard Tutorial for Beginners

Excel Crash Course | Step-by-Step Dashboard Tutorial for Beginners

Enrique Ruiz

Excel

20 Min

Beginner

Microsoft Excel has more than 1 billion users worldwide.

Whether you’re a data professional or just getting started, Excel provides a user-friendly interface for working with data in every phase of the analytics process: data cleaning, prep, analysis, and visualization.

And the best part? ANYONE can learn the foundations of Excel in just a matter of minutes – for free!

In this demo, we’ll play the role of an entry-level data analyst for a local toy store 🧸

We’ve been given access to a spreadsheet with ~15,000 sales records for 35 different products, and our task is to use that data to understand things like weekday vs. weekend revenue, monthly trending, and top products.

Using Excel, we’ll transform the raw data into a user-friendly, interactive dashboard to help our manager better understand revenue patterns across product categories.

Along the way, we’ll walk through key steps of the analytics workflow:

  1. Create calculated columns using formulas & functions

  2. Perform exploratory data analysis with pivot tables

  3. Visualize data with charts & graphs

  4. Build a stunning, interactive dashboard

…all in less than 20 minutes!

Course Outline

Intro

00:00

Project Brief

00:18

Creating Calculated Columns

00:55

Performing Exploratory Data Analysis

07:07

Visualizing Data

10:10

Building and Interactive Dashboard

12:50

Project Recap

15:28

Resources and Next Steps

15:43

Course Outline

Intro

00:00

Project Brief

00:18

Creating Calculated Columns

00:55

Performing Exploratory Data Analysis

07:07

Visualizing Data

10:10

Building and Interactive Dashboard

12:50

Project Recap

15:28

Resources and Next Steps

15:43

Course Outline

Intro

00:00

Project Brief

00:18

Creating Calculated Columns

00:55

Performing Exploratory Data Analysis

07:07

Visualizing Data

10:10

Building and Interactive Dashboard

12:50

Project Recap

15:28

Resources and Next Steps

15:43

About your instructor

About your instructor

Enrique Ruiz

Sr. Learning Experience Designer

Enrique is a certified Microsoft Excel Expert and top-rated instructor with a background in business intelligence, data analysis and visualization. He has been producing advanced Excel and test prep courses since 2016, along with adaptations tailored to Spanish-speaking learners.

Cookie SettingsWe use cookies to enhance your experience, analyze site traffic and deliver personalized content. Read our Privacy Policy.