Microsoft Excel 365 Intermediate (2024)
Published 5/2024
Duration: 8h59m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 5.44 GB
Genre: eLearning | Language: English

Explore advanced Excel features to streamline data analysis, enhance visualizations, and make informed decisions.

What you'll 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.

Requirements
An active Microsoft 365 account to access Excel is beneficial to follow along.
A beginner-level knowledge of Excel. This is an intermediate course.

https://www.udemy.com/course/microsoft-excel365-intermediate