SOPHIA will be down Wednesday, December 7, 2016 at 4:30 AM (CST) for a little housecleaning. We are sorry if this causes you any trouble. The outage should last less than 5 minutes.

+
Excel - Basic Spreadsheet Formatting and Editing

Excel - Basic Spreadsheet Formatting and Editing

Author: Kellie Polando
Description:
  1. To learn how to create, edit, and format an Excel Workbook to organize data
  2. To develop an understanding of how organization of information affects the ability of the user/viewer to comprehend its meaning

In this lesson you will learn how to edit an excel spreadsheet.  The ability to clearly represent data is important if the data is to be meaningful and useable.  Excel allows for the collection and calculation of data.  The more organized the data is the easier it is to use the data to create tables and graphs and calculations

(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial

Lesson Instructions

Step 1

Watch the basic editing video - 13 minutes

Step 2

Watch Inserting and Deleting Rows and Columns - 2 minutes

Step 3

Watch MS Excel to Google Docs Video - 8 Minutes

 

Step 4

Computer Tech Students see Aspen for further instructions

 

Basic Editing Video

Basic Excel Editing - Part 2, Inserting and Deleting Rows and Columns

MS Excel vs. Google Docs Spreadsheets

Google docs provide a limited interface for spreadsheets. Google is free and allows for multiple users to interact with a document at the same time. Because of this it is great for Middle and High School users.