Next Generation Excel -  Advanced Business and Financial Reporting

Next Generation Excel - Advanced Business and Financial Reporting


Choose from the following table the course date which you would like to attend the course on :

Sart
End
Fees
Venue
Length
4-Mar-2018
8-Mar-2018
7500$
Istanbul (Turkey)
One Week
Click Here
11-Mar-2018
15-Mar-2018
4700$
Dubai (UAE)
One Week
Click Here
4-Mar-2018
8-Mar-2018
6950$
Paris (France)
One Week
Click Here
15-Apr-2018
19-Apr-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
8-Apr-2018
12-Apr-2018
5700$
London (UK)
One Week
Click Here
20-May-2018
24-May-2018
7500$
Istanbul (Turkey)
One Week
Click Here
6-May-2018
10-May-2018
4700$
Dubai (UAE)
One Week
Click Here
20-May-2018
24-May-2018
6950$
Paris (France)
One Week
Click Here
10-Jun-2018
14-Jun-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
17-Jun-2018
21-Jun-2018
5700$
London (UK)
One Week
Click Here
15-Jul-2018
19-Jul-2018
7500$
Istanbul (Turkey)
One Week
Click Here
8-Jul-2018
12-Jul-2018
4700$
Dubai (UAE)
One Week
Click Here
15-Jul-2018
19-Jul-2018
6950$
Paris (France)
One Week
Click Here
12-Aug-2018
16-Aug-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
26-Aug-2018
30-Aug-2018
5700$
London (UK)
One Week
Click Here
9-Sep-2018
13-Sep-2018
7500$
Istanbul (Turkey)
One Week
Click Here
16-Sep-2018
20-Sep-2018
4700$
Dubai (UAE)
One Week
Click Here
9-Sep-2018
13-Sep-2018
6950$
Paris (France)
One Week
Click Here
28-Oct-2018
1-Nov-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
21-Oct-2018
25-Oct-2018
5700$
London (UK)
One Week
Click Here
4-Nov-2018
8-Nov-2018
7500$
Istanbul (Turkey)
One Week
Click Here
11-Nov-2018
15-Nov-2018
4700$
Dubai (UAE)
One Week
Click Here
4-Nov-2018
8-Nov-2018
6950$
Paris (France)
One Week
Click Here
16-Dec-2018
20-Dec-2018
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
9-Dec-2018
13-Dec-2018
5700$
London (UK)
One Week
Click Here
13-Jan-2019
17-Jan-2019
7500$
Istanbul (Turkey)
One Week
Click Here
20-Jan-2019
24-Jan-2019
4700$
Dubai (UAE)
One Week
Click Here
13-Jan-2019
17-Jan-2019
6950$
Paris (France)
One Week
Click Here
24-Feb-2019
28-Feb-2019
4700$
Kuala Lumpur (Malaysia)
One Week
Click Here
17-Feb-2019
21-Feb-2019
5700$
London (UK)
One Week
Click Here

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

Get Information / Register