Skip to Content

Excel (Office 365): Overview and Usage

Estimated Reading Time: < 1 Minute
2019

Excel (Office 365): Overview and Usage

Excel online is a spreadsheet creation and editing tool that allows you to keep record of basic information to more complex data, formulas, and charts. 

Suggested uses for faculty:

Suggested uses for students:

Resources:

Introduction to Excel

Rows and columns

Cells

Formatting

Formulas and functions

Tables

Charts

PivotTables

Share and coauthor

Accessibility  

Make your Excel documents accessible to people with disabilities

 

Title: Useful Excel tricks to know  Select all: Select the box in the top left where the first row and first column meet to quickly highlight everything on the spreadsheet.   Fast navigation: Hold down Control (PC) or Command (MAC) and select any of the arrow to quickly move through the spreadsheet.   Values with zero: By default, if a value starts with zero, Excel deletes it. To prevent this, add a single quote mark before the zero (ex. ‘008765).  Add multiple rows at once: Select and highlight multiple rows at once and then go to Insert followed by Insert Sheet Rows to add multiple rows to your spreadsheet at one time.   Conditional formatting: Set up rules and apply formatting too easily interpret the data. Fro example, any data with a value of 70 or below has a rule to turn the cell red.

Excel (Office 365): Overview and Usage

Need Help?



Walk-up Hours of Operation - Located on the 3rd floor of the Advanced Technology Center
Phone: 215-641-6495
E-mail: helpdesk@mc3.edu
Phone support is available 24/7/365
Click Need Help? for chat support now!
Standard Hours:
Monday - Thursday: 7:30 am - 9:00 pm
Friday: 7:30 am - 5:00 pm
Saturday: 9:00 am - 1:00 pm
Winter Session:
Monday - Thursday: 7:30 am - 5:00 pm
Friday: 7:30 am - 5:00 pm
Saturday: 9:00 am - 1:00 pm