Excel for Microsoft 365

Uncategorized

Wishlist

About Course

Learn how how Excel in Microsoft 365 can help you work faster and easier. Master the essential skills.

Course Content

Introduction

Getting started with Excel for Microsoft 365

01:05

Getting started with Excel

Entering Data

Formulas and Functions

Formatting

Adjusting worksheet and layout data

Adjusting Page Layout and Printing

Charts

Adjusting Worksheet Views

Multiple Worksheets and Workbooks

Data Management Features

Security and Sharing

Conclusion

Student Ratings & Reviews

No Review Yet

Enrollment validity: Lifetime

Intermediate
0 Total Enrolled
January 25, 2024 Last Updated
Certificate of completion

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.

Functional

Performance

Analytics

Others

Want to receive push notifications for all major on-site activities?

✕

×

About Course

Course Content

Introduction

Getting started with Excel for Microsoft 365

Getting started with Excel

What is Excel used for?

The Ribbon menu and the Quick Access Toolbar

Shortcut menus and the Mini toolbar

Understanding workbooks and worksheets

Use Excel Help

Chapter 1 Quiz

Entering Data

Exploring data entry, editing, and AutoFill

Working with dates and times

Using Undo and Redo

Use Save or Save As

Chapter 2 Quiz

Formulas and Functions

Using simple formulas

Copying a formula into adjacent cells

Using SUM and AVERAGE

XLOOKUP and lookup functions

Chapter 3 Quiz

Formatting

Exploring font styles, borders, and color backgrounds

Applying numeric formats

Adjusting row heights and column widths

Applying numeric formats

Chapter 4 Quiz

Adjusting worksheet and layout data

Rows and columns: Insert, delete, hide, and unhide

Moving, copying, and inserting data

Finding and replacing data

Chapter 5 Quiz

Adjusting Page Layout and Printing

Page Layout view and commands

Using Page Break and print set up and options

Chapter 6 Quiz

Charts

Creating charts

Exploring chart types

Chapter 7 Quiz

Adjusting Worksheet Views

Freezing and unfreezing panes

Splitting screens horizontally and vertically

Chapter 8 Quiz

Multiple Worksheets and Workbooks

Renaming, inserting, and deleting sheets

Moving, copying, and grouping sheets

Opening, closing, and saving workbooks

Chapter 9 Quiz

Data Management Features

Sorting data

Using filters

Creating PivotTables

Chapter 10 Quiz

Security and Sharing

Protecting worksheets and workbooks

Sharing workbooks and tracking changes

Chapter 11 Quiz

Conclusion

Continuing your Excel Journey

Student Ratings & Reviews

COOKIE NOTICE