Online Class: Advanced Excel 2019
no certificate
with CEU Certificate*
-
20Lessons
-
36Exams &
Assignments -
3,937Students
have taken this course -
16Hours
average time -
1.6CEUs
Course Description
Excel is one of the most powerful tools in Microsoft Office. You can import, query, analyze and manipulate data to create powerful reports that can be used by individuals and enterprise businesses alike. This course explores some of the more advanced features of Microsoft Excel to give you a more powerful experience when you need the most out of spreadsheet software.
- Outlines, Custom Views, and Templates
- Mathematical Functions
- Data Functions and Data Lookups
- The IF Function
- Manipulating Text
- Conditional Formatting
- Sparklines
- Importing, Cleaning and Validating Data
- Pivot Tables and Pivot Charts
- The What-If Analysis
- Goal Seek and Solver
- The Analysis ToolPak
- Using Get & Transform to Perform Queries
- Macros
- And Much More!
Pivot tables are one of the most beneficial tools in Excel, and this course covers pivot tables both basic and advanced features. It then moves on to pivot charts, which are graphs that can be used with pivot table data.
Analysis tools in Excel 2019 are some of the most advanced and useful to users that want to run complex reports. Excel has three What-If analysis tools that can be run on your data and provide reports on goals that give answers to your problems. The Solver and Analysis Toolpak are two add-ins that expand on these tools, and they are also covered in this course.
The final lessons cover data validation, troubleshooting, querying data and macros. These lessons provide ways to work with data and clean up unstructured information. This course fully covers advanced features in Excel so that you can create complex spreadsheets for business or individual use.
- 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, Custom Views, and Templates
- Lesson 1 Video
- Lesson discussions: Reasons for Taking this Course
- Complete Assignment: My Excel Experience
- Assessment: Lesson 1 Exam
Lesson 2: Mathematical Functions
- Lesson 2 Video
- Complete: Lesson 2 Activity Assignment
- Assessment: Lesson 2 Exam
Lesson 3: Data Functions
- Lesson 3 Video
- Complete: Lesson 3 Activity Assignment
- Assessment: Lesson 3 Exam
Lesson 4: Data Lookups
- Lesson 4 Video
- Complete: Lesson 4 Activity Assignment
- Assessment: Lesson 4 Exam
Lesson 5: The IF Function
- Lesson 5 Video
- Complete: Lesson 5 Activity Assignment
- Assessment: Lesson 5 Exam
Lesson 6: Manipulating Text
- Lesson 6 Video
- Complete: Lesson 6 Activity Assignment
- Assessment: Lesson 6 Exam
Lesson 7: Exploring Conditional Formatting
- Lesson 7 Video
- Complete: Lesson 7 Activity Assignment
- Assessment: Lesson 7 Exam
Lesson 8: Working with Sparklines
- Lesson 8 Video
- Complete: Lesson 8 Activity Assignment
- Assessment: Lesson 8 Exam
Lesson 9: Linking To and Consolidating Worksheets
- Lesson 9 Video
- Complete: Lesson 9 Activity Assignment
- Assessment: Lesson 9 Exam
Lesson 10: Importing and Cleaning Data
- Lesson 10 Video
- Complete: Lesson 10 Activity Assignment
- Assessment: Lesson 10 Exam
Lesson 11: Pivot Tables
- Lesson 11 Video
- Complete: Lesson 11 Activity Assignment
- Assessment: Lesson 11 Exam
Lesson 12: Continuing to Work with Pivot Tables
- Lesson 12 Video
- Assessment: Lesson 12 Exam
Lesson 13: Pivot Charts
- Lesson 13 Video
- Complete: Lesson 13 Activity Assignment
- Assessment: Lesson 13 Exam
Lesson 14: The What-if Analyses
- Lesson 14 Video
- Assessment: Lesson 14 Exam
Lesson 15: Goal Seek and Solver
- Lesson 15 Video
- Complete: Lesson 15 Activity Assignment
- Assessment: Lesson 15 Exam
Lesson 16: The Analysis ToolPak
- Lesson 16 Video
- Assessment: Lesson 16 Exam
Lesson 17: All About Data Validation
- Lesson 17 Video
- Complete: Lesson 17 Activity Assignment
- Assessment: Lesson 17 Exam
Lesson 18: Using Get & Transform to Perform Queries
- Lesson 18 Video
- Assessment: Lesson 18 Exam
Lesson 19: Troubleshooting and Auditing in Excel 2019
- Lesson 19 Video
- Assessment: Lesson 19 Exam
Lesson 20: Exploring Macros in Excel 2019
- Lesson 20 Video
- Lesson discussions: End of Course Poll; Course Comments; Program Evaluation Follow-up Survey (End of Course)
- Complete: Lesson 20 Activity Assignment
- Assessment: Lesson 20 Exam
- Assessment: The Final Exam
Learning Outcomes
- Demonstrate working with outlines, custom views, and templates in Excel 2019.
- Demonstrate using mathematical functions.
- Demonstrate using data functions, data lookups, and the IF function.
- Demonstrate using conditional formatting.
- Demonstrate working Sparklines.
- Demonstrate linking to and consolidating worksheets.
- Describe importing and cleaning data.
- Demonstrate creating and using Pivot Tables and Pivot Charts.
- Demonstrate creating and using the What-if Analyses.
- Demonstrate creating and using the Goal Seek and Solver.
- Demonstrate creating and using the the Analysis ToolPak.
- Demonstrate creating and using the using get & transform to perform queries.
- 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 found this course to be very thorough in explanation. The detail and explanation was very easy to follow and look back at." -- Patricia A.
- "Some parts were easier than others but I was able to learn many new things in Excel that I was not aware of previously. I look forward to using these in my job." -- Patti M.
- "This course was well put together and helped me grasp all concepts offered." -- David G.
- "Thank you for going the extra mile. Loved the course!" -- Sean B.
- "I think the course is very helpful. I learned a lot of things I did not know." -- Myrtal W.
- "Very helpful! Thank you." -- Kathleen P.
- "Excellent Course." -- Evelyn E.
- "This course if very helpful for an analyst." -- Brittany H.
- "Great! I learned a lot." -- Deborah H.
Related Courses
- 45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
- 6 hours 0.6 CEUs Cybersecurity 101 $95.00
- 6 hours 0.6 CEUs Microsoft Visio 2021 $95.00
- 5 hours 0.5 CEUs Outlook 2021 $95.00
- 8 hours 0.8 CEUs Adobe InDesign 101 $95.00
- 14 hours 1.4 CEUs QuickBooks Online $95.00
- 16 hours 1.6 CEUs Advanced Excel 2019 $95.00
- 7 hours 0.7 CEUs Google Slides $95.00
- 8 hours 0.8 CEUs Quicken Tutorial: All Versions $95.00
- 7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00
- 32 hours 3.2 CEUs Accounting & Bookkeeping 101 for Everyone $95.00
- 8 hours 0.8 CEUs Microsoft Access 2019 $95.00
- 5 hours 0.5 CEUs SalesForce 101 $95.00
- 7 hours 0.7 CEUs Google Sheets $95.00
- 4 hours 0.4 CEUs Slack $95.00
- 6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
- 6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
- 7 hours 0.7 CEUs Understanding Financial Statements $95.00
- 6 hours 0.6 CEUs Microsoft Publisher 2021 $95.00
- 6 hours 0.6 CEUs Google Docs $95.00
- 8 hours 0.8 CEUs MySQL $95.00
- 7 hours 0.7 CEUs Microsoft Word 2021 $95.00
- 7 hours 0.7 CEUs Financial Analysis 101: Planning and Control $95.00
- 7 hours 0.7 CEUs PowerPoint 2021 $95.00