Interactive Excel Training - C2: Mastery Course

Description

Table of Contents

Unit 0: Introduction C2

Unit 1: Text Functions 2
• Nesting FIND and MID for Dynamic Data Extraction
• Nesting MID and Double-Nesting FIND for Dynamic Data Extraction
• Nesting FIND and LEFT for Dynamic Data Extraction
• TEXTSPLIT function
• Summary & Glossary 1
• Control 1

Unit 2: Advanced Lookup Functions 3
• RANK.EQ
• FREQUENCY
• MAXIFS
• MINIFS
• AVERAGEIF
• AVERAGEIFS
• Summary & Glossary 2
• Control 2

Unit 3: Statistical Functions
• Show Values As: % of Grand Total
• Show Values As: % of Column Total
• Show Values As: % of Row Total
• Show Values As: % Of
• % Difference from
• Running Total in
• Summary & Glossary 3
• Control 3

Unit 4: Macros
• Fundamentals of Excel Macros
• PC Settings to work with Macros
• Record, Run, and Delete a Macro
• Copy a Macro to another workbook
• Create a Form with Macros
• Advanced Filters with Macros
• Summary & Glossary 4
• Control 4

Unit 5: Solver
• Enable the SOLVER Add-in
• Introduction to Solver
• Working with SOLVER
• Working with Maximum
Objectives in SOLVER
• Working with Minimum
Objectives in SOLVER
• Summary & Glossary 5
• Control 5

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