Microsoft Excel: Learn Modern Excel for Data Analysis (2025)
Last updated 4/2025
Created by Maven Analytics • 1,500,000 Learners,Enrique Ruiz
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Level: All | Genre: eLearning | Language: English + subtitle | Duration: 85 Lectures ( 6h 0m ) | Size: 3.24 GB

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

The Complete Microsoft Excel Course: Beginner to Expert
Published 4/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Language: English | Duration: 2h 38m | Size: 1.5 GB

Master Microsoft Excel from the Ground Up - Learn Formulas, Functions, Pivot Tables, Data Analysis, Automation, & More!



What you'll learn
Basic Excel Interface: Navigating the Ribbon and Workbooks
Basic Arithmetic Operations: Addition, Subtraction, Multiplication, Division
Understanding Cell References: Relative, Absolute, and Mixed
Statistical Functions: (AVERAGE, SUM, COUNT, EOUND, MAX, MIN)
Sorting and Filtering Data
Using VLOOKUP and HLOOKUP Functions
Conditional Formatting: Highlight Cell Rules, Data Bars, Color Scales
Creating Basic Charts: Line, Bar, Pie, and Scatter Plots
Power Pivot: Data Modeling and Analysis
Macro Recording and VBA Basics
Data Validation and Error Handling
Create a daily sales report with deshboard

Requirements
No prior Excel experience needed! Start from scratch and build up your skills.

Description
Welcome to The Complete Microsoft Excel Course: Beginner to Expert! Whether you're completely new to Excel or looking to refine your skills, this course is designed to take you from the basics to advanced Excel mastery.Microsoft Excel is one of the most essential skills in today's job market. Whether you're a student, business professional, data analyst, or entrepreneur, mastering Excel can significantly improve your efficiency, decision-making, and career growth. This all-in-one course is designed to take you from absolute beginner to advanced expert, covering everything from basic spreadsheet skills to automation with VBA. Beginner Level:You'll start by learning the basic layout of Excel-how to navigate the Ribbon, understanding the Workbook and Worksheet structure, and how to use basic commands and shortcuts.You'll learn how to enter and format data, including adjusting columns, rows, font sizes, and applying styles.Introduction to essential Excel functions like SUM, AVERAGE, MIN, MAX, and basic arithmetic operations.Learn how to organize data with sorting tools and filter large datasets to find specific information.Intermediate Level:Intermediate Formulas: Deepen your understanding of functions, including IF, COUNTIF, VLOOKUP, and INDEX for more complex calculations.Charts and Graphs: Learn how to create different types of charts (bar, line, pie, etc.) to visually represent data.Conditional Formatting: Understand how to apply conditional formatting rules to highlight important trends or values in your data.PivotTables: Introduction to PivotTables, which allows you to summarize, analyze, and explore your data in a dynamic way.Advanced Level:Advanced Formulas: Master functions like MATCH, INDIRECT, OFFSET, and array formulas for more sophisticated tasks.Power Query: Learn to automate data transformation and cleaning processes using Power Query, making it easier to work with large datasets.Macros and VBA: Introduction to automating tasks with Excel Macros and writing custom Visual Basic for Applications (VBA) code to streamline workflows.Data Analysis Tools: Explore Excel's more advanced data analysis capabilities, including Solver, Data Tables, Scenario Manager, and Goal Seek.Dashboard Creation: Learn to create dynamic dashboards that summarize data visually for better decision-making.Expert Tips and Tricksiscover time-saving tips, including keyboard shortcuts, advanced data manipulation techniques, and ways to work more efficiently.How to troubleshoot common errors in formulas or data inconsistencies.Practical Projects and Exercises:Many of these courses include real-world projects, case studies, and exercises where you can apply the skills you've learned. For example, creating financial reports, project management trackers, or business dashboards.By the end of this course, you'll be able to confidently use Excel for data analysis, reporting, business insights, and automation-whether for personal use, your job, or a professional career in finance, business, or data analytics. Ready to become an Excel expert? Enroll now and start mastering Excel today!

Who this course is for
Anyone learn everything from Excel basics to advanced features.
Work on real world examples and practical exercises.


Homepage

