PRDV252: Intermediate Excel

Course Syllabus for "PRDV252: Intermediate Excel"

Please note: this legacy course does not offer a certificate and may contain broken links and outdated information. Although archived, it is open for learning without registration or enrollment. Please consider contributing updates to this course on GitHub (you can also adopt, adapt, and distribute this course under the terms of the Creative Commons Attribution 3.0 license). To find fully-supported, current courses, visit our Learn site.

This class is intended for students who have a basic understanding of spreadsheets and are now ready to delve deeper into formatting, formulas and functions, multi-page spreadsheets, charting data, creating tables that have database features, and be introduced to pivot tables. This class was designed to be an active, hands-on class. You will be creating Excel® spreadsheets and have files to open and follow along as you progress through the units. This class is not intended for a specific occupation or activity, but when you are finished with this class, you will be able to use Excel® in a variety of circumstances to format and manipulate numerical data. Although the resources in this course use Microsoft Excel® 2010, it should be noted that all of the skills and tasks that you will be asked to complete can be done in any version of Excel®. If you stay flexible enough in your thinking and search out the commands and icons on whatever software you are using, you will succeed.

Learning Outcomes

Upon successful completion of this course, you will be able to:

  • use formatting features to format text, cells, and numbers, including dates;
  • explain the various uses for conditional formatting;
  • write formulas for sum, average, maximum, minimum, and count;
  • use common functions such as IF, COUNT, and PMT to formulate calculations;
  • describe the categories of functions in the Insert Function dialog box;
  • explain the difference between a pie chart and a column chart, and understand when to use each appropriately;
  • describe the function of Sparklines;
  • rename and format worksheet tabs;
  • describe how to use Headers and Footers, including how to format them in the Page Setup dialog box;
  • show formulas in the Formulas view and print them on one page;
  • explain how to create, name, sort, and filter a Table; and
  • create and format a PivotTable and PivotChart.

Course Requirements

In order to take this course, you must:

√    have access to a computer;

√    have continuous broadband Internet access;

√    have the ability/permission to install plug-ins or software (e.g., Adobe Reader or Flash);

√    have the ability to download and save files and documents to a computer;

√    have the ability to open Microsoft files and documents (.doc, .ppt, .xls, etc.);

√    have competency in the English language; and

√    have read the Saylor Student Handbook.
It is assumed you have completed the PRDV004 course or have read through it and have a basic knowledge of Excel®, including the ability to:
√    define the basic principles of spreadsheets;

√    differentiate between workbooks, sheets, cells, rows, and columns;

√    identify tabs and toolbars in the Microsoft Excel® window;

√    save and print a spreadsheet; and

√    use the SUM function to aid in working with data.

Course Information

Welcome to PRDV252: Intermediate Excel®. General information on this course and its requirements can be found below.
Course Designer: Professor Chris Wilkins
Primary Resources: This course is comprised of a range of different free and online materials. However, the course makes primary use of the following materials:

Requirements for Completion: In order to complete this course, you will need to work through each unit and all of its assigned materials. Pay special attention to Units 3–5 as they are the heart of the software and how to use Excel® to your mathematical advantage. You should also complete and practice activities when presented at the end of some units. This will help prepare you for the Final Exam. Note that you will only receive an official grade on your Final Exam.
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 tabulated as soon as you complete it. If you do not pass the exam, you may take it again.
Time Commitment: This course should take approximately 30 hours to complete. The 10 units are designed to take about 3 hours each.
Tips/Suggestions: Open your own version of Excel® as you go along and do the work that you are seeing. Doing is the fastest way to learn any software program. Think of this class as a hands-on class and dig into what you are learning and start exploring with whatever version of Excel® you have access to. Each unit includes a time advisory that lists the amount of time you should expect to spend on each subunit. These should help you plan your time accordingly.
Table of Contents: You can find the course's units at the links below.