Join Meirc Training & Consulting on Facebook Twitter with Meirc Training & Consulting Connect with Meirc Training & Consulting on LinkedIn feed Bookmark and Share
Webmeirc.com
 
Meirc Training & Consulting

Find a Program

Category:
City:
Language:
Month of:

Directory of Services

meirc training dubai directory of services

Programs Lists

2012
Programs

In-Company Training

Virtual University

Home Programs Finance and Accounting Next Generation Excel: Advanced Business and Financial Reporting Using Excel 2007
Next Generation Excel: Advanced Business and Financial Reporting Using Excel 2007
Program Objectives:
By the end of the program, participants will be able to:
  • Advance their Excel skills to new heights of business reporting expertise.
  • Design efficient business reporting and reconciliation models.
  • Design, prepare, and email business and accounting reports in minutes.
  • Develop dynamic business dashboards and scorecards to assist professionals in measuring performance and enhance decision making.
  • Use advanced report development techniques by linking-up Excel with Access, Web, Text, SQL, Oracle, and other databases.
  • Use macros to speed-up their routine and repetitive tasks.
This program is designed for:

General business professionals, professionals using Excel in the day-to-day business, project managers, business managers, research professionals, financial controllers, accounting managers, financial directors, senior accountants, financial analysts and general ledger 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.
Prerequisite: Attending Business and Financial Reporting using Excel 2007.

This program is worth 25 NASBA CPEs.

Fees in US$:

Per participant $3,800
Frequent nomination $3,420

(including coffee breaks and a buffet lunch daily)

Discount Plans, Refunds & Cancellations Policy
Locations & Dates:
15 - 19 Apr 2012
Abu Dhabi, English
Completed
14 - 18 Oct 2012
Dubai, English
Register
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
Program Outline

The Advanced Tools

  • Dynamic Consolidation and Multiple Consolidation Ranges
  • Data Validation
  • Multiple Scenario Manager
  • Pivot Tables ? Advanced
  • List, Check, Option, and Spinner Data Modeling
  • Advanced Formulas Techniques
  • Data Tables

Dynamic Data Consolidating

  • How a Model Should Work
  • Designing the Input, Process, and Output
  • Developing a Forecasted Financial Statement
  • Developing Financial Statements Using the GL
  • Prepare Vendor and Customer Analysis Reports
  • Build Automated Budgeting and Business Models
  • Two-Dimensional Data Tables

Dashboarding and Scorecards

  • The Ultimate Business Reporting Tool
  • Creating your Flash Management
  • Updating your Dashboard in One Click
  • Using Dynamic Labeling and Dynamic Graphing
  • Designing and Building Scorecards

Advanced Report Development

  • Working with External Data Sources
  • Connecting to Text and Importing from Delimited Files
  • Managing External Data Sources
  • Connecting to Access Database
  • Connecting with SQL Databases
  • Connecting to Web Data Sources
  • Creating a Data Source for Online Analytical Processing ? OLAP
  • Building Report Solutions

Macro-Charged Modeling and Reporting

  • The Rules of Macro Recording and Editing
  • Building Navigation Buttons for your Model
  • Adding and Configuring Controls
  • Working with LOOP, IF, Msgbox, and Input Dialogue Box
  • Building the One-Stop-Shop for your Daily Tasks and Activities
  • Automating the Process of Performing Daily Tasks

Putting you to the Test!

  • Using Learned Objectives to Plan, Design, and Implement a Complete Business Model