Excel Power Query Combo - Beginners + Advanced M language
Last updated 4/2023
Created by Abhay Gadiya
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Level: All | Genre: eLearning | Language: English | Duration: 72 Lectures ( 8h 20m ) | Size: 4.36 GB

Learn in built transformation to M Language, Power Query patterns, Custom M Functions, Parameters



What you'll learn
At the end of this Power Query Training you would understand basic to advanced level of M Language
Custom M Function, Parameters, Readymade Power Query Patterns
You would be able to perform various complex data cleansing activities using Power Query
You would be able to automate various task which would have taken long hours of work.

Requirements
You should have basic knowledge of using Excel.
You should be aware about Table feature in Excel.
You should have Excel 2010 / 2013 / 2016 version installed in your PC.
You would need to install Power Query if you are using Excel 2010 or 2013. (will be shown during the course intro)

Description
This course is COMBO of my two individual courses -Excel Power Query - BeginnersAdvanced Excel Power Query - M Language, troubleshoot, Custom M function, Power Query patternsHere are some of the reviews for above courses -"A great class - worth the money and time investment. Instructor convey's knowledge with a clear and concise approach. He continues to offer little nuggets of information where you will find yourself saying: 1 - "whoa - wait a second, rewind - he did what?" 2 - "WOW - now that is cool!" The level to training you receive from Abhay - well worth the investment. " - Bart W.Awesome, must for beginners and advanced users of Power Query. I simply had to question myself whether i should enroll in multiple courses or this single course? And deciding factor for me was learning in multiple courses would have been similar and enrolling in this single course i would have learn more areas compared to multiple courses. - Morgan SethAbhay has produced an excellent course on how to manage some of the more complex tasks in PQ. In particular the thought processes applied in utilising patterns in data cleansing are extremely useful in understanding how to massage data into a usable format. A Goto video for me when struggling to get data how I want. - Mike PeaseIt seems to be the course on Power Query that I was looking for. I had enrolled into multiple course but learned the same thing over again, this course covered lot of things. Better to enroll into this one course instead of multiple courses. - MGAt the outset I thank you for showing interest in this course. In this video I will provide overview of all the contents of this course and what are basic requirements before you enroll into this course. So let's get started. There are four major areas I will be covering as part of this course. The first one is for troubleshooting the Power Query errors and workaround for limitation of Power Query. In real any software is not foolproof and has its own limitation. Also, if you don't use the software as programmed you may encounter errors. And I hope you would agree that error codes or description in most of the software are not that user friendly or they do not provide appropriate solution to resolve the error. Hence in this first section I will show some of the common areas where you face Power Query limitation and errors. Some of them are as follows: Error encountered with adding / rename / deleting a particular column headings. Handling null values during arithmetic calculation. Identify error rows encountered while creating or on refresh of query. Multiplying effect when you JOIN queries Issues with filters and how to use advanced filters. Then the next area is for advanced case studies. Similar to my starter course of Excel Power Query where I have shown you more than 20+ real life case studies of applying power query, here also I have taken some real life case studies which require some more in depth knowledge of Power Query and workaround. This section will be updated new case studies as and when I see some interesting datasets. The current video are related to Applying local setting when converting the dates fields Leave dataset which needed leave details to be broken into separate rows from a single cell. Unstack the dataset which has uneven details Combine multiple rows data back to single cell. Then next section is for advanced M concepts. Here I will give you more information related to M Language in Power Query. What syntax is to be used under advanced editor. How to create parameters and use it inside your power query. How to create new custom M function using PQ interface or through advanced editor. I will also show how you can troubleshoot the custom M function you have created using advanced editor. Then I will show you how you can organize your multiple queries in separate groups. Further I will also show how to use Query Dependency view which will give you visual presentation of all the queries inside your excel file. This will help you understand the flow of all the data from source till the final output, where it is loaded or which queries are referenced to each other. All precedents and dependents to your queries can be easily identified. And now finally in last section I will be providing some readymade patterns for power query. I will provide all the power query code which you can copy paste into your file and start using it. You will not need to create any new query for these patterns. Since creating these patterns using power query requires lot of efforts and also very complex I am providing you these as ready to use. So now before you enroll I would like to tell you that there are few requirements. First one is that you should have latest version of Power Query installed if you are using Excel 2010 / 2013 or if you are using Excel 2016 then it should be updated. Second and most important is that you should have prior knowledge of using Power Query. So that is it. There are no further requirements other than these two. So what are you waiting for, enroll now into the course.

