Mastering Business and Financial Modeling using Excel
This program is designed for
Business analysts and professionals, supervisors and staff from any function including finance who need to improve their understanding and use of Microsoft Excel as an important tool to produce more effective and efficient work. This program is worth 25 NASBA CPE?s.
Note: This is a hands-on training program using Laptops/Computers.
Use Microsoft Excel in business finance more effectively.
Perform analysis and evaluation to assist in enhancing the decision making process.
Understand and create pivot tables and pivot charts.
Analyze business data in no time.
Prepare business and flash reports to senior management.
|
|
||||||
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
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
