Microsoft Excel 365 Essentials | Udemy

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

This Microsoft Excel 365 Essentials course will teach you the fundamental skills to use Excel efficiently and effectively. Starting with an overview of Excel, you will get comfortable with the ribbon, cursor options, and basic data entry techniques. This course is designed to help you master Excel’s powerful formatting features, formulas, and data management.

You will discover how to format numbers, styles, and tables to make your data visually appealing and easy to read. The course will introduce you to essential formulas, including how to use relative and absolute references. You will also learn about AutoFill and creating custom lists to speed up your work.

Conditional formatting will teach you to highlight important data using icons and color scales. Sorting and filtering techniques will help you organize and analyze large datasets effectively. You will also learn to manage large workbooks with tools like freeze panes, splitting, and printing options.

Charts are a vital part of data presentation, and you will learn how to create and format different types of charts, including column and pie charts. Additionally, you will practice inserting charts into PowerPoint for professional presentations.

By the end of this course, you should have a solid foundation in Excel 365, enabling you to handle various data-related tasks confidently. Each section includes practical exercises to reinforce your learning and ensure you can apply what you’ve learned. This course is perfect for beginners and those looking to refresh their Excel skills.

In this course, you will learn how to:

• Navigate the Excel ribbon and cursor options.
• Enter and format data effectively.
• Apply number and style formatting to tables.
• Use formulas with relative and absolute references.
• Utilize AutoFill and create custom lists.
• Implement conditional formatting based on cell content.
• Sort and filter data for better analysis.
• Create and format various types of charts.

This course includes:

1. 3+ hours of video tutorials
2. 41 individual video lectures
3. Course and exercise files to follow along
4. Certificate of completion