Interactive Excel Training - C1: Advanced Course

Description

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

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.

Author

Ninja Excel

7 Courses