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
Office 365 - Access - Database "already in use" error when saving database
Viewed 5844 times since Mon, Apr 6, 2015
Creating and Using a Shared Workbook in Excel
Viewed 5173 times since Tue, Feb 16, 2016
Get Started with Office 365 for Business - Video
Viewed 4544 times since Tue, Oct 27, 2015
Office 365 - Planner - Creating a Plan
Viewed 3852 times since Wed, Apr 26, 2017
Set up Outlook for iOS - iPhone/iPad
Viewed 42169 times since Wed, Sep 20, 2017
Office 365 - Change Your Time Zone
Viewed 9587 times since Wed, Apr 8, 2015
Setting a profile photo for Office 365
Viewed 5428 times since Wed, Jun 22, 2016
Office 365 - Changing current user in Microsoft Office 2013
Viewed 5490 times since Thu, Jan 8, 2015
What’s New in Office 2016
Viewed 4805 times since Thu, Apr 6, 2017
PowerPoint (Office 365): Overview and Usage
Viewed 3854 times since Mon, Oct 21, 2019

Need Help?