This content is viewable by Everyone
Microsoft 365: Excel Training
- Audience: Faculty, Staff, Student
- Service Category: Email & Collaboration
- Owner Team: Email and Office 365
-
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.
- Office 365: Differences in Functionality between Excel for the Web and Excel Desktop
- Quick Start: See tips for Excel for the Web
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.
- Basic Tasks in Excel for the web
- Create a workbook in Excel for the web
- Keyboard shortcuts in Excel
- Learn more about Excel for the Web
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.
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.
- Create and format tables (video)
- Create a chart from start to finish (video)
- Create a diagram in Excel with the Visio Data Visualizer add-in
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.
- Create a PivotTable to analyze worksheet data (video)
- Use the Field List to arrange fields in a PivotTable (video)
- Change the source data range for a PivotTable
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.