Program Objectives:
By the end of the program, participants will be able to:
- Boost Excel reporting expertise in business, finance, and accounting.
- Perform automated reconciliation for speedy weekly and monthly reporting.
- Design and create calculated columns using the new 2010 Data Analysis Expressions tool.
- Control multiple Pivot Table elements on one worksheet using the new 2010 slicer tool.
- Apply data reporting techniques to real-life business situations.
- Link their Excel with PowerPoint for dynamic data update.
- Use macros to perform repetitive tasks and generate reports.
This program is designed for:
Accountants, senior accountants, business analysts, accounting and finance professionals, supervisors, general business professionals and staff from any function who need to learn and apply state-of-the-art reporting techniques to their daily business reporting, reconciliations, and analysis. This program is worth 25 NASBA CPEs.
Locations & Dates:
06 - 10 May 2012 Abu Dhabi, English
11 - 15 Nov 2012 Dubai, English
Meirc reserves the right to alter dates, content, venue and trainer with a reasonable notice time.
One extra free place for every 2 paid nominees
Delivery Type: Group-Live
Pre-requisites: None
Related Programs:
Program Outline
Quick Review of Excel Business and Finance Functions - Using Conditional Formatting for Reconciliation and Analysis
- Table Tools and Automatic Updating
- Defining and Managing Names
- Evaluating and Auditing Formulas
- Workspaces and Updating Links
Must Know Accounting and Business Functions for Reporting and Reconciliation - Financial and Business Formulas
- Logical Functions
- AND, IF, OR, IFERROR, NOT
- Efficient Text Functions
- LEFT, RIGHT, MID, LEN, FIND, TEXT, VALUE
- Powerful Lookup and Reference
- Information Functions
- ISNUMBER, ISERROR, ISBLANK
- The Array-Sum Function
Dynamic Data Management and Manipulation - Text-to-Columns and Dynamic Trimming
- Validating User Input with Message Alert
- Using List data to Automate and Authenticate Data Validity
- Consolidation and Creating Links
Introduction to Macro Recording and Editing - Record and Edit Macros
- Design Buttons and Menus to Activate and Run Macros
|
Mastering Pivot Tables and Pivot Charts - Inserting Pivot Tables
- Performing Analysis Using Data Manipulations
- Inserting Formulas in Pivot Tables
- Pivot Formatting, Sorting and Filtering
- Preparing Reports Using the Show Pages Function
- Conditional Formatting with Pivot Tables
- Preparing Dynamic Charts and Dynamic Labeling
- Creating Charts with 3-Axis
- Dynamic Labeling in Graphs
- Data Analysis Using the Show Values As
- Expand/Collapse Feature in Pivot Tables
- Pivot Table Options
- Date Manipulation Using Pivot Tables
- Show Data Using the Summarize Data Fields By
- Linking Excel with PowerPoint
- Creating Dynamic Pivot Tables and Pivot Charts
The New PowerPivots Tools - Applying the AutoDetect Tools
- Importing Excel Data into PowerPivots
- Building Report with Two Pivot Charts
- Slicer Management and Techniques
- Using Data Analysis Expression (DAX)
Power Excel Business Techniques - Designing Dynamic Spinners
- List Box and Option Button Modeling
- Check Box Data Reporting
- Advanced Data Analysis with Macro
|
|
|
Programs 
