Online Class: Advanced Excel 2016

no certificate
with CEU Certificate*
-
22Lessons
-
33Exams &
Assignments -
3,104Students
have taken this course -
17Hours
average time -
1.7CEUs
Course Description
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 2016.
Excel is a complex, yet easy-to-use spreadsheet program that contains a multitude of much-needed tools with very advanced options. While it's true that you can create an attractive spreadsheet and use simple formulas in Excel with very little experience, that is just the tip of the iceberg when it comes to what Excel can truly do. In order to be able to successfully use the program to create spreadsheets, enter data, and maintain that data, you must have more than basic knowledge. This course gives you the advanced skills you need to be able to fully use the program.
This course is for the intermediate student who has already mastered the basic skills needed to use Excel 2016 and wants to gain more advanced skills to put to work in a business environment or for personal use. This course goes in-depth, using step-by-step instructions to teach advanced techniques to broaden all students' knowledge and use of the program.
In this course, you will learn how to:
· Create outlines in Excel
· Create your own templates
· Work with sparklines
· Create and manage scenarios
· Use Goal Seek and Solver
· Create, manage, and format pivot tables and pivot charts
· Use the Excel mathematical functions
· Create and write complex formulas
· Perform data lookups
· Create and use IF statements
· Use Excel's data functions
· Create and use data validation rules
· Apply custom and prebuilt conditional formatting
· Work with functions to manipulate strings of text and data
· Create and use macros
· Troubleshoot and audit formulas
· Create pivot tables and pivot charts
· Use queries to import external data
· Import and clean data
· Link and consolidate worksheets and workbooks
· Troubleshoot errors
· And more
This advanced Excel course is designed for the intermediate Excel user who desires to learn more advanced skills. The topics covered in this course will give each student the knowledge and practice to be able to use Excel in a business setting or for advanced personal use.
This course makes the assumption that all students have at least a basic working knowledge of Excel and have mastered the basic skills required to:
-
Navigate Excel 2016
-
Create, name, save, and work with worksheets and workbooks
-
Work with, edit, and format cells, rows, and columns
-
Create and format tables
-
Enter data into Excel
-
Create basic formulas and calculations
-
Understand the role of functions in Excel, as well as mathematical operators
-
Understand absolute vs. relative cell references
-
Have basic knowledge of the What-If Analysis
-
Create, sort, and filter lists
If you are not a regular Excel user, it is important that you take the time to brush up on your basic Excel skills before continuing with this course. Although our Excel 2016 basic course is not a mandatory prerequisite, it is recommended that you complete that course prior to starting advanced Excel 2016 training if you do not have a working knowledge of the topics listed above.
- 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

