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.
Learn how to format spreadsheets with formulas and functions, build multi-page spreadsheets, chart data, create tables with database features, and create pivot tables.
This course is intended for students who have a basic understanding of spreadsheets and are ready to delve into formatting, formulas and functions, multi-page spreadsheets, charting data, creating tables with database features, and pivot tables. Note that this course builds on PRDV004, so please take the time to review this course to review basic formatting commands of Excel and Google Sheets. Note that each unit in this course builds on the previous unit so make sure you have mastered each unit before you move on.
This course includes the following units:
Upon successful completion of this course, you will be able to:
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.
The primary learning materials for this course are readings, 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 to 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.
Only the final exam is considered when awarding you a grade for this course. In order to pass this course, you will need to earn a 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 to, 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.
Provide details about any other learning activities or projects here, as well.
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 set schedule to follow. We estimate that the "average" student will take 5 hours to complete this course. We recommend that you work through the course at a pace that is comfortable for you and allows you to make regular progress. It's a good idea to also schedule your study time in advance and try as best as you can to stick to that schedule.
Learning new material can be challenging, so we've compiled a few study strategies to help you succeed:
In order to take this course, you should have completed PRDV004: Spreadsheets.
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 to attempt any auto-graded course assessments and the final exam.
This course is entirely free to enroll in and to access. Everything linked in the course, including textbooks, videos, webpages, and activities, are all available for no charge. This course also contains a free final exam and course completion certificate.