Mastering Business and Financial Reporting: Unleashing the Power of Excel 2007
BackScheduled Date: | Sunday, October 23, 2011/Thursday, October 27, 2011 |
Training Provider: | Meirc Training & Consulting |
Type: | Training course |
City: | Abu Dhabi |
Country: | United Arab Emirates |
Sector: | Finance |
Languages : | English |
Program Objectives:
By the end of the program, participants will be able to:
* Boost Excel reporting expertise in business, finance, and accounting.
* Automate the report preparation and analysis to assist in enhancing the decision making process.
* Demonstrate proficiency in pivot tables and pivot charts.
* Slice and dice large accounting and business data in no time.
* Apply data reporting techniques to real-life business situations.
* Use Macros to perform repetitive tasks and generate reports.
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 make laptops available; 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, ERROR, ISNA, CHOOSE, INDIRECT, INDEX.
Scenario Reporting and 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
Power Excel Business Techniques
* List Box and Option Button Modeling
* Check Box Data Reporting
* Advanced Filter Analysis
* Data Tables
* The Incredible Array Functions
Tables and Worksheet Databases
* Using the New Excel 2007 Table Feature
* Data Forms
* Advanced Sorting and Filtering
* Subtotal Function
* Formulas within a Table
Macro Recording and Editing
* Record and Edit Macros
* Design Buttons and Menus to Activate and Run Macros
Pre-requisites
None
Delivery Type
Group-Live