Advanced Business and Financial Reporting Using Excel

Course Info

Date: Dec-02-2024

Length: 1 Week

City: London

Fees: 4,380

Type: In Classroom

Available Dates

  • Dec-02-2024

    London

  • Dec-23-2024

    London

  • Jan-13-2025

    London

  • Feb-10-2025

    London

  • Mar-10-2025

    London

  • Apr-14-2025

    London

  • May-12-2025

    London

  • June-09-2025

    London

  • July-14-2025

    London

  • Aug-11-2025

    London

  • Sep-08-2025

    London

  • Oct-13-2025

    London

  • Nov-10-2025

    London

  • Dec-08-2025

    London

Dates in Other Venues

  • Dec-02-2024

    Amsterdam

  • Dec-09-2024

    Kuala Lumpur

  • Dec-09-2024

    Istanbul

  • Dec-16-2024

    Paris

  • Dec-16-2024

    Singapore

  • Dec-23-2024

    Dubai

  • Dec-30-2024

    Barcelona

  • Dec-30-2024

    Amsterdam

  • Jan-06-2025

    Paris

  • Jan-06-2025

    Singapore

  • Jan-13-2025

    Amsterdam

  • Jan-20-2025

    Barcelona

  • Jan-20-2025

    Dubai

  • Jan-27-2025

    Kuala Lumpur

  • Jan-27-2025

    Istanbul

  • Feb-03-2025

    Singapore

  • Feb-03-2025

    Paris

  • Feb-10-2025

    Amsterdam

  • Feb-17-2025

    Dubai

  • Feb-17-2025

    Barcelona

  • Feb-24-2025

    Kuala Lumpur

  • Feb-24-2025

    Istanbul

  • Mar-03-2025

    Singapore

  • Mar-03-2025

    Paris

  • Mar-10-2025

    Amsterdam

  • Mar-17-2025

    Barcelona

  • Mar-17-2025

    Dubai

  • Mar-24-2025

    Kuala Lumpur

  • Mar-24-2025

    Istanbul

  • Apr-07-2025

    Paris

  • Apr-07-2025

    Singapore

  • Apr-14-2025

    Amsterdam

  • Apr-21-2025

    Dubai

  • Apr-21-2025

    Barcelona

  • Apr-28-2025

    Kuala Lumpur

  • Apr-28-2025

    Istanbul

  • May-05-2025

    Paris

  • May-05-2025

    Singapore

  • May-12-2025

    Amsterdam

  • May-19-2025

    Dubai

  • May-19-2025

    Barcelona

  • May-26-2025

    Istanbul

  • May-26-2025

    Kuala Lumpur

  • June-02-2025

    Paris

  • June-02-2025

    Singapore

  • June-09-2025

    Amsterdam

  • June-16-2025

    Dubai

  • June-16-2025

    Barcelona

  • June-23-2025

    Istanbul

  • June-30-2025

    Paris

  • June-30-2025

    Singapore

  • June-30-2025

    Kuala Lumpur

  • July-07-2025

    Singapore

  • July-07-2025

    Paris

  • July-14-2025

    Amsterdam

  • July-21-2025

    Barcelona

  • July-21-2025

    Dubai

  • July-28-2025

    Istanbul

  • July-28-2025

    Kuala Lumpur

  • Aug-04-2025

    Paris

  • Aug-04-2025

    Singapore

  • Aug-11-2025

    Amsterdam

  • Aug-18-2025

    Dubai

  • Aug-18-2025

    Barcelona

  • Aug-25-2025

    Istanbul

  • Aug-25-2025

    Kuala Lumpur

  • Sep-01-2025

    Singapore

  • Sep-01-2025

    Paris

  • Sep-08-2025

    Amsterdam

  • Sep-15-2025

    Barcelona

  • Sep-15-2025

    Dubai

  • Sep-22-2025

    Istanbul

  • Sep-29-2025

    Singapore

  • Sep-29-2025

    Paris

  • Sep-29-2025

    Kuala Lumpur

  • Oct-06-2025

    Singapore

  • Oct-06-2025

    Paris

  • Oct-13-2025

    Amsterdam

  • Oct-20-2025

    Dubai

  • Oct-20-2025

    Barcelona

  • Oct-27-2025

    Istanbul

  • Oct-27-2025

    Kuala Lumpur

  • Nov-03-2025

    Paris

  • Nov-03-2025

    Singapore

  • Nov-10-2025

    Amsterdam

  • Nov-17-2025

    Barcelona

  • Nov-17-2025

    Dubai

  • Nov-24-2025

    Kuala Lumpur

  • Nov-24-2025

    Istanbul

  • Dec-01-2025

    Singapore

  • Dec-01-2025

    Paris

  • Dec-08-2025

    Amsterdam

  • Dec-15-2025

    Dubai

  • Dec-15-2025

    Barcelona

  • Dec-22-2025

    Istanbul

  • Dec-29-2025

    Singapore

  • Dec-29-2025

    Paris

  • Dec-29-2025

    Kuala Lumpur

Course Details

Course Outline

5 days course

 

The Advanced Tools

 

  • Dynamic Consolidation and Multiple Consolidation Ranges.
  • Data Validation.
  • Multiple Scenario Manager.
  • Pivot Tables - Advanced.
  • List, Check, Option, and Spinner Data Modelling.
  • 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 Labelling 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 Modelling 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.

Course Video