MCCC Knowledge Base
Home » Categories » Multiple Categories

Excel (Office 365): Overview and Usage

Article ID: 6077 | permalink | Rating: 1/5 from 1 votes | Last Updated: Fri, Oct 18, 2019 at 3:55 PM
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.

Posted - Fri, Oct 18, 2019 at 1:27 PM. This article has been viewed 10300 times.
Filed Under: Microsoft Office, Office 365
1 (1)
Article Rating (1 Votes)
You've Already Voted.
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
Faculty - Embedding Office 365 Files in Blackboard
Viewed 25986 times since Tue, May 23, 2017
Office 365 - Change Your Time Zone
Viewed 11936 times since Wed, Apr 8, 2015
How to open .pages file using Microsoft Word
Viewed 581180 times since Tue, Feb 16, 2016
Setting a profile photo for Office 365
Viewed 9081 times since Wed, Jun 22, 2016
Word (Office 365): Overview and Usage
Viewed 11984 times since Fri, Oct 18, 2019
Office 365 - What is Microsoft Office 365?
Viewed 7513 times since Fri, Oct 30, 2015
Faculty, Staff, and Administrators - Turn Off Skype from Opening Automatically
Viewed 512 times since Tue, May 11, 2021
Set up Outlook for iOS - iPhone/iPad
Viewed 63658 times since Wed, Sep 20, 2017
Sway (Office 365): Overview and Usage
Viewed 9950 times since Fri, Nov 8, 2019
Briefing Email from Cortana
Viewed 560 times since Wed, Oct 14, 2020

Need Help?



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