Interactive Excel Training - C1: Advanced Course
Last Updated 04/2025
English
30-Day Money Back Guarantee
Full Lifetime Access
Finish in
3h! Run Time
3h! Run Time
Made for for
Employees
and
Supervisors
Employees
and
Supervisors
Certificate
of Completion
of Completion
Mobile -
Friendly
Access
Friendly
Access
What you'll learn
Students who have a C1 level will have a deep understanding of pivot tables, filters, validations, and advanced search functions.
In addition, they will be able to create and control custom forms.
Description
Students who have a C1 level will have a deep understanding of pivot tables, filters, validations, and advanced search functions. In addition, they will be able to create and control custom forms.
System Requirements
Please note the following minimum requirements for an optimal course experience:
>Stable internet access with a minimum speed of 100 Mbps.
>A modern browser (such as Chrome or Firefox).
>Windows 10 or higher operating system.
>Allow access to domains.
Table of Contents
Unit 0: Introduction C1
Unit 1: Advanced Pivot Table Design 1
• Report Connection
• Custom Slicer Style
• Multiple Consolidation Ranges (Single Page Field)
• Multiple Consolidation Ranges (Custom Page Fields)
• Calculated Field
• Calculated Item
• List Formulas
• Summary & Glossary 1
• Control 1
Unit 2: Advanced Lookup Functions 1
• CHOOSE
• INDIRECT
• OFFSET
• HSTACK - VSTACK
• TOROW - TOCOL
• WRAPCOLS - WRAPROWS
• CHOOSECOLS - CHOOSEROWS
• Summary & Glossary 2
• Control 2
Unit 3: Advanced Lookup Functions 2
• XLOOKUP
• SORT
• SORTBY
• UNIQUE
• FILTER
• VLOOKUP function to cross-reference data
• Nesting VLOOKUP and INDIRECT functions to search in different tables
• VLOOKUP function for multiple results
• Summary & Glossary 3
• Control 3
Unit 4: Form Controls
• Combo Box
• Check Box
• Spin Button
• List Box
• Option Button
• Charts with Form Controls
• Conditional Formatting with Form Controls
• Summary & Glossary 4
• Control 4
Unit 5: Advanced Filters
• Filter by using one criterion
• Filter by using multiple criteria
• Filter by using wildcard characters
• Obtain unique records
• Summary & Glossary 5
• Control 5
Unit 6: Data Validation
• Prevent Duplicate Data Records
• Avoid transcribing irregular spaces
• Dynamic ranges with the OFFSET function
• Summary & Glossary 6
• Control 6
FINAL EXAM
Interactive Excel Training - C1: Advanced Course
Interactive Excel Training - C1: Advanced
Students who have a C1 level will have a deep understanding of pivot tables, filters, validations, and advanced search functions. In addition, they will be able to create and control custom forms.
Frequently Asked Questions
This course is designed for employees and supervisors who need to complete Interactive Excel Training - C1: Advanced Course training
Yes. This course is designed to meet applicable federal requirements and commonly mandated state standards. Always confirm specific state or industry requirements with your local regulations.
The course takes approximately 180 minutes to complete and can be paused and resumed at any time.
Yes. Learners receive a downloadable certificate upon successful completion, which can be used for compliance records and audits.
Yes. You can assign this course to individuals or groups using Coggno’s LMS, or purchase multiple seats for your team.
Yes. This course can be exported for delivery in most learning management systems (SCORM compatible).
Yes. The course is fully self-paced and available 24/7.
Yes. This course includes a knowledge check to reinforce learning and verify completion.
Learners have lifetime access from the date of purchase.
Yes. A preview is available so you can review the course format and content before purchasing.
Yes. Content is reviewed and updated as regulations and best practices change.
Yes. This course is available for free with an active Prime Subscription.
Yes. Refund requests can be submitted within 30 days of purchase.