Microsoft Excel: Learn Modern Excel for Data Analysis

Build foundational Excel skills for data analysis: Learn formulas, charts, and pivot tables with fun, hands-on projects!

  • 0.0 (0 Reviews)
  • 0 Students
  • 90 Lessons
  • Maven Analytics (2,000,000+ Learners)

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.

See more

FAQ

FAQ area empty

Course curriculum

8 chương 90 bài học 5 giờ 54 phút 7 bài học thử miễn phí
Chương 1 Getting Started
Chương 2 Introducing Microsoft Excel
Chương 3 Spreadsheet Fundamentals
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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

Instructor

...
Maven Analytics (2,000,000+ Learners)

0.0

  • ... 0 Student
  • ... 9 Courses
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all