|
Program Objectives: By the end of the program, participants will be able to: - Use Excel in business, finance, accounting, marketing and sales more effectively.
- Perform analysis and evaluation to assist in enhancing the decision making process.
- Master data analysis using pivot tables and pivot charts.
- Slice and dice large accounting data in no time.
- Develop dynamic business reporting models flash reports to senior management.
- Apply data to real-life business situations.
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 CPEs.
Note: This is a hands-on training program using Laptops/Computers.
For Dubai programs, Meirc will provide laptops; outside Dubai, participants are requested to carry their own laptops equipped with Microsoft Excel 2007. Program Fees: Per participant - USD 3700
Frequent nomination - USD 3330
(including coffee breaks and a buffet lunch daily)
One extra free place for every 2 paid nominees on the same program and dates
Discount Plans, Refunds & Cancellations Policy
Meirc reserves the right to alter dates, content, venue and trainer with a reasonable notice time. Program Outline: | Quick Review of Excel Business and Finance Functions - Business Workspace, Conditional and Auto Formatting
- Name Ranges and Business Form
- Scenario Analysis and Formula Auditing
- Goal Seek and Break-Even Analysis
Dynamic Data Consolidating - Performing Consolidation with Different Functions
- Creating Links to Source Data
- The Magic of Advanced Conditional Formatting
- Auditing Data for Error-Free Reporting
Data Validation Techniques - Validating User Input with Message Alert
- Using List to Automate and Authenticate Data Validity
- Data Validation with Date and Custom Designed Restrictions
Mastering Powerful Excel Function for Business Reporting - LEFT, RIGHT, MID, LEN, FIND, VALUE, IF, AND, OR, VLOOKUP, SUMPRODUCT, SUBTOTAL, ERROR, ISNA
Scenario Analysis - Defining and Merging Scenarios
- Multiple Level Scenarios
- Scenario Spinner and What-If-Analysis
| | Mastering Pivot Tables and Pivot Charts - Inserting Pivot Tables
- Performing Analysis Using Data Manipulations
- Inserting Calculated Fields
- Pivot Formatting, Sorting and Filtering
- Preparing Reports Using the Show Pages Function
- Preparing Dynamic Charts
- Dynamic Labeling
- Charts with 3-Axis
- Performing Magic with Getpivotdata
- Ten Chart Design Principles
Model Development - Business and Financial Models - The Rules of Assumptions
- Designing the Working Model
- Developing the Reporting Mechanism and Automating Your Model
Power Excel Business Techniques - List Box and Option Button Modeling
- Check Box Data Reporting
- Advanced Filter Analysis
- Macro Recording and Editing
| Pre-requisites None
Delivery Type Group-Live | Related Programs |
|
Programs 
