Microsoft Excel 365 Essentials

Microsoft Excel 365 Essentials
Published 5/2024
Duration: 3h26m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 2.37 GB
Genre: eLearning | Language: English

Master Excel's essential functions and formatting tools, empowering you to organize, analyze, and present data.

What you'll learn
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.

Requirements
An active Microsoft 365 account to access Excel is beneficial to follow along.
No prior experience needed, the course is for complete beginners.

Description
**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:
3+ hours
of video tutorials
41 individual video
lectures
Course and exercise files
to follow along
Certificate

of completion
Who this course is for:
Microsoft Excel novice.
No previous knowledge of Excel required. This course is created for absolute beginners.
Those who need an Excel refresher and want to improve their knowledge.
Users who have a foundation of Microsoft Excel and seeking to advance their Excel 365 knowledge.

More Info