Course Syllabus
Welcome to PRDV006: Spreadsheets II: Formatting and Functions
Specific information about this course and its requirements can be found below. For more general information about taking Saylor Academy courses, including information about Community and Academic Codes of Conduct, please read the Student Handbook.
Course Description
Learn how to format spreadsheets to make them easy to read, apply conditional formatting to draw attention to critical data, use formulas and functions, build multi-page spreadsheets, and add 3-dimensional formulas and functions across multiple worksheets and workbooks.
Course Introduction
In this course, we explore how to format spreadsheet data to make the information easy to read and apply conditional formatting to draw attention to critical data. We will use formulas and functions with absolute and relative references to perform mathematical, statistical, financial, lookup, and logical computations. Then, we will learn how to build multi-page spreadsheets, add three-dimensional formulas to summarize data across several worksheets, and implement formulas and functions to present the consolidated information that exists in multiple workbooks.
This course builds on the concepts and skills covered in Saylor Academy's introductory PRDV004: Spreadsheets course, which introduces the definition of a spreadsheet, how to navigate and enter data, open and save files, format spreadsheets, and enter basic formulas and functions for real-life applications. Each unit in this course builds on the previous unit, so make sure you have mastered each unit before moving on.
This course includes the following units:
- Unit 1: Formatting Spreadsheets
- Unit 2: Mathematical Computations
- Unit 3: Logical Functions
- Unit 4: Lookup Functions
- Unit 5: Multi-Page Spreadsheets
Course Learning Outcomes
Upon successful completion of this course, you will be able to:
- use formatting features to format text, cells, and numbers, and use conditional formatting as appropriate;
- write basic formulas and use functions SUM, AVERAGE, COUNT, MAX, MIN, PMT, and FV to perform basic, statistical, and financial calculations;
- use logical functions including IF, OR, AND, NOT, COUNTIF, AVERAGEIF(S), and SUMIF(S) to summarize data;
- use lookup functions, including VLOOKUP, HLOOKUP, and XLOOKUP to retrieve data from a worksheet; and
- format multiple worksheets at one time and use 3-dimensional references.
Throughout this course, you will also see learning outcomes in each unit. You can use those learning outcomes to help organize your studies and gauge your progress.
Course Materials
This course's primary learning materials are articles, lectures, and videos.
All course materials are free to access and can be found in each unit of the course. Pay close attention to the notes that accompany these course materials, as they will tell you what to focus on in each resource and will help you understand how the learning materials fit into the course as a whole. You can also see a list of all the learning materials in this course by clicking on Resources in the navigation bar.
Evaluation and Minimum Passing Score
Only the final exam is considered when awarding you a grade for this course. To pass this course, you will need to earn a grade of 70% or higher on the final exam. Your score on the exam will be calculated as soon as you complete it. If you do not pass the exam on your first try, you may take it again as many times as you want, with a 7-day waiting period between each attempt. Once you have successfully passed the final exam, you will be awarded a free Course Completion Certificate.
There are also end-of-unit assessments in this course. These are designed to help you study and do not factor into your final course grade. You can take these as many times as you want until you understand the concepts and material covered. You can see all of these assessments by clicking on Quizzes in the course's navigation bar.
Tips for Success
PRDV006: Spreadsheets II: Formatting and Functions is a self-paced course, which means that you can decide when you will start and when you will complete the course. There is no instructor or an assigned schedule to follow. We estimate that the "average" student will take 11 hours to complete this course. We recommend that you work through the course at a comfortable pace that allows you to make regular progress. It's also a good idea to schedule your study time in advance and try to stick to that schedule as best as you can.
Learning new material can be challenging, so we've compiled a few study strategies to help you succeed:
- Take notes on the various terms, practices, and theories that you come across. This can help you put each concept into context and will create a refresher that you can use as you study later on.
- As you work through the materials, take some time to test yourself on what you remember and how well you understand the concepts. Reflecting on what you've learned is important for your long-term memory and will make you more likely to retain information over time.
Technical Requirements
This course is delivered entirely online. You will be required to have access to a computer or web-capable mobile device and have consistent access to the internet to either view or download the necessary course resources and attempt any auto-graded course assessments and the final exam.
- To access the full course, including assessments and the final exam, you will need to log in to your Saylor Academy account and enroll in the course. If you do not already have an account, you may create one for free here. Although you can access the course materials without logging in to your account, you should log in to maximize your course experience. For example, you cannot take assessments or track your progress unless you are logged in.
For additional guidance, check out Saylor Academy's FAQ.
Fees
This course is entirely free to enroll in and access. Everything linked in the course, including textbooks, videos, webpages, and activities, is available for no charge. This course also contains a free final exam and course completion certificate.