Microsoft Excel: Learn Modern Excel for Data Analysis (2025)

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

What you'll learn
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

Requirements
Microsoft Excel 365 (some functionality may be unavailable on other versions)
No advance preparation is required

Description
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. You’ll work with unique, real-world datasets from Flight Delays to Sales Pipelines and apply the skills you learn every step of the way.COURSE OUTLINE:Introducing Microsoft ExcelCreate your first spreadsheet, navigate the Excel interface, and review the modern Excel landscapeSpreadsheet FundamentalsReview key spreadsheet concepts like data types, tables, cell references, number formatting, and sorting & filteringFormulas & FunctionsPerform calculations and manipulate data using formulas, including function syntax, reference types, and common errorsData Analysis with PivotTablesExplore and analyze data using pivot tables, including data structure, calculation options, and sorting & filteringData Visualization with Charts & GraphsVisualize data using the right chart type and apply deliberate formatting to tell a clear and compelling storyFINAL PROJECT: Traffic Safety AnalysisApply all the skills you've learned to analyze traffic accident data in NYC and find interesting patterns & trends to help the NYPD prevent future accidents__________Ready to dive in? Join today and get immediate, LIFETIME access to the following:6 hours of high-quality video5 quizzes5 projectsMicrosoft Excel Foundations ebook (90+ pages)Downloadable files & solutionsExpert support and Q&A forum30-day Udemy satisfaction guaranteeIf 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)

Who this course is for
Everyday people looking to build confidence and use data more effectively
Anyone seeking a comprehensive introduction to Microsoft Excel
Data professionals who want to build job-ready data management, analysis, and visualization skills