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:
Create calculated columns using formulas & functions
Perform exploratory data analysis with pivot tables
Visualize data with charts & graphs
Build a stunning, interactive dashboard
…all in less than 20 minutes!
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.
Recommended
continued
learning
with
Excel
Self-paced course
Advanced Excel Dashboard Design
Bring your data to life with dynamic, interactive Excel dashboards, and build 3 real-world projects from scratch
LEARNING PATH
Excel Specialist
This path is for Excel users looking to ace the Microsoft MO-201 Exam and build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query and more
COHORT PROGRAM
Excel Immersive
Build a deep, expert-level Excel skill set, and learn best practices for working with formulas, charts, pivot tables, dynamic dashboards and more