MCCC Knowledge Base

Excel (Office 365): Overview and Usage

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.

0 (0)
Article Rating (No Votes)
Rate this article
Attached Files
There are no attachments for this article.
Comments
There are no comments for this article. Be the first to post a comment.
Name
Email
Related Articles RSS Feed
Microsoft Teams (Office 365): Overview and Usage
Viewed 8250 times since Wed, Oct 16, 2019
InTouch - Interactive Lessons Part 2: Sway
Viewed 3581 times since Thu, Feb 22, 2018
Office 365 - Changing current user in Microsoft Office 2013
Viewed 6510 times since Thu, Jan 8, 2015
Set up Outlook for iOS - iPhone/iPad
Viewed 53362 times since Wed, Sep 20, 2017
Creating and Using a Shared Workbook in Excel
Viewed 6028 times since Tue, Feb 16, 2016
Faculty - Embedding Office 365 Files in Blackboard
Viewed 21958 times since Tue, May 23, 2017
Office 365 - Microsoft Office Installation - Common Issues
Viewed 9402 times since Thu, May 14, 2015
Office 365 - Access - Database "already in use" error when saving database
Viewed 6865 times since Mon, Apr 6, 2015
PowerPoint (Office 365): Overview and Usage
Viewed 7040 times since Mon, Oct 21, 2019
Office 365 - PowerPoint - YouTube Embedding Errors on Windows 10
Viewed 5337 times since Tue, Feb 14, 2017

Need Help?