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.
 
 

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 by mastering all learning outcomes with 70% or higher overall grade.

Assessment Guide

Lesson 1 Assignment1
Exam 110
Lesson 2 Assignment1
Exam 210
Lesson 3 Assignment1
Exam 310
Lesson 4 Assignment1
Exam 410
Lesson 5 Assignment1
Exam 59
Lesson 6 Assignment1
Exam 610
Lesson 7 Assignment1
Exam 710
Lesson 8 Assignment1
Exam 810
Lesson 9 Assignment1
Exam 910
Lesson 10 Assignment1
Exam 109
Lesson 11 Assignment1
Exam 1110
Lesson 12 Assignment1
Exam 1210
Lesson 13 Assignment1
Exam 1310
Lesson 14 Assignment1
Exam 1410
Lesson 15 Assignment1
Exam 159
Lesson 16 Assignment1
Exam 1610
Lesson 17 Assignment1
Exam 1710
Lesson 18 Assignment1
Exam 1810
Lesson 19 Assignment1
Exam 1910
Lesson 20 Assignment1
Exam 2010
The Final Exam100
Total Points:317
Show More

Recommended Books

Related Articles

Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.