Interactive Excel Training - B2: Upper Intermediate Course

Description

Table of Contents

Unit 0: Introduction B2

Unit 1: Conditional Formatting 1
• Preset Rules
• Detect Duplicate Values
• Top and Bottom 10 Rules
• Data Bars and Color Scales
• Icon Sets
• Manage Rules
• Clear Rules
• Rules with Formulas
• Summary & Glossary 1
• Control 1

Unit 2: Data Tools
• Text to Columns
• Remove Duplicates
• Consolidate
• Summary & Glossary 2
• Control 2

Unit 3: Data Validation
• Data Validation
• Input Message
• Error Message
• Whole Number
• Date
• Text Length
• List
• Dependent Drop-Down Lists
• Summary & Glossary 3
• Control 3

Unit 4: Lookup Functions
• TRANSPOSE
• VLOOKUP
• HLOOKUP
• COLUMN - ROW
• COLUMNS - ROWS
• MATCH
• INDEX
• IF - VLOOKUP
• IFERROR - VLOOKUP
• INDEX - MATCH
• Summary & Glossary 4
• Control 4

Unit 5: Formula Auditing
• Trace Precedents
• Trace Dependents
• Show Formulas
• Evaluate Formulas
• Error Checking
• Summary & Glossary 5
• Control 5

Unit 6: Custom Pivot Table Tools
• Slicers in Pivot Tables
• Timeline
• Create Individual Reports
• Refresh and Group Data
• 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