Udemy – Microsoft Excel 365 Advanced 2024-5

Udemy – Microsoft Excel 365 Advanced 2024-5 Downloadly IRSpace

Apr 17, 2025 - 20:38 Updated: Aug 17, 2025 - 15:29

0 0

Udemy – Microsoft Excel 365 Advanced 2024-5

Microsoft Excel 365 Advanced Course In this course, we delve deep into the advanced features of Excel 365 to enhance your data analysis and productivity skills. You’ll learn about dynamic array formulas and discover the power of functions like SORT, FILTER, and XLOOKUP to efficiently manipulate data. You will learn to perform complex lookups and reference functions even with multiple criteria and duplicate values. Additionally, you’ll discover how to create your own custom functions using LET and LAMBDA, allowing you to tailor the formulas to suit your needs. Manage and analyze massive data effortlessly by mastering Power Pivot and Power Query. Learn advanced pivot table and pivot chart techniques, including customization and dynamic labels, and take advantage of the potential of form controls and checkboxes to create interactive Excel programs. Then, delve into Excel macros and VBA to automate repetitive tasks and customize Excel functions. Finally, experience the future of Excel with AI tools like Microsoft Copilot and ChatGPT that allow you to generate datasets, request help, and streamline your workflow efficiently. At the end of this course, you should have the skills to use the advanced features of Microsoft Excel 365 to confidently perform complex data analysis tasks. Join us on this comprehensive journey and discover new levels of productivity in working with your spreadsheets.

What you will learn in the Microsoft Excel 365 Advanced course

Extracting and counting unique entries using dynamic array functions
Distinguish between unique and distinct values in Excel spreadsheets
Use SORT and SORTBY functions to organize and analyze data
Use FILTER functions with logical operators to filter data precisely
Generating random arrays and values with the RANDARRAY and RANDBETWEEN functions
Perform complex lookups efficiently using the XLOOKUP and XMATCH functions
Develop custom formulas with LET and LAMBDA functions for personalized analysis
Create and manage data models with Power Pivot, including tabular relationships
Clean and effectively manipulate data using Power Query capabilities
Automate repetitive tasks and customize Excel with macros and VBA

Who is this course suitable for?

Users with intermediate knowledge of Excel and people using an older standalone version of Excel.
Financial professionals who want to improve their financial modeling and analysis capabilities.
Users who have basic knowledge of Microsoft Excel and are looking to improve their Excel knowledge.

Microsoft Excel 365 Advanced course specifications

Publisher: Udemy
Lecturer: Simon Sez IT
Training level: beginner to advanced
Training duration: 6 hours and 24 minutes
Number of courses: 76

Udemy – Microsoft Excel 365 Advanced 2024-5