Microsoft Excel 365 Intermediate
Explore advanced Excel features to streamline data analysis, enhance visualizations, and make informed decisions.
4.72 (48 reviews)

167
students
9 hours
content
Apr 2024
last update
$74.99
regular price
What you will learn
Design spreadsheets for improved readability using cell styles.
Implement data validation for accurate input control.
Utilize logical functions like AND, OR, and IF for decision-making.
Perform lookup operations using VLOOKUP and INDEX/MATCH.
Sort and filter data efficiently using built-in Excel functions.
Identify and handle duplicates in data using conditional formatting and formulas.
Round values and perform special rounding using Excel's math functions.
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.
5911620
udemy ID
4/6/2024
course created date
5/10/2024
course indexed date
Bot
course submited by