Introduction to Spreadsheets
LEARNING GOALS:
- We are learning how to use spreadsheet software to input, organize and format data in a spreadsheet program called Microsoft Excel.
Overview
In this activity, you will learn the basics about cell addresses, rows/columns, and data entry. After watching a presentation demonstrating spreadsheet design and formatting, you will complete a matching exercise.
In this activity, you will learn the basics about cell addresses, rows/columns, and data entry. After watching a presentation demonstrating spreadsheet design and formatting, you will complete a matching exercise.
Microsoft Excel is a Spreadsheet Software
Spreadsheet software is designed to process numbers just as word processor software processes words. Here is a typical spreadsheet, showing rows (numbers down the left side) and columns (letters along the top of the working area):
Spreadsheet software is designed to process numbers just as word processor software processes words. Here is a typical spreadsheet, showing rows (numbers down the left side) and columns (letters along the top of the working area):
Tutorial 1 : Getting Started with Excel
Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007. We will show you how to use and modify the Ribbon and the Quick Access Toolbar, and how to create new workbooks and openexisting ones. After this lesson, you will be ready to get started on your first workbook.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Excel is a spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your way around the Excel 2010 environment, including the new Backstage view, which replaces the Microsoft Button menu from Excel 2007. We will show you how to use and modify the Ribbon and the Quick Access Toolbar, and how to create new workbooks and openexisting ones. After this lesson, you will be ready to get started on your first workbook.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Tutorial 2 : Cell Basics
You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyze, and organize data. In this lesson, you will learn how to select cells, insert content, and delete cells and cell content. You will also learn how to cut, copy, and paste cells; drag and drop cells; and fill cells using the fill handle.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
You will need to know the basic ways you can work with cells and cell content in Excel to be able to use it to calculate, analyze, and organize data. In this lesson, you will learn how to select cells, insert content, and delete cells and cell content. You will also learn how to cut, copy, and paste cells; drag and drop cells; and fill cells using the fill handle.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Tutorial 3 : Modifying Columns, Rows and Cells
When you open a new, blank workbook, the cells are set to a default size. You have the ability to modify cells, as well as to insert and delete columns, rows, and cells as needed. In this lesson, you will learn how to change row height and column width, insert and delete rows and columns, wrap text in a cell, and merge cells.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
When you open a new, blank workbook, the cells are set to a default size. You have the ability to modify cells, as well as to insert and delete columns, rows, and cells as needed. In this lesson, you will learn how to change row height and column width, insert and delete rows and columns, wrap text in a cell, and merge cells.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Tutorial 4 : Formatting Cells
Spreadsheets that have not been formatted can be difficult to read. Formatted text and cells can draw attention to specific parts of the spreadsheet and make the spreadsheet more visually appealing and easier to understand. In Excel, there are many tools you can use to format text and cells. In this lesson, you will learn how to change the color and style of text and cells, align text, and apply special formatting to numbers and dates.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Spreadsheets that have not been formatted can be difficult to read. Formatted text and cells can draw attention to specific parts of the spreadsheet and make the spreadsheet more visually appealing and easier to understand. In Excel, there are many tools you can use to format text and cells. In this lesson, you will learn how to change the color and style of text and cells, align text, and apply special formatting to numbers and dates.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Tutorial 5 : Saving
Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone who does not have Excel 2010? There are many ways you share and receive workbooks, which will affect how you need to save the file. In this lesson, you will learn how to use the Save and Save As commands, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Are you saving a workbook for the first time? Saving it as another name? Sharing it with someone who does not have Excel 2010? There are many ways you share and receive workbooks, which will affect how you need to save the file. In this lesson, you will learn how to use the Save and Save As commands, how to save as an Excel 97-2003 compatible workbook, and how to save as a PDF.1) Read these instructions OR watch this video.
2) Try this task.
3) Do not save.
Activity 1 Exercises
Download this Excel Workbook and complete the activities on the two worksheets.
Download this Excel Workbook and complete the activities on the two worksheets.
