Microsoft Excel 365 Advanced

Unlock the power of advanced Excel 365 features and boost your data analysis and productivity skills.

**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:

1. 6+ hours of video tutorials

2. 73 individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion