Topic outline

  • Course Introduction

    This course will provide you with a comprehensive introduction to spreadsheets. The course is designed for first-time users with very little or no exposure to the subject. For this course, you will use Microsoft Excel as the software. The course will explore the following fundamental topics: an introduction to spreadsheets, terminology in Excel, components of a spreadsheet, what a cell consists of, and the creation of a spreadsheet for practical use. You will examine sample files, videos, and books that will enable you to gain practical knowledge about spreadsheets that can be used in daily life, either at work, school, or home.

    Page: 1
  • Unit 1: Getting Started with Spreadsheets

    In this unit, you will learn about the power and flexibility of spreadsheets, using Microsoft Excel. This unit will briefly survey the history and background of Excel. There are two subunits that contain specific content that will provide an introduction to Excel. As you become more familiar with the software, you will start to overcome any fear about learning spreadsheet software. This unit and this course will help you become more productive in using spreadsheets at work and for personal applications. For example, in this unit, you will see two practical examples of using a spreadsheet: to create a family budget and to create a work estimate.

    Page: 1Quiz: 1
  • Unit 2: The Composition of a Spreadsheet

    The best way to learn something is to gain hands-on experience with it. This unit will focus on the steps required to assemble columns and rows and enter data to create a spreadsheet. You will also learn how to create formulas. In this unit, you will study and re-create a sample spreadsheet for tracking sales for a mock business. Tracking sales or creating a sales forecast for a business is just one of many professional applications of an Excel spreadsheet.

    Page: 1Quiz: 1
  • Unit 3: Spreadsheet Design and Implementation

    The final unit of this course will build upon the concepts discussed in the previous units. You will apply what you have learned by creating a spreadsheet that can be used in a real world environment. The design of the columns and rows allows you and those who view your spreadsheet to quickly understand how the cells relate to one another. If you set up your spreadsheet correctly, you will be able to make quick data calculations. For example, you could quickly demonstrate the costs for specific services or products to potential clients. Also, spreadsheet functions can be used with home budgeting, grade averaging, quotes, invoices, cost analysis, etc. Do not be afraid to experiment, as spreadsheets can be instrumental to saving time in our business and personal lives.

    Page: 1Quiz: 1
  • Course Evaluation Survey

    Please take a few moments to provide some feedback about this course at the link below. Consider completing the survey whether you have completed the course, you are nearly at that point, or you have just come to study one unit or a few units of this course.

    Link: Course Evaluation Survey (HTML)

    Your feedback will focus our efforts to continually improve our course design, content, technology, and general ease-of-use. Additionally, your input will be considered alongside our consulting professors' evaluation of the course during its next round of peer review. As always, please report urgent course experience concerns to contact@saylor.org and/or our Discourse forums.

  • Final Exam

    Quiz: 1