Mastering Business & Financial Modeling using Excel

Quick Review of Excel Business and Finance Functions

Business Workspace
Conditional and Auto Formatting
Name Ranges
Scenario Analysis, and Formula Auditing
Goal Seek and Break-Even Analysis
Data Validation and Consolidation
Business Form
Pivot Tables and Pivot Charts
Macros
Scenario Analysis

Defining a Scenario
Merging Scenarios
Multiple Level Scenarios
Scenario Spinner and What-If-Analysis
Auditing Your Work in No Time

Trace Precedents
Trace Dependents
Evaluate Business Formulas
Business and Financial Data Validation

Setting-Up Your Validation Rules
Selecting Different Input Variables
Using Lists to Restrict Data Input to Your Business Model
Data Consolidation

Using Appropriate Function
Selecting Different References
Creating Source to Consolidated Data
Pivot Table and Pivot Charts A Must Learn Tool

Using Your Own Data
Using Your Imported Data
Using Consolidation Ranges
Enhancing Your Report With Data and Format Options
A Must Tools for Every Business and Finance Professional

IF STATEMENT
MID, LEFT, RIGHT
VALUE, DATE, and TRIM
CONCATENATE
VLOOKUP
IS, and, OR
Macros The Ultimate Efficiency Tool

Planning Macros
Recording Macros
Editing Macros