Who this course is for
Novice Excel user to Advanced Excel users
People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
IT specialists who performs Extract Transform & Load (ETL) activities for business

Excel Macros and VBA Masterclass
Published 3/2025
Created by Yusuf Onabekun
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Level: All | Genre: eLearning | Language: English | Duration: 8 Lectures ( 1h 16m ) | Size: 481 MB

Mastering Excel Macros and VBA for Beginners



What you'll learn
Understanding Excel Macros
Excel VBA Fundamentals
Control Structures and Loops in Excel VBA
Excel Productivity with Excel Macros and VBA

Requirements
No experience in Excel VBA Needed. You will learn everything in the course

Description
Master Excel Macros & VBA and Automate Your Workflow Like a Pro!Are you tired of doing the same repetitive tasks in Excel over and over again? Do you wish you could automate your spreadsheets and make Excel work for you instead of the other way around? If so, you're in the right place!Welcome to the Excel Macros and VBA Masterclass - the ultimate course designed to help you unlock the full power of Excel automation. Whether you're an absolute beginner or someone who has dabbled in Excel VBA before, this course will take you from zero to hero in no time!Why Learn Excel Macros and Excel VBA?Save Hours of Work - Automate boring, repetitive tasks and focus on what truly matters. Boost Your Productivity - Make Excel do all the heavy lifting with just a click of a button. Enhance Your Career Prospects - Excel VBA is a highly sought-after skill in many industries. Eliminate Errors - Reduce human mistakes by using well-structured macros and scripts.What You'll Learn in This Course:Understanding Excel Macros - Learn what macros are and how they can transform the way you work with Excel.How to Record and Assign Macros to a Button - Master the easiest way to start automating Excel tasks instantly.Excel VBA Fundamentals - Dive deep into the world of VBA programming and understand variables, data types, and more.Control Loops and Structures in Excel VBA - Learn how to create efficient loops that streamline your workflow.Manipulating Ranges and Cells in Excel VBA - Get hands-on with modifying Excel data dynamically using VBA.Error Handling and Debugging - Discover how to troubleshoot your VBA code like a pro and ensure smooth execution.Who Is This Course For?Excel users who want to step up their game with automation.Data analysts looking to speed up their reporting and data processing.Accountants & finance professionals who deal with large datasets and calculations.Anyone who wants to master Excel Macros and Excel VBA and make their work life easier!What Makes This Course Different?Beginner-Friendly Yet Comprehensive - We start from scratch and gradually introduce advanced concepts. Step-by-Step Guidance - Each lesson is carefully designed to ensure you grasp every concept with ease. Lifetime Access - Learn at your own pace and revisit the course anytime.Ready to Take Your Excel Skills to the Next Level?Don't let manual tasks slow you down. Join the Excel Macros and VBA Masterclass today and start automating Excel like a pro!Enroll Now and Start Automating!

Who this course is for
Excel Enthusiasts

Excel: Managing and Analyzing Data (2025)
Released 04/2025
With Oz du Soleil
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Skill level: Intermediate | Genre: eLearning | Language: English + subtitle | Duration: 4h 47m 4s | Size: 843 MB

Learn to clean, manage, and analyze data in Excel efficiently using modern tools like Power Query, dynamic arrays, and PivotTables to extract meaningful insights.

Course details
In this course, Oz du Soleil-an Excel MVP, author, and trainer with a passion for clean data and reliable reporting-equips you with the skills to effectively manage and analyze large or complex datasets in Excel. Learn how to check data quality, clean and organize data, and leverage Excel's advanced tools like Power Query and dynamic arrays. Find out how to split columns, structure data, and combine datasets while maintaining integrity and scalability. Plus, get an introduction to sorting, filtering, and PivotTable techniques, along with essential functions and visualization tools for clear data representation. When you complete the course, you will be proficient in transforming raw data into actionable insights and enhancing decision-making processes.


Homepage