/  Next Generation Excel - Advanced Business and Financial Reporting Training

Next Generation Excel - Advanced Business and Financial Reporting Training

BMC Training provides a training course in Next Generation Excel - Advanced Business and Financial Reporting in Finance , Accounting and Budgeting

Course Title
Venue
Start Date
End Date
  • Dubai
    27 - 10 - 2019
    31 - 10 - 2019
  • Paris
    27 - 10 - 2019
    31 - 10 - 2019
  • Hong Kong
    27 - 10 - 2019
    31 - 10 - 2019
  • Istanbul
    17 - 11 - 2019
    21 - 11 - 2019
  • Bali
    17 - 11 - 2019
    21 - 11 - 2019
  • Singapore
    17 - 11 - 2019
    21 - 11 - 2019
  • Washington
    17 - 11 - 2019
    21 - 11 - 2019
  • Dubai
    24 - 11 - 2019
    28 - 11 - 2019
  • Paris
    24 - 11 - 2019
    28 - 11 - 2019
  • Hong Kong
    24 - 11 - 2019
    28 - 11 - 2019
  • Dubai
    3 - 11 - 2019
    7 - 11 - 2019
  • Paris
    3 - 11 - 2019
    7 - 11 - 2019
  • Hong Kong
    3 - 11 - 2019
    7 - 11 - 2019
  • Kuala Lumpur
    10 - 11 - 2019
    14 - 11 - 2019
  • Rome
    10 - 11 - 2019
    14 - 11 - 2019
  • Rome
    10 - 11 - 2019
    14 - 11 - 2019
  • Barcelona
    10 - 11 - 2019
    14 - 11 - 2019
  • Zurich
    10 - 11 - 2019
    14 - 11 - 2019
  • London
    24 - 11 - 2019
    28 - 11 - 2019
  • Madrid
    24 - 11 - 2019
    28 - 11 - 2019
  • Munich
    24 - 11 - 2019
    28 - 11 - 2019
  • Berlin
    24 - 11 - 2019
    28 - 11 - 2019
  • New York
    24 - 11 - 2019
    28 - 11 - 2019
  • London
    15 - 12 - 2019
    19 - 12 - 2019
  • Madrid
    15 - 12 - 2019
    19 - 12 - 2019
  • Munich
    15 - 12 - 2019
    19 - 12 - 2019
  • Berlin
    15 - 12 - 2019
    19 - 12 - 2019
  • New York
    15 - 12 - 2019
    19 - 12 - 2019
  • Dubai
    22 - 12 - 2019
    26 - 12 - 2019
  • Paris
    22 - 12 - 2019
    26 - 12 - 2019
  • Hong Kong
    22 - 12 - 2019
    26 - 12 - 2019
  • Istanbul
    8 - 12 - 2019
    12 - 12 - 2019
  • Bali
    8 - 12 - 2019
    12 - 12 - 2019
  • Singapore
    8 - 12 - 2019
    12 - 12 - 2019
  • Washington
    8 - 12 - 2019
    12 - 12 - 2019
  • Kuala Lumpur
    1 - 12 - 2019
    5 - 12 - 2019
  • Rome
    1 - 12 - 2019
    5 - 12 - 2019
  • Rome
    1 - 12 - 2019
    5 - 12 - 2019
  • Barcelona
    1 - 12 - 2019
    5 - 12 - 2019
  • Zurich
    1 - 12 - 2019
    5 - 12 - 2019
  • Istanbul
    26 - 1 - 2020
    30 - 1 - 2020
  • Bali
    26 - 1 - 2020
    30 - 1 - 2020
  • Singapore
    26 - 1 - 2020
    30 - 1 - 2020
  • Washington
    26 - 1 - 2020
    30 - 1 - 2020
  • Dubai
    19 - 1 - 2020
    23 - 1 - 2020
  • Paris
    19 - 1 - 2020
    23 - 1 - 2020
  • Hong Kong
    19 - 1 - 2020
    23 - 1 - 2020
  • Dubai
    12 - 1 - 2020
    16 - 1 - 2020
  • Paris
    12 - 1 - 2020
    16 - 1 - 2020
  • Hong Kong
    12 - 1 - 2020
    16 - 1 - 2020
  • Kuala Lumpur
    5 - 1 - 2020
    9 - 1 - 2020
  • Rome
    5 - 1 - 2020
    9 - 1 - 2020
  • Rome
    5 - 1 - 2020
    9 - 1 - 2020
  • Barcelona
    5 - 1 - 2020
    9 - 1 - 2020
  • Zurich
    5 - 1 - 2020
    9 - 1 - 2020
  • London
    19 - 1 - 2020
    23 - 1 - 2020
  • Madrid
    19 - 1 - 2020
    23 - 1 - 2020
  • Munich
    19 - 1 - 2020
    23 - 1 - 2020
  • Berlin
    19 - 1 - 2020
    23 - 1 - 2020
  • New York
    19 - 1 - 2020
    23 - 1 - 2020
  • London
    23 - 2 - 2020
    27 - 2 - 2020
  • Madrid
    23 - 2 - 2020
    27 - 2 - 2020
  • Munich
    23 - 2 - 2020
    27 - 2 - 2020
  • Berlin
    23 - 2 - 2020
    27 - 2 - 2020
  • New York
    23 - 2 - 2020
    27 - 2 - 2020
  • Dubai
    16 - 2 - 2020
    20 - 2 - 2020
  • Paris
    16 - 2 - 2020
    20 - 2 - 2020
  • Hong Kong
    16 - 2 - 2020
    20 - 2 - 2020
  • Istanbul
    9 - 2 - 2020
    13 - 2 - 2020
  • Bali
    9 - 2 - 2020
    13 - 2 - 2020
  • Singapore
    9 - 2 - 2020
    13 - 2 - 2020
  • Washington
    9 - 2 - 2020
    13 - 2 - 2020
  • Kuala Lumpur
    2 - 2 - 2020
    6 - 2 - 2020
  • Rome
    2 - 2 - 2020
    6 - 2 - 2020
  • Rome
    2 - 2 - 2020
    6 - 2 - 2020
  • Barcelona
    2 - 2 - 2020
    6 - 2 - 2020
  • Zurich
    2 - 2 - 2020
    6 - 2 - 2020
  • Istanbul
    15 - 3 - 2020
    19 - 3 - 2020
  • Bali
    15 - 3 - 2020
    19 - 3 - 2020
  • Singapore
    15 - 3 - 2020
    19 - 3 - 2020
  • Washington
    15 - 3 - 2020
    19 - 3 - 2020
  • Dubai
    8 - 3 - 2020
    12 - 3 - 2020
  • Paris
    8 - 3 - 2020
    12 - 3 - 2020
  • Hong Kong
    8 - 3 - 2020
    12 - 3 - 2020
  • Dubai
    1 - 3 - 2020
    5 - 3 - 2020
  • Paris
    1 - 3 - 2020
    5 - 3 - 2020
  • Hong Kong
    1 - 3 - 2020
    5 - 3 - 2020
  • Kuala Lumpur
    22 - 3 - 2020
    26 - 3 - 2020
  • Rome
    22 - 3 - 2020
    26 - 3 - 2020
  • Rome
    22 - 3 - 2020
    26 - 3 - 2020
  • Barcelona
    22 - 3 - 2020
    26 - 3 - 2020
  • Zurich
    22 - 3 - 2020
    26 - 3 - 2020
  • London
    8 - 3 - 2020
    12 - 3 - 2020
  • Madrid
    8 - 3 - 2020
    12 - 3 - 2020
  • Munich
    8 - 3 - 2020
    12 - 3 - 2020
  • Berlin
    8 - 3 - 2020
    12 - 3 - 2020
  • New York
    8 - 3 - 2020
    12 - 3 - 2020
  • London
    26 - 4 - 2020
    30 - 4 - 2020
  • Madrid
    26 - 4 - 2020
    30 - 4 - 2020
  • Munich
    26 - 4 - 2020
    30 - 4 - 2020
  • Berlin
    26 - 4 - 2020
    30 - 4 - 2020
  • New York
    26 - 4 - 2020
    30 - 4 - 2020
  • Dubai
    5 - 4 - 2020
    9 - 4 - 2020
  • Paris
    5 - 4 - 2020
    9 - 4 - 2020
  • Hong Kong
    5 - 4 - 2020
    9 - 4 - 2020
  • Istanbul
    12 - 4 - 2020
    16 - 4 - 2020
  • Bali
    12 - 4 - 2020
    16 - 4 - 2020
  • Singapore
    12 - 4 - 2020
    16 - 4 - 2020
  • Washington
    12 - 4 - 2020
    16 - 4 - 2020
  • Kuala Lumpur
    19 - 4 - 2020
    23 - 4 - 2020
  • Rome
    19 - 4 - 2020
    23 - 4 - 2020
  • Rome
    19 - 4 - 2020
    23 - 4 - 2020
  • Barcelona
    19 - 4 - 2020
    23 - 4 - 2020
  • Zurich
    19 - 4 - 2020
    23 - 4 - 2020
  • Istanbul
    10 - 5 - 2020
    14 - 5 - 2020
  • Bali
    10 - 5 - 2020
    14 - 5 - 2020
  • Singapore
    10 - 5 - 2020
    14 - 5 - 2020
  • Washington
    10 - 5 - 2020
    14 - 5 - 2020
  • Dubai
    3 - 5 - 2020
    7 - 5 - 2020
  • Paris
    3 - 5 - 2020
    7 - 5 - 2020
  • Hong Kong
    3 - 5 - 2020
    7 - 5 - 2020
  • Dubai
    17 - 5 - 2020
    21 - 5 - 2020
  • Paris
    17 - 5 - 2020
    21 - 5 - 2020
  • Hong Kong
    17 - 5 - 2020
    21 - 5 - 2020
  • Kuala Lumpur
    24 - 5 - 2020
    28 - 5 - 2020
  • Rome
    24 - 5 - 2020
    28 - 5 - 2020
  • Rome
    24 - 5 - 2020
    28 - 5 - 2020
  • Barcelona
    24 - 5 - 2020
    28 - 5 - 2020
  • Zurich
    24 - 5 - 2020
    28 - 5 - 2020
  • London
    3 - 5 - 2020
    7 - 5 - 2020
  • Madrid
    3 - 5 - 2020
    7 - 5 - 2020
  • Munich
    3 - 5 - 2020
    7 - 5 - 2020
  • Berlin
    3 - 5 - 2020
    7 - 5 - 2020
  • New York
    3 - 5 - 2020
    7 - 5 - 2020
  • London
    14 - 6 - 2020
    18 - 6 - 2020
  • Madrid
    14 - 6 - 2020
    18 - 6 - 2020
  • Munich
    14 - 6 - 2020
    18 - 6 - 2020
  • Berlin
    14 - 6 - 2020
    18 - 6 - 2020
  • New York
    14 - 6 - 2020
    18 - 6 - 2020
  • Dubai
    21 - 6 - 2020
    25 - 6 - 2020
  • Paris
    21 - 6 - 2020
    25 - 6 - 2020
  • Hong Kong
    21 - 6 - 2020
    25 - 6 - 2020
  • Istanbul
    28 - 6 - 2020
    2 - 7 - 2020
  • Bali
    28 - 6 - 2020
    2 - 7 - 2020
  • Singapore
    28 - 6 - 2020
    2 - 7 - 2020
  • Washington
    28 - 6 - 2020
    2 - 7 - 2020
  • Kuala Lumpur
    7 - 6 - 2020
    11 - 6 - 2020
  • Rome
    7 - 6 - 2020
    11 - 6 - 2020
  • Rome
    7 - 6 - 2020
    11 - 6 - 2020
  • Barcelona
    7 - 6 - 2020
    11 - 6 - 2020
  • Zurich
    7 - 6 - 2020
    11 - 6 - 2020
  • Istanbul
    5 - 7 - 2020
    9 - 7 - 2020
  • Bali
    5 - 7 - 2020
    9 - 7 - 2020
  • Singapore
    5 - 7 - 2020
    9 - 7 - 2020
  • Washington
    5 - 7 - 2020
    9 - 7 - 2020
  • Dubai
    12 - 7 - 2020
    16 - 7 - 2020
  • Paris
    12 - 7 - 2020
    16 - 7 - 2020
  • Hong Kong
    12 - 7 - 2020
    16 - 7 - 2020
  • Dubai
    19 - 7 - 2020
    23 - 7 - 2020
  • Paris
    19 - 7 - 2020
    23 - 7 - 2020
  • Hong Kong
    19 - 7 - 2020
    23 - 7 - 2020
  • Kuala Lumpur
    26 - 7 - 2020
    30 - 7 - 2020
  • Rome
    26 - 7 - 2020
    30 - 7 - 2020
  • Rome
    26 - 7 - 2020
    30 - 7 - 2020
  • Barcelona
    26 - 7 - 2020
    30 - 7 - 2020
  • Zurich
    26 - 7 - 2020
    30 - 7 - 2020
  • London
    12 - 7 - 2020
    16 - 7 - 2020
  • Madrid
    12 - 7 - 2020
    16 - 7 - 2020
  • Munich
    12 - 7 - 2020
    16 - 7 - 2020
  • Berlin
    12 - 7 - 2020
    16 - 7 - 2020
  • New York
    12 - 7 - 2020
    16 - 7 - 2020
  • London
    19 - 7 - 2020
    23 - 7 - 2020
  • Madrid
    19 - 7 - 2020
    23 - 7 - 2020
  • Munich
    19 - 7 - 2020
    23 - 7 - 2020
  • Berlin
    19 - 7 - 2020
    23 - 7 - 2020
  • New York
    19 - 7 - 2020
    23 - 7 - 2020
  • London
    2 - 8 - 2020
    6 - 8 - 2020
  • Madrid
    2 - 8 - 2020
    6 - 8 - 2020
  • Munich
    2 - 8 - 2020
    6 - 8 - 2020
  • Berlin
    2 - 8 - 2020
    6 - 8 - 2020
  • New York
    2 - 8 - 2020
    6 - 8 - 2020
  • Dubai
    9 - 8 - 2020
    13 - 8 - 2020
  • Paris
    9 - 8 - 2020
    13 - 8 - 2020
  • Hong Kong
    9 - 8 - 2020
    13 - 8 - 2020
  • Istanbul
    16 - 8 - 2020
    20 - 8 - 2020
  • Bali
    16 - 8 - 2020
    20 - 8 - 2020
  • Singapore
    16 - 8 - 2020
    20 - 8 - 2020
  • Washington
    16 - 8 - 2020
    20 - 8 - 2020
  • Kuala Lumpur
    23 - 8 - 2020
    27 - 8 - 2020
  • Rome
    23 - 8 - 2020
    27 - 8 - 2020
  • Rome
    23 - 8 - 2020
    27 - 8 - 2020
  • Barcelona
    23 - 8 - 2020
    27 - 8 - 2020
  • Zurich
    23 - 8 - 2020
    27 - 8 - 2020
  • Istanbul
    27 - 9 - 2020
    1 - 10 - 2020
  • Bali
    27 - 9 - 2020
    1 - 10 - 2020
  • Singapore
    27 - 9 - 2020
    1 - 10 - 2020
  • Washington
    27 - 9 - 2020
    1 - 10 - 2020
  • Dubai
    6 - 9 - 2020
    10 - 9 - 2020
  • Paris
    6 - 9 - 2020
    10 - 9 - 2020
  • Hong Kong
    6 - 9 - 2020
    10 - 9 - 2020
  • Dubai
    13 - 9 - 2020
    17 - 9 - 2020
  • Paris
    13 - 9 - 2020
    17 - 9 - 2020
  • Hong Kong
    13 - 9 - 2020
    17 - 9 - 2020
  • Kuala Lumpur
    20 - 9 - 2020
    24 - 9 - 2020
  • Rome
    20 - 9 - 2020
    24 - 9 - 2020
  • Rome
    20 - 9 - 2020
    24 - 9 - 2020
  • Barcelona
    20 - 9 - 2020
    24 - 9 - 2020
  • Zurich
    20 - 9 - 2020
    24 - 9 - 2020
  • London
    6 - 9 - 2020
    10 - 9 - 2020
  • Madrid
    6 - 9 - 2020
    10 - 9 - 2020
  • Munich
    6 - 9 - 2020
    10 - 9 - 2020
  • Berlin
    6 - 9 - 2020
    10 - 9 - 2020
  • New York
    6 - 9 - 2020
    10 - 9 - 2020
  • Istanbul
    4 - 10 - 2020
    8 - 10 - 2020
  • Bali
    4 - 10 - 2020
    8 - 10 - 2020
  • Singapore
    4 - 10 - 2020
    8 - 10 - 2020
  • Washington
    4 - 10 - 2020
    8 - 10 - 2020

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

Courses Search

Recent Posts

Connect with us

IFRS Preparation. (5 Days)Available in London - Dubai - Istanbul - Kuala Lumpur

Join our Civil and Construction Engineering Training Courses , Electrical and Power Engineering Training Courses and Facilities Management Training

Technical Training Courses

Newsletter