What you'll learn :
- Consolidating Data
- Creating File Linking
- Creating a Hyperlink
- Using Precedent & Dependent Cells
- Using Circular Reference
- Adding Comment in A Cell
- Creating a Data Validation
- Analyzing Data with Pivot Table
- The Difference between Goal Seek and Solver
- Using Goal Seek Function Features
- Creating Report Solver
- Using Scenario Manager
- Creating Subtotal and Nested Automatisation
- Understanding Outline, Symbols, and Buttons
- Intro Macro Recording