Online Class: Excel 2016

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.

$95.00
no certificate

- OR -

$120.00
with CEU Certificate*

Start Right Now!

$120.00 (with CEU Certificate)

Taking multiple courses? Save with our platinum program.

20

Lessons
41

Exams &
Assignments
15,686

Students
have taken this course
12

Hours
average time
1.2

CEUs

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.

Courses Frequently Bought Together:

Microsoft Word Level 1

QuickBooks 101

Microsoft Office: Word, Excel, PowerPoint and Outlook

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:

"Extraordinarily Helpful"

(11,791 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. Additional lesson topics: Three Cool Things to Try in Excel 11 Total Points

Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete: Lesson 1 Assignment
Assessment: 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. Additional lesson topics: Excel from Scratch; Excel Tutorial: Using the Quick Access Toolbar in Excel 11 Total Points

Lesson 2 Video
Complete: Lesson 2 Assignment
Assessment: Exam 2

Lesson 3: Worksheets and Workbooks

Worksheets are stored in workbooks, and workbooks are the files that you actually save. Additional lesson topics: Use a shared workbook to collaborate in Excel for Windows; Move or copy worksheets or worksheet data 11 Total Points

Lesson 3 Video
Complete: Lesson 3 Assignment
Assessment: 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. Additional lesson topics: Change axis labels in a chart in Office ; Entering and Editing Data in Excel ; Create a drop-down list in Excel for Mac 11 Total Points

Lesson 4 Video
Complete: Lesson 4 Assignment
Assessment: 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. Additional lesson topics: Select cells, ranges, rows, or columns on a worksheet; How to Freeze Rows and Columns in Excel ; Insert or delete cells, rows, and columns 10 Total Points

Lesson 5 Video
Complete: Lesson 5 Assignment
Assessment: 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. Additional lesson topics: Format numbers as currency in Excel ; Guidelines for organizing and formatting data on a worksheet 11 Total Points

Lesson 6 Video
Complete: Lesson 6 Assignment
Assessment: 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
Assessment: 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. Additional lesson topics: Find or replace text and numbers on a worksheet in Excel for Windows; Playing With Find and Replace Options Microsoft Excel Beginner Lecture; How to use Find and Replace in Excel most efficiently 11 Total Points

Lesson 8 Video
Complete: Lesson 8 Assignment
Assessment: 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. Additional lesson topics: Guidelines and examples of array formulas in Excel for Windows 11 Total Points

Lesson 9 Video
Complete: Lesson 9 Assignment
Assessment: 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. Additional lesson topics: Overview of formulas in Excel for Windows; Working With Simple Formula Microsoft Excel Beginner Lecture 10 Total Points

Lesson 10 Video
Complete: Lesson 10 Assignment
Assessment: 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. Additional lesson topics: Consolidate data from multiple worksheets in a single worksheet in Excel for Windows; View two or more worksheets at the same time 11 Total Points

Lesson 11 Video
Complete: Lesson 11 Assignment
Assessment: 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. Additional lesson topics: Switch between various sets of values by using scenarios 11 Total Points

Lesson 12 Video
Complete: Lesson 12 Assignment
Assessment: 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. Additional lesson topics: Add alternative text to a picture, shape, chart, table, or SmartArt graphic; How to Add Preset Graphic Shapes in Excel 11 Total Points

Lesson 13 Video
Complete: Lesson 13 Assignment
Assessment: Exam 13

Lesson 14: Charts and Diagrams

Charts and diagrams are tools you can use to visually represent the data in a worksheet. Additional lesson topics: Create a waterfall chart in Office ; New Charts in Excel ; Create a chart in Excel for Mac 11 Total Points

Lesson 14 Video
Complete: Lesson 14 Assignment
Assessment: 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. Additional lesson topics: Create a drop-down list in Excel for Windows; Sort a list of data in Excel for Mac 10 Total Points

Lesson 15 Video
Complete: Lesson 15 Assignment
Assessment: 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. Additional lesson topics: Using a form for data entry; Add, edit, find, and delete rows by using a data form 11 Total Points

Lesson 16 Video
Complete: Lesson 16 Assignment
Assessment: 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. Additional lesson topics: Create a PivotTable in Excel for Mac; Create a PivotChart in Excel for Windows; Introduction to Pivot Tables, Charts, and Dashboards in Excel Part 1 has good data to download for Pivot Table practice; How to Create a Dashboard Using Pivot Tables and Charts in Excel 10 Total Points

Lesson 17 Video
Complete: Lesson 17 Assignment
Assessment: 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. Additional lesson topics: Print a sheet or workbook in Excel for Mac; Preview worksheet pages before you print; Print a worksheet in landscape or portrait orientation 11 Total Points

Lesson 18 Video
Complete: Lesson 18 Assignment
Assessment: Exam 18

Lesson 19: Templates

Templates are worksheets that are already designed for you. Additional lesson topics: Create and use your own template; Learn how to use the My Cashflow template with Excel 11 Total Points

Lesson 19 Video
Complete: Lesson 19 Assignment
Assessment: 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. 110 Total Points

Lesson 20 Video
Lesson discussions: Let us know what you think of this course; Course Comments; Program Evaluation Follow-up Survey (End of Course)
Complete: Lesson 20 Assignment
Assessment: Exam 20
Assessment: The Final Exam

315

Total Course Points

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.

Additional Course Information

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

Course Title: Excel 2016

Course Number: 8900368

Lessons Rating: 4.3 / 5 Stars (11,791 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Microsoft Office Certification Courses

Availability: This course is online and available in all 50 states including: California, Florida, Georgia, Illinois, New York, Pennsylvania, Ohio, Texas, and Washington.

Last Updated: May 2024

Course Type: 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 Instructional Team

Syllabus: View Syllabus

Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$95

for 6 months

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$120

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	600+

Platinum 2 Years

ALL COURSES
Certificates & CEUs

$299

for 2 years

You save $79.00!

Start Now

Billed once
Includes all 600+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	24 Months
No. of courses	600+

Student Testimonials

"I don't think I realized how much there was to know about excel. This is a very thorough and well constructed course." -- Leigh-ann N.
"I thought this course was very informative. As someone who has never used excel before, it was very thorough with walking me through the steps. I was also happy that the course provided examples as to why someone might want to do things a certain way in excel." -- Hailey D.
"I thought I new some basics of Excel but this class has taught me that Excel is so much more than I thought. It has been extremely helpful and informative. I feel I am able to put what I have now learnt in my day to day work at the office thereby making my use of Excel more efficient and less time consuming. Some information will need more practice but generally it was beneficial to me. Thank you." -- Marion B.
"I think this course was very helpful. I discovered functions I was not aware of. This course will be a great benefit and tool to apply to my office excel spreadsheets that I use on a daily basis." -- Linda J.
"I think the basic break down is fantastic. Excel can be scary to a new user, and this made it less so." -- Helen kate M.
"This course was very helpful. I've used Excel for years and still learned several new functions." -- Michael M.
"Very helpful. Will be taking the next level Excel course. Thank you." -- Lisa S.
"This course was very informative and the video was great for visual learning." -- Ruth T.
"I received the feedback and comments, I appreciate the time and effort to do it." -- Ryan S.
"I can thank you for making all this information and training available to the public. I REALLY AND TRULY appreciate it. I have every intention of taking advantage of it, and spreading the word every chance I get." -- Margaret M.