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: Mon, Dec 13, 2021 at 9:46 AM
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 18299 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
Set up Outlook for Android
Viewed 61630 times since Mon, Feb 19, 2018
Office 365 - Microsoft Office Installation - Common Issues
Viewed 13258 times since Thu, May 14, 2015
Office 365 - Change Your Time Zone
Viewed 15191 times since Wed, Apr 8, 2015
Office 365 - PowerPoint - YouTube Embedding Errors on Windows 10
Viewed 7286 times since Tue, Feb 14, 2017
Office 365 - What is Microsoft Office 365?
Viewed 10013 times since Fri, Oct 30, 2015
Sway (Office 365): Overview and Usage
Viewed 18343 times since Fri, Nov 8, 2019
OneNote (Office 365): Overview and Usage
Viewed 18641 times since Thu, Nov 7, 2019
Office 365 - Planner - Creating a Plan
Viewed 6955 times since Wed, Apr 26, 2017
Microsoft Outlook (Office 365): Overview and Usage
Viewed 26842 times since Thu, Oct 17, 2019
Remote Access to Microsoft Office Desktop Applications for Students
Viewed 1410 times since Mon, Feb 21, 2022

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