Course Overview
In this course, you’ll build the skills you need to manage, explore, analyze and visualize data in Microsoft Excel using real-world projects and datasets.
We’ll start by introducing the Excel landscape and interface, then dive into spreadsheet fundamentals like table structures, data types, formatting, sorting, and filtering.
From there, we’ll dig into formulas and functions, introduce key topics like syntax, reference types, and common errors, and practice applying some of the most common and powerful techniques for data management and analysis. We’ll use functions to count and aggregate values, create logical tests, join data across tables, manipulate text and date values, and more.
Next, we’ll introduce pivot tables, an essential spreadsheet tool for data exploration. We’ll prepare raw data for analysis, create views to slice and dice the data, apply different calculation options, and use tools like sorting, filtering, and calculated fields.
Last but not least, we’ll dive into the world of data visualization and storytelling, review best practices for effective design, and bring our data to life using essential visuals like bar, line, and pie charts, scatterplots, histograms, and maps.
This is a hands-on and project-based course designed to help you build practical data literacy and analytical thinking skills, whether you're brand new to the field or a professional analyst.
You’ll explore unique, real-world datasets from Flight Delays to Sales Pipelines, practice applying the tools and techniques you learn throughout the course, and leverage AI tools like Microsoft Copilot to help accelerate your skills.
COURSE OUTLINE:
Introducing Microsoft Excel
Create your first spreadsheet, navigate the Excel interface, and review the modern Excel landscape
Spreadsheet Fundamentals
Review key spreadsheet concepts like data types, tables, cell references, number formatting, and sorting & filtering
Formulas & Functions
Analyze and manipulate data using formulas, including function syntax, reference types, and common errors
Data Analysis with PivotTables
Explore and analyze data using pivot tables, including data structure, calculation options, and sorting & filtering
Data Visualization with Charts & Graphs
Visualize data using the right chart type and apply deliberate formatting to tell a clear and compelling story
FINAL PROJECT: Traffic Safety Analysis
Apply all the skills you've learned to analyze traffic accident data in NYC and expose interesting patterns and trends
__________
Ready to dive in? Join today and get immediate, LIFETIME access to the following:
6 hours of high-quality video
5 quizzes
5 projects
Microsoft Excel Foundations ebook (90+ pages)
Downloadable files & solutions
Expert support and Q&A forum
30-day Udemy satisfaction guarantee
If you’re ready to build the skills you need to make smart, data-driven decisions, this is the course for you.
Happy learning!
-Enrique Ruiz (Certified Excel Expert and Excel Instructor, Maven Analytics)
__________
Looking for more data & AI courses? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau, Machine Learning and more!
See why our courses are among the TOP-RATED on Udemy:
"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!" Russ C.
"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!" Tatsiana M.
"Maven Analytics should become the new standard for all courses taught on Udemy!" Jonah M.
FAQ
FAQ area empty
Course curriculum
Chương 1 Getting Started 5 bài · 4 phút
Chương 2 Introducing Microsoft Excel 6 bài · 16 phút
- Section Introduction Học thử 0:28
-
The Excel Landscape 2:29
- Your First Excel Workbook Học thử 3:03
-
The Excel Interface 7:21
- IMPORTANT: Adjusting Language Settings Học thử 2:41
-
Introducing Microsoft Excel
Chương 3 Spreadsheet Fundamentals 17 bài · 1 giờ 12 phút
-
Section Introduction 0:44
-
The Section Project & Dataset 1:27
-
Data Terminology 2:13
-
Shortcuts for Navigating Data in a Spreadsheet 7:36
-
Shortcuts for Entering & Editing Data 6:07
-
Data Types 6:50
-
Dates in Excel 2:59
-
Number Formatting 4:25
-
Data Validation 7:18
-
PRO TIP: Checkboxes & Dropdown Lists 5:48
-
Removing Duplicates 4:13
-
Conditional Formatting 8:45
-
Filtering Data 6:51
-
Sorting Data 2:19
-
PRO TIP: Microsoft Copilot 3:24
-
Key Takeaways 0:59
-
Spreadsheet Fundamentals
Chương 4 Formulas & Functions 26 bài · 1 giờ 45 phút
-
Section Introduction 0:37
-
The Section Project & Dataset 3:05
-
Formula Syntax 3:56
-
Types of Functions 1:22
-
Basic Math Functions 4:58
-
Fixed vs. Relative References 8:27
-
PRO TIP: Spill Ranges 2:18
-
Explicit vs. Structured References 2:35
-
Common Error Types 2:39
-
Counting Functions 4:05
-
PRO TIP: SORT and UNIQUE 3:18
-
Logical Functions 2:47
-
The IF Function 3:05
-
Nested IF Functions 9:28
-
AND/OR Operators 4:37
-
The IFERROR Function 2:46
-
Conditional Math Functions 11:22
-
PRO TIP: GROUPBY and PIVOTBY 4:05
-
Lookup Functions 1:42
-
The XLOOKUP Function 5:57
-
Basic Date & Time Functions 6:47
-
Basic Text Functions 6:41
-
PRO TIP: Flash Fill 1:45
-
PRO TIP: Microsoft Copilot 4:50
-
Key Takeaways 1:27
-
Formulas & Functions
Chương 5 Data Analysis with Pivot Tables 14 bài · 1 giờ 1 phút
-
Section Introduction 0:46
-
The Section Project & Dataset 2:11
-
IMPORTANT: Data Structure 1:33
-
Creating a Pivot Table 6:25
-
Modifying Pivot Table Views 5:28
-
PRO TIP: Automatic Date Grouping 2:23
-
Summarize Values By Options 9:57
-
Show Values As Calculations 9:37
-
Sorting & Filtering 9:05
-
PRO TIP: Slicers & Timelines 3:22
-
Calculated Fields 4:59
-
PRO TIP: Microsoft Copilot 4:15
-
Key Takeaways 1:19
-
Pivot Tables
Chương 6 Data Visualization with Charts & Graphs 14 bài · 1 giờ 10 phút
-
Section Introduction 0:57
-
The Section Project & Dataset 2:18
-
Why Visualize Data? 2:52
-
Creating a Basic Chart 4:09
-
Choosing the Right Chart Type 2:16
-
Line & Area Charts 12:24
-
Bar & Column Charts 7:30
-
Combo Charts 7:44
-
Pie & Donut Charts 8:23
-
Histograms 7:19
-
Scatterplots 8:35
-
Maps 4:20
-
Key Takeaways 1:05
-
Charts & Graphs
Chương 7 FINAL PROJECT: Traffic Safety Analysis 7 bài · 26 phút
-
Project Brief 0:49
-
ASSIGNMENT: Identify Seasonal Patterns
-
SOLUTION: Identify Seasonal Patterns 8:14
-
ASSIGNMENT: Visualize Weekly Trends
-
SOLUTION: Visualize Weekly Trends 6:26
-
ASSIGNMENT: Analyze Contributing Factors
-
SOLUTION: Analyze Contributing Factors 10:40
Chương 8 Next Steps 1 bài
-
BONUS LESSON
Requirment
-
Microsoft Excel 365 (some functionality may be unavailable on other versions)
-
No advance preparation is required
Outcomes
-
Learn how to create and manage worksheets and navigate the Microsoft Excel interface using keyboard shortcuts
-
Build foundational data literacy skills, including managing, exploring, analyzing and visualizing data
-
Write spreadsheet formulas and functions to aggregate values, create logical tests, join data, and manipulate text and dates
-
Use Pivot Tables to explore and analyze data using custom aggregations & calculations, sorting & filtering, and more
-
Learn data visualization and storytelling best practices, and bring data to life using common charts and graphs
0 Student
9 Courses
0 review