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,703
    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. 
  • 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.33 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(11,791 votes)

Lesson 1: MS Excel 2016: Comprehensive Introduction

11 Points
Excel 2016, available through purchase or Office 365 subscription, offers new features like Smart Lookup and real-time collaboration, which enhance productivity and data efficiency. Although Excel for Mac lacks some tools found in the Windows version, both share a similar interface, easing the transition between systems. Additional lesson topics: Three Cool Things to Try in Excel
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete: Lesson 1 Assignment
  • Assessment: Exam 1

Lesson 2: Navigating Like a Pro: Excel 2016

11 Points
The Backstage area under Excel's File tab centralizes file management tasks, while the Quick Access Toolbar provides customizable shortcuts for frequently used commands. Efficient worksheet navigation can be achieved through cursor keys and Name box input. Additional lesson topics: Excel from Scratch; Excel Tutorial: Using the Quick Access Toolbar in Excel
  • Lesson 2 Video
  • Complete: Lesson 2 Assignment
  • Assessment: Exam 2

Lesson 3: Exploring Excel: A Guide to Worksheets and Workbooks

11 Points
Opening an Excel file means accessing a workbook, which can contain multiple worksheets navigable through tabs. Learning to save your work diligently ensures data isn't lost, and using Save As allows for customizable file naming and format options. Additional lesson topics: Use a shared workbook to collaborate in Excel for Windows; Move or copy worksheets or worksheet data
  • Lesson 3 Video
  • Complete: Lesson 3 Assignment
  • Assessment: Exam 3

Lesson 4: Essential Tips for Efficient Data Entry in Excel 2016

11 Points
Excel data entry can be streamlined by pre-planning the layout and understanding its reliance on rows and columns for organization. The type of data—whether text, value, or formula—dictates its calculation and alignment behavior. Additional lesson topics: Entering and Editing Data in Excel ; Create a drop-down list in Excel for Mac; Change axis labels in a chart in Office
  • Lesson 4 Video
  • Complete: Lesson 4 Assignment
  • Assessment: Exam 4

Lesson 5: Introduction to Excel Cell Operations

10 Points
The Clipboard stores up to 24 items, helping manage data transfers across worksheets, and Paste Special offers methods to paste data with particular features like values-only or retaining styles. Whether adjusting data layout or replicating styles, these tools enhance Excel productivity. Additional lesson topics: How to Freeze Rows and Columns in Excel ; Select cells, ranges, rows, or columns on a worksheet; Insert or delete cells, rows, and columns
  • Lesson 5 Video
  • Complete: Lesson 5 Assignment
  • Assessment: Exam 5

Lesson 6: Effortless Data Decoration

11 Points
Empower your data perplexities with Quick Analysis, elucidating your worksheet’s potential with succinct tool reaches, embracing charts, sums, and pivotal formatting maneuvers. Functioning akin to a masterstroke, the Format Painter can seamlessly replicate aesthetic aspects from one dataset onto another, aiding in consistency across your worksheet structure. Additional lesson topics: Format numbers as currency in Excel ; Guidelines for organizing and formatting data on a worksheet
  • Lesson 6 Video
  • Complete: Lesson 6 Assignment
  • Assessment: Exam 6

Lesson 7: Effortless Column and Row Resizing in Excel 2016

11 Points
Excel 2016 allows you to manipulate column widths by setting specific dimensions or using AutoFit to accommodate content effortlessly. Similar flexibility is available for rows, where heights can be adjusted manually or tailored to fit the tallest cell, ensuring clarity in data presentation.
  • Lesson 7 Video
  • Complete: Lesson 7 Assignment
  • Assessment: Exam 7

Lesson 8: Insightful Strategies for Accurate Data Entry in Excel 2016

11 Points
Spell Check and AutoCorrect are powerful tools in Excel 2016 that assist in error correction, while Track Changes allows users to document and manage edits collaboratively within a worksheet. Additional lesson topics: How to use Find and Replace in Excel most efficiently; Playing With Find and Replace Options Microsoft Excel Beginner Lecture; Find or replace text and numbers on a worksheet in Excel for Windows
  • Lesson 8 Video
  • Complete: Lesson 8 Assignment
  • Assessment: Exam 8

Lesson 9: Excel Arithmetic 101

11 Points
Excel's core strength lies in its ability to seamlessly perform calculations and use formulas, making tasks like accounting or tracking totals a breeze. The software automatically recalculates when changes occur, saving users from potential errors and enhancing productivity. Additional lesson topics: Guidelines and examples of array formulas in Excel for Windows
  • Lesson 9 Video
  • Complete: Lesson 9 Assignment
  • Assessment: Exam 9

Lesson 10: Excel Essentials: Functions and Formulas

10 Points
Cell references in Excel can be relative, absolute, or mixed, affecting how formulas are copied and pasted across worksheets. Understanding reference types allows for accurate formula replication without unintended changes in cell references, ensuring correct calculations. Additional lesson topics: Overview of formulas in Excel for Windows; Working With Simple Formula Microsoft Excel Beginner Lecture
  • Lesson 10 Video
  • Complete: Lesson 10 Assignment
  • Assessment: Exam 10

Lesson 11: Efficiently Managing Excel Worksheets: Key Techniques and Tools

