|
Provided by: Meirc Training and Consulting Mastering Business and Financial Modeling - Abu Dhabi DubaiBudget Management |
 |
Certificate Program
Provided by Meirc Training and Consulting
By the end of the program, participants will be able to:
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.
Related Jobs or Careers: Business analysts and professionals, supervisors and staff from any function including finance personnels.
|
|
||||||||||||||||||||
Mastering Business and Financial Modeling - Abu Dhabi Dubai
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 and Trace Dependents
Evaluate Business Formulas
Business and Financial Data Validation
Setting-Up Your Validation Rules
Using Lists to Restrict Data Input to Your Business Model
Data Consolidation
Using Appropriate Function and 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 and Using Consolidation Ranges
Must Tools for Every Business and Finance Professional
IF STATEMENT, MID, LEFT, RIGHT, VALUE, DATE, and TRIM, and CONCATENATE
VLOOKUP and IS, and, OR
Macros The Ultimate Efficiency Tool
Planning Macros and Recording Macros
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 and Trace Dependents
Evaluate Business Formulas
Business and Financial Data Validation
Setting-Up Your Validation Rules
Using Lists to Restrict Data Input to Your Business Model
Data Consolidation
Using Appropriate Function and 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 and Using Consolidation Ranges
Must Tools for Every Business and Finance Professional
IF STATEMENT, MID, LEFT, RIGHT, VALUE, DATE, and TRIM, and CONCATENATE
VLOOKUP and IS, and, OR
Macros The Ultimate Efficiency Tool
Planning Macros and Recording Macros
About The Training Provider: Meirc Training and Consulting
Meirc Training and Consulting - Meirc Training and Consulting offers a comprehensive range of training courses in Dubai and executive training in Dubai and outside the UAE in regions which include the Middle East, North Africa and Europe. Meirc has expertise in wide areas as follows:
Leadership and Management,
Interpersonal Skills,
Communication Skills,
Business Writing,
Human Resources Management,
Training and...
