Online College Courses for Credit

Excel - Basic Spreadsheet Formatting and Editing

Excel - Basic Spreadsheet Formatting and Editing

Author: Kellie Polando
  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

See More
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

29 Sophia partners guarantee credit transfer.

312 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 27 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


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.