Microsoft Excel 365 Intermediate

Explore advanced Excel features to streamline data analysis, enhance visualizations, and make informed decisions.
4.72 (48 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Microsoft Excel 365 Intermediate
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