11 Points
The Zoom functionality and worksheet views in Excel are essential for maintaining control over large datasets by enabling adjustable magnification. Handling numerous worksheets is streamlined through Excel's capabilities to activate specific sheets, arrange multiple windows, and move data across workbooks. 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
  • Lesson 11 Video
  • Complete: Lesson 11 Assignment
  • Assessment: Exam 11

Lesson 12: Probing the Future with Excel's What-If Tools

11 Points
Excel stands out as more than a mere data calculator by providing what-if analysis tools for exploring various scenarios and outcomes. Through data tables, goal seek, and scenario manager features, this lesson offers ways to reimagine and predict diverse financial results. Additional lesson topics: Switch between various sets of values by using scenarios
  • Lesson 12 Video
  • Complete: Lesson 12 Assignment
  • Assessment: Exam 12

Lesson 13: Visual Storytelling with Excel: Adding and Editing Images

11 Points
Beyond just number crunching, Excel allows you to incorporate various graphics and images from different sources like OneDrive, Facebook, and Flickr. Enhance these visuals by applying artistic effects, adjusting colors, and managing file sizes through compression. Additional lesson topics: Add alternative text to a picture, shape, chart, table, or SmartArt graphic; How to Add Preset Graphic Shapes in Excel
  • Lesson 13 Video
  • Complete: Lesson 13 Assignment
  • Assessment: Exam 13

Lesson 14: Chart Creation Made Simple

11 Points
Excel 2016 introduces advanced charting tools, enabling users to visually express data relationships and trends with ease through Recommended Charts, SmartArt, and a diverse range of chart types. Customization options allow for detailed chart modifications, including unique styles, animations, and the ability to integrate sparklines. Additional lesson topics: Create a waterfall chart in Office ; New Charts in Excel ; Create a chart in Excel for Mac
  • Lesson 14 Video
  • Complete: Lesson 14 Assignment
  • Assessment: Exam 14

Lesson 15: From Calculation to Organization: Mastering Data Lists

10 Points
Experience the benefits of Excel's data lists by learning to input field names, format tables, and incorporate additional records, focusing on informational rather than computational utility. Discover easy methods for sorting and filtering your data, enhancing your ability to manage large volumes of information seamlessly. Additional lesson topics: Create a drop-down list in Excel for Windows; Sort a list of data in Excel for Mac
  • Lesson 15 Video
  • Complete: Lesson 15 Assignment
  • Assessment: Exam 15

Lesson 16: Streamlined Data Management Techniques

11 Points
Excel's formula auditing tools help manage complex worksheets by revealing and tracing formula dependencies, as well as identifying errors. The watch window and evaluate formula options aid in monitoring formula impacts and understanding calculation sequences. Additional lesson topics: Using a form for data entry; Add, edit, find, and delete rows by using a data form
  • Lesson 16 Video
  • Complete: Lesson 16 Assignment
  • Assessment: Exam 16

Lesson 17: Mastering the Art of Pivot Tables: A Comprehensive Guide

10 Points
Pivot tables provide a robust tool for distilling complex datasets into understandable summaries by drag-and-drop field organization within designated sections like Filters and Values, effectively transforming raw data into structured insights. With additional features such as slicers and editable field settings, these tables are highly interactive, enabling seamless changes to data representation methods, thus tailoring the visualization to the user's analytical needs. Additional lesson topics: How to Create a Dashboard Using Pivot Tables and Charts in Excel; Create a PivotChart in Excel for Windows; Create a PivotTable in Excel for Mac; Introduction to Pivot Tables, Charts, and Dashboards in Excel Part 1 has good data to download for Pivot Table practice
  • Lesson 17 Video
  • Complete: Lesson 17 Assignment
  • Assessment: Exam 17

Lesson 18: Printing in Excel: A Comprehensive Guide

11 Points
Optimize the margins of your spreadsheet for printing by selecting from predefined margin options or customizing your own through the Print settings. Adjust header and footer margins in the same setup dialogue, ensuring everything aligns perfectly. 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
  • Lesson 18 Video
  • Complete: Lesson 18 Assignment
  • Assessment: Exam 18

Lesson 19: Excel Templates: A Comprehensive Guide

11 Points
By using templates, you save considerable time and ensure consistency in your worksheets, with the freedom to edit them or design new ones for repeated use in Excel 2016. Access various pre-designed templates or search for specific ones, making your work easier and more efficient. Additional lesson topics: Create and use your own template; Learn how to use the My Cashflow template with Excel
  • Lesson 19 Video
  • Complete: Lesson 19 Assignment
  • Assessment: Exam 19

Lesson 20: Defending Your Data: A Guide to Workbook Protection

110 Points
Safeguarding your Excel workbooks involves locking contents with passwords and selecting appropriate storage and sharing methods. Features like cloud saving and Power BI enable collaborative workflows, enhancing productivity and connectivity in professional settings.
  • Lesson 20 Video
  • Lesson discussions: Let us know what you think of this course; Course Comments; Program Evaluation Follow-up Survey (End of Course); Course Comments
  • 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

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
Lessons Rating: 4.33 / 5 Stars (11,791 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: This course is fully available online in all 50 states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. It’s also offered in major English-speaking countries, such as the United Kingdom, Canada, Australia, and Ireland.
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
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
 
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
$120
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
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
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.
View More Testimonials...