Microsoft Excel 365 Intermediate (2024)

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.
Description
***Exercise and demo files included***
In this Microsoft Excel 365 Intermediate course, you'll delve deeper into Excel's powerful features to enhance your spreadsheet skills. You'll learn to design better spreadsheets for improved readability and efficient data management.
You'll explore logical functions to make better decisions and streamline data analysis, work with lookup formulas for data retrieval, and master sorting and filtering techniques to organize data effectively.
Furthermore, you'll explore advanced features like statistical and mathematical functions, enabling you to perform complex calculations effortlessly. Gain insights into formatting techniques to present your data professionally. You'll also learn to handle date, time, text, and arrays for comprehensive data manipulation.
You'll also explore the analytical capabilities of PivotTables and Pivot Charts, empowering you to analyze data dynamically and create insightful visualizations. Additionally, you'll learn to add interaction to PivotTables and Charts, making your reports more interactive and engaging.
Formula auditing and data validation techniques will ensure accuracy and reliability in your work. Finally, you'll discover what-if analysis tools to forecast scenarios and make informed decisions.
By the end of this course, you should have the skills to efficiently manage data, perform complex analyses, and create compelling reports in Microsoft Excel 365. Join us to take your Excel proficiency to the next level.
In this course, you will learn how to
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.
This course includes
9 hours
of video tutorials
97 individual video
lectures
Course and exercise files
to follow along
Certificate
of completion
Who this course is for
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.
Homepage

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

Microsoft Excel 365 Intermediate (2024) Fast Download
Microsoft Excel 365 Intermediate (2024) Full Download