Universal Class: Over 500 Online Certificate Courses
 

Online Class: Excel 2016


$50.00
no certificate
- OR -
$75.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 20
    Lessons
  • 41
    Exams &
    Assignments
  • 12
    Hours
    average time
  • 1.2
    CEUs
  • 8,783
    Students
    have taken this course
 
 
 
 
 

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
 
 
 
 

Course Lessons

Average Lesson Rating:
4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(5,757 votes)

Lesson 1: Introduction to MS Excel 2016

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. 11 Total Points
  • Lesson 1 Video
  • Review Article: Three Cool Things to Try in Excel 2016
  • Complete: Lesson 1 Assignment
  • Complete: Exam 1

Lesson 2: Navigating Excel 2016

In this lesson, we?re going to focus on the major elements of Excel 2016 and take a few minutes to become familiar with their purpose. 11 Total Points
  • Lesson 2 Video
  • Review 2 Videos: Excel 2016 from Scratch - Introduction and Navigation; Excel 2016 Tutorial: Using the Quick Access Toolbar in Excel 2016
  • Complete: Lesson 2 Assignment
  • Complete: Exam 2

Lesson 3: Worksheets and Workbooks

Worksheets are stored in workbooks, and workbooks are the files that you actually save. 11 Total Points
  • Lesson 3 Video
  • Review 2 Articles: Use a shared workbook to collaborate in Excel 2016 for Windows; Move or copy worksheets or worksheet data
  • Complete: Lesson 3 Assignment
  • Complete: Exam 3

Lesson 4: Entering Information into MS Excel 2016

Starting to enter information is as simple as clicking on a cell in the spreadsheet and typing, but there are some things that are helpful to know ? and that you can do ? before you ever type that first letter or number. 11 Total Points
  • Lesson 4 Video
  • Review 3 Articles: Entering and Editing Data in Excel 2016; Create a drop-down list in Excel 2016 for Mac; Change axis labels in a chart in Office 2016
  • Complete: Lesson 4 Assignment
  • Complete: Exam 4

Lesson 5: Introduction to Working with Cells, Rows, and Columns

If you want to move data from its original location and relocate it somewhere else, you must cut the data, then paste it somewhere else. You can cut or copy cells, rows, columns, or entire worksheets. 10 Total Points
  • Lesson 5 Video
  • Review 3 Articles: Insert or delete cells, rows, and columns; Select cells, ranges, rows, or columns on a worksheet; How to Freeze Rows and Columns in Excel 2016
  • Complete: Lesson 5 Assignment
  • Complete: Exam 5

Lesson 6: Formatting Data and Cells

Taking the time to format a worksheet can take it from the black and white page of data and gridlines to something that looks professional and attractive. 11 Total Points
  • Lesson 6 Video
  • Review 2 Articles: Format numbers as currency in Excel 2016; Guidelines for organizing and formatting data on a worksheet
  • Complete: Lesson 6 Assignment
  • Complete: Exam 6

Lesson 7: Formatting Rows and Columns

In Excel 2016, the width of a column is determined by how many characters that can be displayed within a cell. 11 Total Points
  • Lesson 7 Video
  • Complete: Lesson 7 Assignment
  • Complete: Exam 7

Lesson 8: Editing Cells, Rows, Columns, and Worksheets

Excel 2016 makes creating ? and editing ? spreadsheets a lot easier because correcting errors is easy mess free. 11 Total Points
  • Lesson 8 Video
  • Review 2 Articles: Find or replace text and numbers on a worksheet in Excel 2016 for Windows; How to use Find and Replace in Excel most efficiently
  • Review Video: Playing With Find and Replace Options Microsoft Excel 2016 Beginner Course
  • Complete: Lesson 8 Assignment
  • Complete: Exam 8

Lesson 9: Introduction to Formulas and Calculations

If you use spreadsheets to do accounting for a business, track totals, invoice customers, or anything that requires mathematics, Excel?s ability to calculate formulas is going to save you errors and headaches. 11 Total Points
  • Lesson 9 Video
  • Review Article: Guidelines and examples of array formulas in Excel 2016 for Windows
  • Complete: Lesson 9 Assignment
  • Complete: Exam 9

Lesson 10: Working with Formulas and Functions

