This content is viewable by Everyone

Microsoft 365: Excel Training

Save

Audience: Faculty, Staff, Student
Service Category: Email & Collaboration
Owner Team: IT DWS Collaboration
Service:
Microsoft 365: Excel

Learn the Interface

To best utilize Excel Online, you'll need to familiarize yourself with its interface. Learn more about navigating the interface.

In addition to the desktop client, Microsoft Excel can be used on a mobile device (e.g. iOS and Android devices). Learn more about using Excel Mobile.

NOTE: Prior to using Excel for mobile devices, you will need to Enroll Your Mobile Device in Intune Company Portal.

Manage Workbooks

Excel Online handles your workbooks differently than other versions of Excel. Learn about the automatic save function, version history, manage and work with multiple worksheets, and how to print your workbooks. Learn more about printing and sharing an Excel workbook.

Enter and Manipulate Data

In Excel, you can enter data in one cell, in several cells at the same time, or on more than one worksheet at once. The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. Learn more about entering data.

Format Data

Microsoft Office Excel has a number of features that make it easy to manage and analyze data. Learn more about organizing and formatting data.

Using the Conditional Formatting Tools

Visualize Data in Tables and Charts

To make managing and analyzing a group of related data easier, you can turn a range of cells into an Excel table or present your data in a chart.

Pivot Tables

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Learn more about PivotTables.

Utilize Collaboration Tools

Share your workbook in Excel Online to work with others in real-time, leave comments, and use @mentions to send notifications to users.