Online Class: Advanced Excel 2013
no certificate
with CEU Certificate*
-
19Lessons
-
39Exams &
Assignments -
1,727Students
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
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.
- 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+ |
Related Courses
- 26 hours 2.60 CEUs Ultimate Excel Training Bundle + More Info
- 8 hours 0.8 CEUs Microsoft PowerPoint Level 1 + More Info
- 9 hours 0.9 CEUs Microsoft Project Level 1 + More Info
- 8 hours 0.8 CEUs Microsoft Access Level 1 + More Info
- 6 hours 0.6 CEUs Microsoft Publisher Level 1 + More Info
- 7 hours 0.7 CEUs Microsoft Excel Level 3 + More Info
- 7 hours 0.7 CEUs Google Sheets + More Info
- 7 hours 0.7 CEUs Google Slides + More Info
- 6 hours 0.6 CEUs Google Docs + More Info
- 7 hours 0.7 CEUs Microsoft Word Level 1 + More Info
- 8 hours 0.8 CEUs MySQL + More Info
- 7 hours 0.7 CEUs Microsoft Visio Level 1 + More Info
- 4 hours 0.4 CEUs Slack + More Info