This content is viewable by Everyone
Office 365: Excel Training
- Audience: Faculty, Staff, Student
- Service Category: Email & Collaboration
- Owner Team: Email and Office 365
-
Service:Office 365: Excel
Excel Online
Learn the Interface
To get the most out of Excel Online, you'll need to familiarize yourself with its interface. Explore the ribbon tool bar and the Tell Me search box for locating tools, and discover how to use the view modes and zoom function. Learn more about navigating the interface.
Interface Training
- 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, how to use the version history, manage and work with multiple worksheets, and how to print your workbooks. Learn more about printing and sharing an Excel workbook.
Workbook Training
- 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
You have several options when you want to enter data manually 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. And, there are several settings that you can adjust to make data entry easier for you. Learn more about entering data.
Data Manipulation Training
Format Data
Microsoft Office Excel has a number of features that make it easy to manage and analyze data. To take full advantage of these features, it is important that you organize and format data in a worksheet according to the following guidelines. Learn more about organizing and formatting data.
Data Format Training
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 (previously known as an Excel list) or present your data in a chart.
Table and Chart Training
- 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 for the web so you can work with others in real-time, leave comments, and use @mentions to send others notifications.