Microsoft Excel 365 Trung Cấp

**This course includes downloadable course instructor files and exercise files to work with and follow along.**

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:

1. 9 hours of video tutorials

2. 97 individual video lectures

3. Course and exercise files to follow along

4. Certificate of completion