Microsoft Excel 365 Advanced
Unlock the power of advanced Excel 365 features and boost your data analysis and productivity skills.
4.85 (43 reviews)
188
students
6.5 hours
content
Jul 2024
last update
$74.99
regular price
What you will 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.
5956480
udemy ID
5/4/2024
course created date
6/6/2024
course indexed date
Bot
course submited by