In Excel, a function is a predesigned formula that does a certain calculation. This can make it easier because you don?t have to construct every formula yourself. 10 Total Points
  • Lesson 10 Video
  • Review Article: Overview of formulas in Excel 2016 for Windows
  • Review Video: Working With Simple Formula Microsoft Excel 2016 Beginner Course
  • Complete: Lesson 10 Assignment
  • Complete: Exam 10

Lesson 11: Maintaining Worksheets

It?s important to learn how to maintain your worksheets to help you keep on top of all the information. 11 Total Points
  • Lesson 11 Video
  • Review 2 Articles: Consolidate data from multiple worksheets in a single worksheet in Excel 2016 for Windows; View two or more worksheets at the same time
  • Complete: Lesson 11 Assignment
  • Complete: Exam 11

Lesson 12: The What-If Analysis

A what-if analysis lets you explore possibilities by entering possible values into the same equation so you can see the possible outcomes in the cells of your spreadsheet. 11 Total Points
  • Lesson 12 Video
  • Review Article: Switch between various sets of values by using scenarios
  • Complete: Lesson 12 Assignment
  • Complete: Exam 12

Lesson 13: Adding Images and Graphics

You?ve already learned how to format a worksheet and enter information into Excel. Now we?re going to show you how to add elements such as graphics and images. 11 Total Points
  • Lesson 13 Video
  • Review 2 Articles: Add alternative text to a picture, shape, chart, table, or SmartArt graphic; How to Add Preset Graphic Shapes in Excel 2016
  • Complete: Lesson 13 Assignment
  • Complete: Exam 13

Lesson 14: Charts and Diagrams

Charts and diagrams are tools you can use to visually represent the data in a worksheet. 11 Total Points
  • Lesson 14 Video
  • Review 3 Articles: Create a chart in Excel 2016 for Mac; Create a waterfall chart in Office 2016; New Charts in Excel 2016
  • Complete: Lesson 14 Assignment
  • Complete: Exam 14

Lesson 15: Creating Data Lists

A data list or a database table are types of worksheets that aren?t used to calculate values, but to store information, such as names and addresses of clients or perhaps a library of books. 10 Total Points
  • Lesson 15 Video
  • Review 2 Articles: Create a drop-down list in Excel 2016 for Windows; Sort a list of data in Excel 2016 for Mac
  • Complete: Lesson 15 Assignment
  • Complete: Exam 15

Lesson 16: Managing Data

A form is simply a dialog box that lets you display or enter information one record (or row) at a time. It can also make the information more visually appealing and easier to understand. 11 Total Points
  • Lesson 16 Video
  • Review 2 Articles: Using a form for data entry; Add, edit, find, and delete rows by using a data form
  • Complete: Lesson 16 Assignment
  • Complete: Exam 16

Lesson 17: Pivot Tables and Pivot Charts

A pivot table sounds more difficult and confusing than it really is. Most people say they don?t like pivot tables, or they don?t understand them. In truth, they?re not that difficult at all. 10 Total Points
  • Lesson 17 Video
  • Review 2 Articles: Create a PivotTable in Excel 2016 for Mac; Create a PivotChart in Excel 2016 for Windows
  • Review Video: How to Create a Dashboard Using Pivot Tables and Charts in Excel
  • Complete: Lesson 17 Assignment
  • Complete: Exam 17

Lesson 18: Printing Worksheets and Workbooks

Headers appear at the top of a worksheet. Footers appear at the bottom. Both can contain page numbers, and headers often contain the title of the worksheet and perhaps the date. 11 Total Points
  • Lesson 18 Video
  • Review 3 Articles: Preview worksheet pages before you print; Print a worksheet in landscape or portrait orientation; Print a sheet or workbook in Excel 2016 for Mac
  • Complete: Lesson 18 Assignment
  • Complete: Exam 18

Lesson 19: Templates

Templates are worksheets that are already designed for you. 11 Total Points
  • Lesson 19 Video
  • Review 2 Articles: Create and use your own template; Learn how to use the My Cashflow template with Excel 2016
  • Complete: Lesson 19 Assignment
  • Complete: Exam 19

Lesson 20: Protecting, Saving, and Sharing Workbooks

Add protection to worksheets so that they can?t be edited by other people. You can lock cells or an entire worksheet. 111 Total Points
  • Lesson 20 Video
  • Take Poll: Let us know what you think of this course
  • Complete: Lesson 20 Assignment
  • Complete: Exam 20
  • Complete: The Final Exam
316
Total Course Points
 

