Microsoft Excel 365 Intermediate

Welcome to the Microsoft Excel 365 Intermediate course, where you'll deepen your understanding of Excel's more advanced features to elevate your spreadsheet proficiency. Through this course, you'll enhance your ability to design and manage spreadsheets effectively for improved readability and data organization.

Throughout this course, you'll explore logical functions for better decision-making, lookup formulas for data retrieval, and sorting and filtering techniques for effective data organization.

Then, you'll explore advanced features such as statistical and mathematical functions, enabling you to handle complex calculations. Learn formatting techniques to present your data professionally and manipulate various data types, including date, time, text, and arrays.

Discover the analytical capabilities of PivotTables and Pivot Charts to analyze data and create insightful visualizations dynamically. Moreover, learn how to add interaction to your reports, enhancing their engagement and effectiveness.

By mastering formula auditing and data validation techniques, you'll ensure accuracy and reliability in your work. Finally, explore what-if analysis tools to forecast scenarios and make informed decisions confidently.

Upon completing this course, you should be able to efficiently manage data, conduct complex analyses, and generate compelling reports in Microsoft Excel 365. Join us to elevate your Excel skills today.

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.

Course Format

• This is a video-led course. You can preview some videos below.
• This course includes practice exercises.
• This course is aimed at Excel 365 users.

Course Certificate Included

This course includes an optional online quiz that will generate a course certificate upon completion.

14-Day Guarantee

We offer an unconditional, 14-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 14+ years and taught over 1 million students in that time. We’ve created over 130 software training courses, 8,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.