Universal Class: Over 500 Online Certificate Courses
 

Course Syllabus: Excel 2016


Microsoft Training Picture
$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
 
 
 
Office Hours: Continuous
Course Meeting Times: Continuous
 

Course Description

Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products.  Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery lists, tracking expenses, creating invoices and bills, accounting, balance checkbooks and other financial accounts, as well as any other purpose that requires a spreadsheet or table. 

This course will cover the many features of Excel and how to use them, starting with the simple and working to the most complicated.  The good news is that Excel makes everything easy.  By learning how to navigate the program and where to find each feature, operating Excel can become a breeze.

This course will teach you how to:

·    Create a spreadsheet

·    Format cells, rows, columns, and entire worksheets so they fit and match your data

·    Enter data into a spreadsheet

·    Use formulas and functions for math, accounting, and totaling.

·    Create formulas and functions

·    Calculate data

·    Create charts and diagrams for your data

·    Create data lists and forms

·    Create and use pivot tables and pivot charts.

·    Work with Excel templates

·    Share and protect your worksheets and workbooks

·    Use What-If Analysis to determine possible outcomes.  For example, sales goals

·    And much more
 

 

This course was designed to teach you skills you'll need to successfully use Excel 2016.   Each lesson contains instructions and illustrations to show you how to use the features, then walks you through step-by-step so you can see how everything is done.  You don't need previous experience with Excel to be able to complete this course.  This course will start with basic skills, then move forward to more advanced features and techniques.  Although you do not need access to Excel 2016 for this course; it is highly recommended. A free trial of Excel 2016 is available on the Microsoft website. 

Course Requirements

This course will not require you to have previous experience in any particular area but you should have the following:

- Access to MS PowerPoint 2016(recommended) *

- a high school reading level.

Course Goals

This course will teach you how to:

  • Create a spreadsheet
  • Format cells, rows, columns, and entire worksheets so they fit and match your data
  • Enter data into a spreadsheet
  • Use formulas and functions for math, accounting, and totaling.
  • Create formulas and functions
  • Calculate data
  • Create charts and diagrams for your data
  • Create data lists and forms
  • Create and use pivot tables and pivot charts.
  • Work with Excel templates
  • Share and protect your worksheets and workbooks
  • Use What-If Analysis to determine possible outcomes.  For example, sales goals
  • And much more

Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to MS PowerPoint 2016.

Grading Policy

Each lesson will include a lesson review exam along with an assignment. Students will successfully complete this course with 70% or better.

 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Demonstrate mastery of lesson content at levels of 70% or higher.

Assessment Guide

Lesson 1 AssignmentAssignment1
Exam 1Exam10
Lesson 2 AssignmentAssignment1
Exam 2Exam10
Lesson 3 AssignmentAssignment1
Exam 3Exam10
Lesson 4 AssignmentAssignment1
Exam 4Exam10
Lesson 5 AssignmentAssignment1
Exam 5Exam9
Lesson 6 AssignmentAssignment1
Exam 6Exam10
Lesson 7 AssignmentAssignment1
Exam 7Exam10
Lesson 8 AssignmentAssignment1
Exam 8Exam10
Lesson 9 AssignmentAssignment1
Exam 9Exam10
Lesson 10 AssignmentAssignment1
Exam 10Exam9
Lesson 11 AssignmentAssignment1
Exam 11Exam10
Lesson 12 AssignmentAssignment1
Exam 12Exam10
Lesson 13 AssignmentAssignment1
Exam 13Exam10
Lesson 14 AssignmentAssignment1
Exam 14Exam10
Lesson 15 AssignmentAssignment1
Exam 15Exam9
Lesson 16 AssignmentAssignment1
Exam 16Exam10
Lesson 17 AssignmentAssignment1
Exam 17Exam10
Lesson 18 AssignmentAssignment1
Exam 18Exam10
Lesson 19 AssignmentAssignment1
Exam 19Exam10
Lesson 20 AssignmentAssignment1
Exam 20Exam10
The Final ExamExam100
Total Points:317
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2017 Universal Class™ All rights reserved.