Advanced Business and Financial Reporting Using Excel

Accounting, Finance & Budgeting

Course Info

Duration: 1 Week

City: London

Fees: 3,900

Type: In Classroom

Available Dates

  • Dec-06-2021

    London

  • Dec-27-2021

    London

  • Jan-03-2022

    London

  • Jan-24-2022

    London

  • Feb-07-2022

    London

  • Feb-28-2022

    London

  • Mar-07-2022

    London

  • Mar-28-2022

    London

  • Apr-04-2022

    London

  • Apr-25-2022

    London

  • May-09-2022

    London

  • May-30-2022

    London

  • June-06-2022

    London

  • June-27-2022

    London

  • July-04-2022

    London

  • July-25-2022

    London

  • Aug-08-2022

    London

  • Aug-29-2022

    London

  • Sep-05-2022

    London

  • Sep-26-2022

    London

  • Oct-03-2022

    London

  • Oct-17-2022

    London

  • Nov-14-2022

    London

  • Nov-28-2022

    London

  • Dec-05-2022

    London

  • Dec-19-2022

    London

Dates in Other Venues

  • Nov-29-2021

    Madrid

  • Dec-05-2021

    Dubai

  • Dec-06-2021

    Kuala Lumpur

  • Dec-06-2021

    Istanbul

  • Dec-06-2021

    Madrid

  • Dec-06-2021

    Geneva

  • Dec-06-2021

    Amsterdam

  • Dec-06-2021

    Berlin

  • Dec-13-2021

    Istanbul

  • Dec-13-2021

    Paris

  • Dec-19-2021

    Dubai

  • Dec-20-2021

    Paris

  • Dec-20-2021

    Kuala Lumpur

  • Dec-20-2021

    Geneva

  • Dec-20-2021

    Amsterdam

  • Dec-20-2021

    Berlin

  • Dec-26-2021

    Dubai

  • Dec-27-2021

    Madrid

  • Dec-27-2021

    Istanbul

  • Dec-27-2021

    Paris

  • Jan-03-2022

    Kuala Lumpur

  • Jan-09-2022

    Dubai

  • Jan-10-2022

    Istanbul

  • Jan-17-2022

    Paris

  • Jan-17-2022

    Geneva

  • Jan-17-2022

    Amsterdam

  • Jan-17-2022

    Berlin

  • Jan-24-2022

    Madrid

  • Jan-30-2022

    Dubai

  • Feb-07-2022

    Kuala Lumpur

  • Feb-13-2022

    Dubai

  • Feb-14-2022

    Istanbul

  • Feb-21-2022

    Paris

  • Feb-21-2022

    Geneva

  • Feb-21-2022

    Amsterdam

  • Feb-21-2022

    Berlin

  • Feb-27-2022

    Dubai

  • Feb-28-2022

    Madrid

  • Mar-07-2022

    Kuala Lumpur

  • Mar-13-2022

    Dubai

  • Mar-14-2022

    Istanbul

  • Mar-21-2022

    Paris

  • Mar-21-2022

    Geneva

  • Mar-21-2022

    Amsterdam

  • Mar-21-2022

    Berlin

  • Mar-27-2022

    Dubai

  • Mar-28-2022

    Madrid

  • Apr-03-2022

    Dubai

  • Apr-04-2022

    Kuala Lumpur

  • Apr-10-2022

    Dubai

  • Apr-11-2022

    Istanbul

  • Apr-18-2022

    Paris

  • Apr-18-2022

    Geneva

  • Apr-18-2022

    Amsterdam

  • Apr-18-2022

    Berlin

  • Apr-24-2022

    Dubai

  • Apr-25-2022

    Madrid

  • May-01-2022

    Dubai

  • May-02-2022

    Kuala Lumpur

  • May-02-2022

    Istanbul

  • May-02-2022

    Madrid

  • May-02-2022

    Geneva

  • May-02-2022

    Berlin

  • May-15-2022

    Dubai

  • May-16-2022

    Paris

  • May-16-2022

    Amsterdam

  • May-22-2022

    Dubai

  • June-05-2022

    Dubai

  • June-06-2022

    Paris

  • June-12-2022

    Dubai

  • June-20-2022

    Kuala Lumpur

  • June-20-2022

    Istanbul

  • June-20-2022

    Geneva

  • June-20-2022

    Berlin

  • June-26-2022

    Dubai

  • June-27-2022

    Madrid

  • June-27-2022

    Amsterdam

  • July-03-2022

    Dubai

  • July-04-2022

    Amsterdam

  • July-10-2022

    Dubai

  • July-11-2022

    Kuala Lumpur

  • July-11-2022

    Paris

  • July-11-2022

    Madrid

  • July-11-2022

    Geneva

  • July-11-2022

    Berlin

  • July-24-2022

    Dubai

  • July-25-2022

    Istanbul

  • Aug-07-2022

    Dubai

  • Aug-14-2022

    Dubai

  • Aug-15-2022

    Istanbul

  • Aug-15-2022

    Amsterdam

  • Aug-22-2022

    Madrid

  • Aug-28-2022

    Dubai

  • Aug-29-2022

    Kuala Lumpur

  • Aug-29-2022

    Paris

  • Aug-29-2022

    Geneva

  • Aug-29-2022

    Berlin

  • Sep-04-2022

    Dubai

  • Sep-11-2022

    Dubai

  • Sep-12-2022

    Geneva

  • Sep-12-2022

    Berlin

  • Sep-19-2022

    Kuala Lumpur

  • Sep-19-2022

    Paris

  • Sep-19-2022

    Madrid

  • Sep-25-2022

    Dubai

  • Sep-26-2022

    Istanbul

  • Sep-26-2022

    Amsterdam

  • Oct-02-2022

    Dubai

  • Oct-03-2022

    Madrid

  • Oct-03-2022

    Geneva

  • Oct-10-2022

    Kuala Lumpur

  • Oct-10-2022

    Istanbul

  • Oct-10-2022

    Paris

  • Oct-10-2022

    Amsterdam

  • Oct-17-2022

    Madrid

  • Oct-17-2022

    Geneva

  • Oct-17-2022

    Berlin

  • Oct-23-2022

    Dubai

  • Oct-24-2022

    Kuala Lumpur

  • Oct-24-2022

    Istanbul

  • Oct-24-2022

    Amsterdam

  • Oct-31-2022

    Paris

  • Oct-31-2022

    Berlin

  • Nov-07-2022

    Kuala Lumpur

  • Nov-07-2022

    Istanbul

  • Nov-07-2022

    Amsterdam

  • Nov-13-2022

    Dubai

  • Nov-14-2022

    Paris

  • Nov-14-2022

    Madrid

  • Nov-14-2022

    Geneva

  • Nov-14-2022

    Berlin

  • Nov-21-2022

    Kuala Lumpur

  • Nov-21-2022

    Istanbul

  • Nov-21-2022

    Amsterdam

  • Nov-27-2022

    Dubai

  • Nov-28-2022

    Paris

  • Nov-28-2022

    Madrid

  • Nov-28-2022

    Geneva

  • Nov-28-2022

    Berlin

  • Dec-04-2022

    Dubai

  • Dec-05-2022

    Kuala Lumpur

  • Dec-05-2022

    Istanbul

  • Dec-05-2022

    Madrid

  • Dec-05-2022

    Geneva

  • Dec-05-2022

    Amsterdam

  • Dec-05-2022

    Berlin

  • Dec-12-2022

    Paris

  • Dec-19-2022

    Berlin

  • Dec-25-2022

    Dubai

  • Dec-26-2022

    Kuala Lumpur

  • Dec-26-2022

    Istanbul

  • Dec-26-2022

    Paris

  • Dec-26-2022

    Madrid

  • Dec-26-2022

    Geneva

  • Dec-26-2022

    Amsterdam

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