• Course Introduction

        • Time: 3 hours
        • Free Certificate
        This course is a comprehensive introduction to spreadsheets. The course uses Microsoft Excel. If you do not have Microsoft Excel, you may still take this course. You can download a 30-day trial of Microsoft Office here. You may also use other free spreadsheet software. For example, Google Sheets is available to anyone with a Google account. Last, remember that most colleges, universities, and some public libraries offer public computer stations with at least one spreadsheets program ready for you to use.

        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.

        First, read the course syllabus. Then, enroll in the course by clicking "Enroll me in this course". Click Unit 1 to read its introduction and learning outcomes. You will then see the learning materials and instructions on how to use them.

      • 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.

        Completing this unit should take you approximately 1 hour.

      • 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.

        Completing this unit should take you approximately 1 hour.

      • 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.

        Completing this unit should take you approximately 1 hour.

      • Course Feedback Survey

        Please take a few minutes to give us feedback about this course. We appreciate your feedback, whether you completed the whole course or even just a few resources. Your feedback will help us make our courses better, and we use your feedback each time we make updates to our courses.

        If you come across any urgent problems, email contact@saylor.org or post in our discussion forum.