Microsoft Excel 365 Bundle: Beginner to Advanced
Master and elevate your Microsoft Excel 365 skills with this great value 3-course bundle.
4.66 (74 reviews)
393
students
26 hours
content
Sep 2024
last update
$64.99
regular price
What you will learn
Access Microsoft 365, launch Excel, enhance efficiency with shortcuts, and navigate the interface.
Master the order of operations, the 'Big 6' basic Excel functions, VLOOKUP, XLOOKUP, and logical functions.
Differentiate absolute and relative referencing, create named ranges, and apply them in formulas.
Format numbers, cells, rows, and columns, and utilize conditional formatting.
Create Excel tables, sort, filter data, and visualize it with charts and sparklines.
Collaborate in Excel Online, co-author in real-time, and share workbooks seamlessly.
Implement data validation for accurate input control.
Utilize logical functions like AND, OR, and IF for decision-making.
Identify and handle duplicates in data using conditional formatting and formulas.
Apply statistical functions such as mean, median, and mode.
Analyze data using PivotTables and Pivot Charts for insights.
Perform what-if analysis using functions like PMT, Goal Seek, and Data Tables.
Extract and count unique entries using Dynamic Array Functions.
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.
6022260
udemy ID
6/13/2024
course created date
7/7/2024
course indexed date
ANUBHAV JAIN
course submited by