This video outlines how to use our smart Excel tools that facilitate building or working on complex Excel models.

Video contents

1. Smart Track- 0:11
2. Explore the structure of your opened documents - 1:21
3. Autocolor your models - 1:47
4. Add CAGR functions - 2:36
5. Apply IfError to large areas - 3:05
6. Fast Fill down and right - 3:40
7. Advanced Paste - 4:11
8. Excel Table of Contents - 4:53
9. Clean and Prepare your workbook - 5:35

More info about Modeling tools

• Constructing financial models
• Auditing and presenting financial models
• Cleaning and preparing workbooks