PRDV004: Course Feedback Survey | Saylor Academy

© Saylor Academy 2010-2024 except as otherwise noted. Excluding course final exams, content authored by Saylor Academy is available under a Creative Commons Attribution 3.0 Unported license. Third-party materials are the copyright of their respective owners and shared under various licenses. See detailed licensing information. Saylor Academy®, Saylor.org®, and Harnessing Technology to Make Education Free® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Syllabus

Introduction to Excel

Cells, Columns, Rows, and Formulas

Entering, Editing, and Managing Data

Unit 1 Assessment

Basic Features of Spreadsheet Software

Copying and Pasting Data

How to Add a Note or Comment

Using Formulas

Basic Functions

Graphs and Tables

Charts and Graphs in Microsoft Excel

Unit 2 Assessment

Using Microsoft Excel to Create a Family Budget

How To Make A Budget In Google Sheets

How to Create an Income Statement

Sample Work Estimate: Jack's Auto Repair

Unit 3 Assessment

Course Feedback Survey

PRDV004: Certificate Final Exam

Course Feedback Survey

Course Introduction

Course Syllabus

Unit 1: Getting Started with Spreadsheets

1.1: Identifying Parts of a Spreadsheet

Introduction to Excel

Cells, Columns, Rows, and Formulas

1.2: Entering and Editing Data in Spreadsheets

Entering, Editing, and Managing Data

Unit 1 Assessment

Unit 1 Assessment

Unit 2: Basic Commands and Functions

2.1: Formatting Data

Basic Features of Spreadsheet Software

Copying and Pasting Data

How to Add a Note or Comment

2.2: Using Spreadsheets to Create Simple Formulas

Using Formulas

Basic Functions

2.3: Creating Tables and Graphs of Data

Graphs and Tables

Charts and Graphs in Microsoft Excel

Unit 2 Assessment

Unit 2 Assessment

Unit 3: Spreadsheet Design and Implementation

3.1: Creating a Budget

Using Microsoft Excel to Create a Family Budget

How To Make A Budget In Google Sheets

How to Create an Income Statement

3.2: Creating an Invoice or Work Estimate

Sample Work Estimate: Jack's Auto Repair

Unit 3 Assessment

Unit 3 Assessment

Course Feedback Survey

Course Feedback Survey

Certificate Final Exam

PRDV004: Certificate Final Exam

Archived Materials