Microsoft Excel: Learn Modern Excel for Data Analysis

Descripción

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.

Lo que aprenderás

• 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

Requisitos

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