What you’ll learn
Extract and count unique entries using Dynamic Array Functions.
Differentiate between unique and distinct values in Excel spreadsheets.
Utilize SORT and SORTBY functions for data organization and analysis.
Employ FILTER functions with logical operators for precise data filtration.
Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
Perform complex lookups efficiently using XLOOKUP and XMATCH functions.
Develop custom formulas with LET and LAMBDA functions for tailored analysis.
Create and manage data models with Power Pivot, including table relationships.
Clean and manipulate data effectively using Power Query functionalities.
Automate repetitive tasks and customize Excel with macros and VBA.
Requirements
An active Microsoft 365 account to access Excel is beneficial to follow along.
An intermediate-level knowledge of Excel. This is an advanced course.
Description
**This course includes downloadable course instructor files and exercise files to work with and follow along.**
Welcome to the Microsoft Excel 365 Advanced course. In this course, you will delve into advanced features of Excel 365 to enhance your data analysis and productivity skills.
You’ll explore dynamic array formulas, unlocking the power of functions like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn to perform complex lookups and reference functions, even with multiple criteria and duplicate values. Moreover, you’ll discover how to create your own functions using LET and LAMBDA, empowering you to tailor formulas to your needs.
Master Power Pivot and Power Query to manage and analyze vast datasets effortlessly. Gain insights into advanced PivotTable and Pivot Chart techniques, including customization and dynamic labels, and harness the potential of form controls and checkboxes to create interactive Excel applications.
Then, delve into Excel macros and VBA to automate repetitive tasks and customize Excel functionalities. Finally, experience the future of Excel with AI tools like Microsoft Copilot and ChatGPT, enabling you to generate datasets, seek assistance, and streamline your workflow efficiently.
By the end of this course, you should have the proficiency to utilize the advanced features of Microsoft Excel 365, empowering you to tackle complex data analysis tasks with confidence. Join us in this comprehensive journey and unlock new productivity levels in your spreadsheet endeavors.
In the course, you will be able to:
Extract and count unique entries using Dynamic Array Functions.
Differentiate between unique and distinct values in Excel spreadsheets.
Utilize SORT and SORTBY functions for data organization and analysis.
Employ FILTER functions with logical operators for precise data filtration.
Generate random arrays and values with RANDARRAY and RANDBETWEEN functions.
Perform complex lookups efficiently using XLOOKUP and XMATCH functions.
Develop custom formulas with LET and LAMBDA functions for tailored analysis.
Create and manage data models with Power Pivot, including table relationships.
Clean and manipulate data effectively using Power Query functionalities.
Automate repetitive tasks and customize Excel with macros and VBA.
This course includes:
6+ hours
of video tutorials
73 individual video
lectures
Course and exercise files
to follow along
Certificate
of completion
Who this course is for:
Users with intermediate knowledge of Excel and those coming from an older stand-alone version of Excel.
Finance professionals who wants to improve financial modeling and analysis capabilities.
Users who have Microsoft Excel foundation and seeking to advance their Excel knowledge.