Course Lessons
Introduction
Lesson 1 Video
Review Practice Worksheet: CHAR_functions.xlsx
Lesson discussions: Reasons for Taking this Course
Complete: Lesson 1 Assignment - Introduction
Lesson 2: Outlines, Custom Views, and Templates
Lesson 2 Video
Complete: Lesson 2 Assignment
Assessment: Exam 2
Lesson 3: Mathematical Functions
Lesson 3 Video
Complete: Lesson 3 Assignment
Assessment: Exam 3
Lesson 4: Data Functions
Lesson 4 Video
Complete: Lesson 4 Assignment
Assessment: Exam 4
Lesson 5: Data Lookups
Lesson 5 Video
Assessment: Exam 5
Lesson 6: The IF Function
Lesson 6 Video
Assessment: Exam 6
Lesson 7: Manipulating Text
Lesson 7 Video
Complete: Lesson 7 Assignment
Assessment: Exam 7
Lesson 8: Exploring Conditional Formatting
Lesson 8 Video
Assessment: Exam 8
Lesson 9: Working with Sparklines
Lesson 9 Video
Complete: Lesson 9 Assignment
Assessment: Exam 9
Lesson 10: Linking To and Consolidating Worksheets
Lesson 10 Video
Assessment: Exam 10
Lesson 11: Importing and Cleaning Data
Lesson 11 Video
Complete: Lesson 11 Assignment
Assessment: Exam 11
Lesson 12: Pivot Tables
Lesson 12 Video
Assessment: Exam 12
Lesson 13: Continuing to Work with PivotTables
Lesson 13 Video
Assessment: Exam 13
Lesson 14: PivotCharts
Lesson 14 Video
Assessment: Exam 14
Lesson 15: The What-if Analyses
Lesson 15 Video
Complete: Lesson 15 Assignment
Assessment: Exam 15
Lesson 16: Goal Seek and Solver
Lesson 16 Video
Assessment: Exam 16
Lesson 17: The Analysis ToolPak
Lesson 17 Video
Assessment: Exam 17
Lesson 18: All About Data Validation
Lesson 18 Video
Complete: Lesson 18 Assignment
Assessment: Exam 18
Lesson 19: Using Get & Transform to Perform Queries
Lesson 19 Video
Complete: Lesson 19 Assignment
Assessment: Exam 19
Lesson 20: Troubleshooting and Auditing in Excel 2016
Lesson 20 Video
Assessment: Exam 20
Lesson 21: Exploring Macros in Excel 2016
Lesson 21 Video
Assessment: Exam 21
Lesson 22: Continuing to Work with Macros
Lesson 22 Video
Lesson discussions: End of Course Poll; Course Comments; Program Evaluation Follow-up Survey (End of Course)
Complete: Lesson 22 Assignment
Assessment: Exam 22
Assessment: The Final Exam
Learning Outcomes
- Define outlines, custom views, and templates in Excel 2016.
- Describe mathematical functions.
- Describe data functions.
- Describe data lookups.
- Demonstrate usage of the if function.
- Describe manipulating text.
- Demonstrate conditional formatting.
- Describe working with sparklines.
- Describe linking to and consolidating worksheets.
- Summarize importing and cleaning data.
- Demonstrate creating Pivot Tables.
- Demonstrate creating and using PivotCharts.
- Demonstrate using the What-if Analyses
- Demonstrate using the Goal Seek and Solver
- Describe working with macros.
- 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

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 24 Months |
No. of courses | 600+ |
Student Testimonials
- "I really enjoyed this Course as I've always been interested in learning more about Excel, and this fueled my interest and desire to learn more. The main feature of your Courses is the dual option content of reading about the topic chapter, and then watching the video ( to see the demonstration of what was discussed) about the text. This is key, and based on my preferred visual learning style, it's far more effective than reading a chapter in an Excel text book." -- Richard B.
Related Courses
-
45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
-
30 hours 3.0 CEUs Microsoft Office 2021: Word, Excel, PowerPoint and Outlook $110.00
-
6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
-
7 hours 0.7 CEUs Understanding Financial Statements $95.00
-
6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
-
9 hours 0.9 CEUs Microsoft Project 2021 $95.00
-
5 hours 0.5 CEUs SalesForce 101 $95.00
-
7 hours 0.7 CEUs Google Sheets $95.00
-
6 hours 0.6 CEUs Cybersecurity 101 $95.00
-
7 hours 0.7 CEUs Financial Analysis 101: Planning and Control $95.00
-
8 hours 0.8 CEUs MySQL $95.00
-
8 hours 0.8 CEUs Microsoft Access 2019 $95.00
-
8 hours 0.8 CEUs Adobe InDesign 101 $95.00
-
4 hours 0.4 CEUs Slack $95.00
-
32 hours 3.2 CEUs Accounting & Bookkeeping 101 for Everyone $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
-
16 hours 1.6 CEUs Advanced Excel 2019 $95.00
-
5 hours 0.5 CEUs Outlook 2021 $95.00
-
7 hours 0.7 CEUs Google Slides $95.00
-
6 hours 0.6 CEUs Google Docs $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
-
7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00