Next Generation Excel -  Advanced Business and Financial Reporting


Ref.
Sart
End
Fees
Venue
Length
FBA140
10-Jun-2018
14-Jun-2018
4700$
Kuala Lumpur (Malaysia)
One Week

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 more details about this training !

Register Request

Choose the course date which you would like to attend your course on ...


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

There are three easy ways to make a registeration:

  • Register Online: Choose the course you would like to register for, Click the “REGISTER” link in the course outlines and then complete the form.
  • E-mail: Send the course details (Course Title , Course Date and Course Venue) and your company details (Company Name , Company Phone , Company Address and Company email) to Training@Oxygentraining.org
  • Telephone: Please call +44 20 8720 7333.
When should I expect to receive the confirmation file?

When we receive your registration request, we will send you the following by e-mail:

  • Confirmation File
  • Invoice File
How and When do I arrange payment?

Payment must be received before the training starts. You can make payment by wire transfer or cash.

Note: If the payment is not received before the training , Oxygen has the right to cancel your registration at any time.

What is included in the fees?

The fees for all training courses cover all materials, lunch , refreshments and airport transportation.

How can I cancel my registation?

Request for training course cancellation must be made received by Oxygen three weeks prior to the training course start date. A USD 300.00 processing fee will be charge per delegate for each cancellation. Thereafter, we regret that we are unable to refund any fees due.


next generation excel advanced business financial reporting