Loading...

PRDV252: Intermediate Excel

Unit 1: Revisiting the Fundamentals of Spreadsheets   This unit will review the basics of Spreadsheets. We will review commands on the Home and File Ribbons. We will look at some basic formatting techniques that will enhance the appearance of your worksheets including the formatting of text and numbers, using cell borders, and preparing a worksheet for printing. We will also review the most commonly used function of all, the SUM function, and we will be adding a simple chart to a worksheet. Each of these units will build upon the next so make sure that you have mastered this unit before moving on.

Unit 1 Time Advisory
Completing this unit should take you approximately 3 hours.

☐    Subunit 1.1: 1 hour

☐    Subunit 1.2: 1 hour

☐    Subunit 1.3: 30 minutes

☐    Subunit 1.4: 30 minutes

Unit1 Learning Outcomes
Upon successful completion of this unit, you will be able to: - edit data in a worksheet; - explain how to use Auto Fill and the Fill Handle when entering data; - explain how to adjust column widths and row heights; - explain how to insert, delete, hide, and unhide columns and rows; - create borders in a worksheet; - create a simple chart; - use the Sort command to rank data; - explain how to Move, rename, insert, and delete worksheet tabs; - explain how to Add headers and footers; and - prepare and print a worksheet or workbook.

1.1 Entering, Editing, and Formatting Data   - Reading: How to Use Microsoft Excel®: “Section 1.2” Link: How to Use Microsoft Excel®:“Section 1.2 (PDF)
 
Instructions: Go to Chapter 1: Fundamental Skills. We will be skipping over Section 1.1: An Overview of Microsoft Excel® as these are skills you should already have before joining this class. We will start with Section 1.2: Entering, Editing, and Managing Data on page 26. If you feel you need the extra prep work, go back through Section 1.1: An Overview of Microsoft Excel® before starting Section 1.2.
 
You will need to have your version of Excel® open and ready to follow along to create the document that will be used throughout Unit 1. Please save it to your desktop or flash-drive as Excel® Text Chapter 1as the chapter explains. As you work through the reading along with Excel®, if something is unclear in the directions/reading, refer to your Excel® spreadsheet and experiment to see if you get the results you are looking for by comparing them to the pictures that accompany the text.
 
Reading this section should take approximately 1 hour.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee.

1.2 Formatting and Data Analysis   - Reading: How to Use Microsoft Excel®: “Section 1.3” Link: How to Use Microsoft Excel®: Section 1.3 (PDF)
 
Instructions: Read through Section 1.3 beginning on page 54, and follow along to create the document you will seein the reading. The starting file will be the same file namedExcel® Text Chapter 1that you created in Subunit 1.1 above.
 
Reading this section should take approximately 1 hour.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee.

1.3 Printing   - Reading: How to Use Microsoft Excel®: “Section 1.4” Link: How to Use Microsoft Excel®: Section 1.4 (PDF)
 
Instructions: Read Section 1.4: Printing, which starts on page 86. Follow along using the Excel® file you created above namedExcel® Text Chapter 1.
 
Reading this section should take approximately 30 minutes.
 
Terms of Use: The textbook used in the link above is released under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License without attribution as requested by the work’s original creator or licensee

1.4 Exercises for Unit 1   - Activity: The Saylor Foundation’s “Practice Exercise for Unit 1” Link: The Saylor Foundation’s “Practice Exercise for Unit 1” (PDF)
 
Instructions: Open your Excel® program and follow the directions on the accompanying PDF document.
 
Completing this activity should take approximately 30 minutes.