Next Generation Excel - Advanced Business and Financial Reporting Course

BMC Training provides Next Generation Excel - Advanced Business and Financial Reporting in Finance , Accounting and Budgeting. There are 33 training sessions in different cities.

Next Generation Excel - Advanced Business and Financial Reporting Course Schedule

Type a city name
Venue Start Date End Date Details
London , UK 17 - 12 - 2023 21 - 12 - 2023
Details
Dubai , UAE 24 - 12 - 2023 28 - 12 - 2023
Details
Paris , France 24 - 12 - 2023 28 - 12 - 2023
Details
Istanbul , Turkey 28 - 1 - 2024 1 - 2 - 2024
Details
Dubai , UAE 21 - 1 - 2024 25 - 1 - 2024
Details
Dubai , UAE 14 - 1 - 2024 18 - 1 - 2024
Details
Kuala Lumpur , Malaysia 7 - 1 - 2024 11 - 1 - 2024
Details
London , UK 21 - 1 - 2024 25 - 1 - 2024
Details
Paris , France 21 - 1 - 2024 25 - 1 - 2024
Details
Paris , France 14 - 1 - 2024 18 - 1 - 2024
Details
London , UK 25 - 2 - 2024 29 - 2 - 2024
Details
Dubai , UAE 18 - 2 - 2024 22 - 2 - 2024
Details
Istanbul , Turkey 11 - 2 - 2024 15 - 2 - 2024
Details
Kuala Lumpur , Malaysia 4 - 2 - 2024 8 - 2 - 2024
Details
Dubai , UAE 11 - 2 - 2024 15 - 2 - 2024
Details
London , UK 11 - 2 - 2024 15 - 2 - 2024
Details
Paris , France 18 - 2 - 2024 22 - 2 - 2024
Details
Paris , France 11 - 2 - 2024 15 - 2 - 2024
Details
Istanbul , Turkey 17 - 3 - 2024 21 - 3 - 2024
Details
Dubai , UAE 10 - 3 - 2024 14 - 3 - 2024
Details
Dubai , UAE 3 - 3 - 2024 7 - 3 - 2024
Details
Kuala Lumpur , Malaysia 24 - 3 - 2024 28 - 3 - 2024
Details
London , UK 10 - 3 - 2024 14 - 3 - 2024
Details
Paris , France 10 - 3 - 2024 14 - 3 - 2024
Details
Paris , France 3 - 3 - 2024 7 - 3 - 2024
Details
London , UK 28 - 4 - 2024 2 - 5 - 2024
Details
Dubai , UAE 7 - 4 - 2024 11 - 4 - 2024
Details
Istanbul , Turkey 14 - 4 - 2024 18 - 4 - 2024
Details
Kuala Lumpur , Malaysia 21 - 4 - 2024 25 - 4 - 2024
Details
Dubai , UAE 14 - 4 - 2024 18 - 4 - 2024
Details
London , UK 14 - 4 - 2024 18 - 4 - 2024
Details
Paris , France 7 - 4 - 2024 11 - 4 - 2024
Details
Paris , France 14 - 4 - 2024 18 - 4 - 2024
Details

Course Description

Program Objectives:

  • 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.

The Course:

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