课程详情

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 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 & FunctionsAnalyze 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 expose interesting patterns and trends__________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)__________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.

课程标签

0人关注该课程

主题相关的课程