Online Class: Advanced Excel 2013

no certificate
with CEU Certificate*
-
19Lessons
-
39Exams &
Assignments -
1,689Students
have taken this course -
14Hours
average time -
1.4CEUs
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

Course Lessons
Lesson 1: Outlines and Templates
Lesson 1 Video
Review Article: Excel Templates 2013
Take Survey: Reasons for Taking this Course
Complete: Assignment 1
Complete: Exam 1
Lesson 2: Working with Sparklines
Lesson 2 Video
Complete: Assignment 2
Complete: Exam 2
Lesson 3: Scenarios
Lesson 3 Video
Review Article: How to Use the Scenario Manager in Excel 2013
Complete: Assignment 3
Complete: Exam 3
Lesson 4: Goal Seek and Solver
Lesson 4 Video
Review Article: Define and solve a problem by using Solver
Review Video: How to use the Goal Seek function in Excel
Complete: Assignment 4
Complete: Exam 4
Lesson 5: Pivot Tables
Lesson 5 Video
Complete: Assignment 5
Complete: Exam 5
Lesson 6: Continuing to Work with PivotTables
Lesson 6 Video
Review Article: Create a PivotChart
Complete: Assignment 6
Complete: Exam 6
Lesson 7: PivotCharts
Lesson 7 Video
Complete: Assignment 7
Complete: Exam 7
Lesson 8: Mathematical Functions
Lesson 8 Video
Complete: Assignment 8
Complete: Exam 8
Lesson 9: Continuing with Mathematical Functions
Lesson 9 Video
Review Article: LOOKUP function
Review Video: How to use the LOOKUP Function in Excel
Complete: Assignment 9
Complete: Exam 9
Lesson 10: Data Lookups
Lesson 10 Video
Review 2 Articles: Vlookup examples in Excel 2013; How to create relational databases in Excel 2013
Complete: Assignment 10
Complete: Exam 10
Lesson 11: The IF Function
Lesson 11 Video
Review 2 Articles: IF function; Excel IF Statement: How to Use Excel IF Function
Complete: Assignment 11
Complete: Exam 11
Lesson 12: Data Functions
Lesson 12 Video
Review Article: Excel Tutorial: An In-Depth Guide to Working with your Data, Building Formulas, and Using Functions
Complete: Assignment 12
Complete: Exam 12
Lesson 13: Continuing with Data Functions
Lesson 13 Video
Review 2 Articles: 10 new Excel 2013 functions that can save you time; OFFSET function
Complete: Assignment 13
Complete: Exam 13
Lesson 14: All About Data Validation
Lesson 14 Video
Review Article: Apply data validation to cells
Complete: Assignment 14
Complete: Exam 14
Lesson 15: Manipulating Text
Lesson 15 Video
Review Practice Worksheet: CHAR_functions.xlsx
Complete: Assignment 15
Complete: Exam 15
Lesson 16: Exploring Conditional Formatting
Lesson 16 Video
Review Article: Excel formulas for conditional formatting based on another cell value
Review Video: Highline Excel 2013 Class Video 40: Conditional Formatting Basic To Advanced 50 Examples
Complete: Assignment 16
Complete: Exam 16
Lesson 17: Exploring Macros in Excel 2013
Lesson 17 Video
Review 2 Articles: Create or delete a macro; Enable or disable macros in Office files
Complete: Assignment 17
Complete: Exam 17
Lesson 18: More Fun with Macros
Lesson 18 Video
Review Video: Highline Excel 2013 Class Video 51: Recorded Macro Basics, including Absolute and Relative References
Complete: Assignment 18
Complete: Exam 18
Lesson 19: Troubleshooting and Auditing in Excel 2013
Lesson 19 Video
Take Poll: How would you rate this course?
Take Survey: Course Comments
Take Survey: Program Evaluation Follow-up Survey (End of Course)
Complete: Assignment 19
Complete: Exam 19
Complete: Final Exam
Learning Outcomes
- Identify outlines and templates.
- Demonstrate working with sparklines.
- Create scenarios.
- Use goal seek and solver.
- Demonstrate pivot table usage.
- Demonstrate PivotCharts usage.
- Demonstrate usage of mathematical functions.
- Demonstrate data lookups.
- Demonstrate the IF function usage.
- Demonstrate data functions usage
- Demonstrate data validation.
- Demonstrate manipulating text.
- Demonstrate conditional formatting usage
- Demonstrate creating and using Macros
- More Fun with Macros
- Demonstrate troubleshooting and auditing techniques for Excel 2013, and
- 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 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 500+ |
Certificates & CEUs
Includes all 500+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | Monthly |
No. of courses | 500+ |