Additional Course Information

Online CEU Certificate
  • Document Your Lifelong Learning Achievements
  • Earn an Official Certificate Documenting Course Hours and CEUs
  • Verify Your Certificate with a Unique Serial Number Online
  • View and Share Your Certificate Online or Download/Print as PDF
  • Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media
Document Your CEUs on Your Resume
 
Course Title: Excel 2016
Course Number: 8900368
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Computer Skill (Self-Paced, Online Class)
CEU Value: 1.2 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Instructor: UniversalClass Staff Instructor
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $50.00 (no CEU Certification) || with Online CEU Certification: $75.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$50
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$75
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
Best Value
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
ALL COURSES
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
 
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete Monthly
No. of courses 500+
 

Student Testimonials

  • "All the parts of the course were helpful to be honest. It was a new experience to me." -- Kiara S.
  • "Great class." -- Edmund G.
  • "Video tutorials were excellent." -- Bonita W.
  • "All of it was helpful since I did not know it." -- Thomas M.
  • "I enjoyed listening to the instructor's videos. Every single lesson had good instruction." -- David L.
  • "No comments the instructor was great." -- Deborah T.
  • "All was very well organized." -- Alicia R.
  • View More Testimonials...

Related Courses

  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • QuickBooks 101
    QuickBooks 101
    QuickBooks® Course Introduction QuickBooks® is an accounting software program created by Intuit® for small businesses and self-employed professionals. It can be used for almost all financial business processes. You can use it for ent...
    $80.00
    1.4 CEUs 14h
  • Microsoft Word 2016
    Microsoft Word 2016
    Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn everything you need t...
    $75.00
    0.8 CEUs 8h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 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 addr...
    $125.00
    4.6 CEUs 46h
  • Social Media Marketing 101
    Social Media Marketing 101
    The importance for modern businesses to understand the need for a strategic social media presence cannot be understated. From creating an outlet to directly connect with consumers, to providing insight into buying behavior, to boosting SEO rankings,...
    $75.00
    1.0 CEUs 10h
  • Microsoft Visio 2016
    Microsoft Visio 2016
    Microsoft Visio 2016 is a program used to create diagrams and drawings of all types and for all purposes. Unlike the basic diagram functions found in other Office programs, such as Word or Excel, Visio offers advanced drawing and diagram functions t...
    $75.00
    0.7 CEUs 7h
  • Outlook 2016
    Outlook 2016
    Microsoft Outlook 2016 is the email client and personal information organizer that comes with the Microsoft Office Suite. In this course, we're going to teach you how to effectively use nearly every aspect of Outlook, from sending, receiving, and or...
    $75.00
    0.5 CEUs 5h
  • Microsoft Publisher 2016
    Microsoft Publisher 2016
    Publisher 2016 is Microsoft's entry-level desktop publishing program, allowing you to quickly create publications for the web or print. You can easily create professional-looking publications by either creating them yourself from scratch or using o...
    $75.00
    0.7 CEUs 7h
  • OneNote 2016
    OneNote 2016
    OneNote 2016 is a note-taking program that comes bundled with the Microsoft Office 2016 suite. Whereas MS Word is a word processing program that you can use to create documents, OneNote is simply a note taking program that you can use to take notes ...
    $75.00
    0.5 CEUs 5h
  • Microsoft Project 2016
    Microsoft Project 2016
    Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...
    $75.00
    0.8 CEUs 8h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    $85.00
    0.9 CEUs 9h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    $75.00
    0.7 CEUs 7h
  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    $75.00
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...
    $75.00
    1.7 CEUs 17h
  • MySQL
    MySQL
    If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...
    $80.00
    1.0 CEUs 10h
  • OS X Yosemite
    OS X Yosemite
    OS X Yosemite is the latest version of the OS X operating system released by Apple on June 2, 2014. It can be installed on any Mac device that meets the general specification requirements and can be installed for free by going to the Apple App Store...
    $75.00
    0.7 CEUs 7h
  • Windows 10
    Windows 10
    Windows 10 is the latest version of the Windows operating system released by Microsoft on June 29, 2015. It follows Windows 8 and Windows 8.1, which introduced some of the biggest changes to the operating system since the first release in 1985. Wind...
    $75.00
    0.5 CEUs 5h
  • Excel 2016
    Excel 2016
    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...
    $75.00
    1.2 CEUs 12h
 
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.