Course Syllabus
Sorry, this course is no longer open for enrollment.
Course Description
This advanced Excel course goes beyond the basics of Excel and explores the advanced features that make this the most popular spreadsheet program available today. Picking up where our Excel 2013 online course leaves off, this course delves into Excel's world of functions and formulas, teaching you how to use Excel to enter, manage, calculate and display any type of data.
You will learn how to:
· Use outlining in Excel
· Create 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
· 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
· And more
- 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

Assessment Guide
Assessment | Points |
---|---|
Assignment 1 | 1 points |
Exam 1 | 9 points |
Assignment 2 | 1 points |
Exam 2 | 10 points |
Assignment 3 | 1 points |
Exam 3 | 10 points |
Assignment 4 | 1 points |
Exam 4 | 9 points |
Assignment 5 | 1 points |
Exam 5 | 10 points |
Assignment 6 | 1 points |
Exam 6 | 10 points |
Assignment 7 | 1 points |
Exam 7 | 10 points |
Assignment 8 | 1 points |
Exam 8 | 10 points |
Assignment 9 | 1 points |
Exam 9 | 10 points |
Assignment 10 | 1 points |
Exam 10 | 10 points |
Assignment 11 | 1 points |
Exam 11 | 10 points |
Assignment 12 | 1 points |
Exam 12 | 10 points |
Assignment 13 | 1 points |
Exam 13 | 10 points |
Assignment 14 | 1 points |
Exam 14 | 10 points |
Assignment 15 | 1 points |
Exam 15 | 10 points |
Assignment 16 | 1 points |
Exam 16 | 9 points |
Assignment 17 | 1 points |
Exam 17 | 10 points |
Assignment 18 | 1 points |
Exam 18 | 10 points |
Assignment 19 | 1 points |
Exam 19 | 10 points |
Final Exam | 93 points |