Course Syllabus

 

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 2016 and will teach you how to use them, starting with the simple and working to the most complicated.  The good news is that Excel 2016 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. 
  • Completely Online
  • Self-Paced
  • Printable Lessons
  • Full HD Video  
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • Describe what MS Excel 2016 is and what its capabilities include.
  • Demonstrate navigating Excel 2016.
  • Summarize worksheet and workbook management.
  • Summarize working with cells, rows, and columns.
  • Demonstrate formatting data and cells.
  • Demonstrate formatting rows and columns.
  • Demonstrate editing cells, rows, columns, and worksheets.
  • Summarize working with formulas and functions.
  • Define The What-If Analysis.
  • Demonstrate adding images, charts, and diagrams.
  • Summarize creating data lists.
  • Describe working with Pivot Tables and Pivot Charts.
  • Demonstrate printing worksheets and workbooks.
  • Describe using and creating templates.
  • Demonstrate protecting, saving, and sharing workbooks.
  • Demonstrate mastery of lesson content at levels of 70% or higher.
 
 

Assessment Guide

Assessment Points
Lesson 1 Assignment 1 points
Exam 1 10 points
Lesson 2 Assignment 1 points
Exam 2 10 points
Lesson 3 Assignment 1 points
Exam 3 10 points
Lesson 4 Assignment 1 points
Exam 4 10 points
Lesson 5 Assignment 1 points
Exam 5 9 points
Lesson 6 Assignment 1 points
Exam 6 10 points
Lesson 7 Assignment 1 points
Exam 7 10 points
Lesson 8 Assignment 1 points
Exam 8 10 points
Lesson 9 Assignment 1 points
Exam 9 10 points
Lesson 10 Assignment 1 points
Exam 10 9 points
Lesson 11 Assignment 1 points
Exam 11 10 points
Lesson 12 Assignment 1 points
Exam 12 10 points
Lesson 13 Assignment 1 points
Exam 13 10 points
Lesson 14 Assignment 1 points
Exam 14 10 points
Lesson 15 Assignment 1 points
Exam 15 9 points
Lesson 16 Assignment 1 points
Exam 16 10 points
Lesson 17 Assignment 1 points
Exam 17 9 points
Lesson 18 Assignment 1 points
Exam 18 10 points
Lesson 19 Assignment 1 points
Exam 19 10 points
Lesson 20 Assignment 1 points
Exam 20 10 points
The Final Exam 99 points
Excel 2016 and the What-If Analysis
Excel 2016 and the What-If Analysis
Ultimate Excel Training Bundle
Ultimate Excel Training Bundle
Microsoft Excel Courses
Microsoft Excel Courses
Microsoft Access 2019
Microsoft Access 2019
Business Writing Courses
Business Writing Courses
The Use of Twitter for Marketing Strategies
The Use of Twitter for Marketing Strategies
Computer Literacy Level 2 - Internet Basics
Computer Literacy Level 2 - Internet Basics
Cybersecurity 101
Cybersecurity 101
Microsoft Word Courses
Microsoft Word Courses
What Can You Do With Microsoft Excel 2019?
What Can You Do With Microsoft Excel 2019?
How to Add and Edit Images, Graphics, and TextBoxes in Excel 2019
How to Add and Edit Images, Graphics, and TextBoxes in Excel 2019
Operations Management Courses
Operations Management Courses
QuickBooks Courses
QuickBooks Courses
Communications Courses
Communications Courses
How to Use the Mail App for All Your Email Accounts in OS X Yosemite
How to Use the Mail App for All Your Email Accounts in OS X Yosemite
Microsoft Publisher 2021
Microsoft Publisher 2021
Make Your Spreadsheets Pop with Sparklines in Excel 2019
Make Your Spreadsheets Pop with Sparklines in Excel 2019
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook
Microsoft Office 2021: Word, Excel, PowerPoint and Outlook