Microsoft Excel 365 Intermediate

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

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I 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.

Target audience

• Users who have a basic knowledge of Microsoft Excel and wants to advance their skills.
• Those who need an Excel refresher.
• Users who have a foundation of Microsoft Excel and seeking to advance their Excel 365 knowledge.