Next Generation Excel - Advanced Business and Financial Reporting Course Schedule
Type a city name
| Venue | Start Date | End Date | Details |
|---|---|---|---|
| London , UK | 17 - 12 - 2023 | 21 - 12 - 2023 |
|
| Dubai , UAE | 24 - 12 - 2023 | 28 - 12 - 2023 |
|
| Paris , France | 24 - 12 - 2023 | 28 - 12 - 2023 |
|
| Istanbul , Turkey | 28 - 1 - 2024 | 1 - 2 - 2024 |
|
| Dubai , UAE | 21 - 1 - 2024 | 25 - 1 - 2024 |
|
| Dubai , UAE | 14 - 1 - 2024 | 18 - 1 - 2024 |
|
| Kuala Lumpur , Malaysia | 7 - 1 - 2024 | 11 - 1 - 2024 |
|
| London , UK | 21 - 1 - 2024 | 25 - 1 - 2024 |
|
| Paris , France | 21 - 1 - 2024 | 25 - 1 - 2024 |
|
| Paris , France | 14 - 1 - 2024 | 18 - 1 - 2024 |
|
| London , UK | 25 - 2 - 2024 | 29 - 2 - 2024 |
|
| Dubai , UAE | 18 - 2 - 2024 | 22 - 2 - 2024 |
|
| Istanbul , Turkey | 11 - 2 - 2024 | 15 - 2 - 2024 |
|
| Kuala Lumpur , Malaysia | 4 - 2 - 2024 | 8 - 2 - 2024 |
|
| Dubai , UAE | 11 - 2 - 2024 | 15 - 2 - 2024 |
|
| London , UK | 11 - 2 - 2024 | 15 - 2 - 2024 |
|
| Paris , France | 18 - 2 - 2024 | 22 - 2 - 2024 |
|
| Paris , France | 11 - 2 - 2024 | 15 - 2 - 2024 |
|
| Istanbul , Turkey | 17 - 3 - 2024 | 21 - 3 - 2024 |
|
| Dubai , UAE | 10 - 3 - 2024 | 14 - 3 - 2024 |
|
| Dubai , UAE | 3 - 3 - 2024 | 7 - 3 - 2024 |
|
| Kuala Lumpur , Malaysia | 24 - 3 - 2024 | 28 - 3 - 2024 |
|
| London , UK | 10 - 3 - 2024 | 14 - 3 - 2024 |
|
| Paris , France | 10 - 3 - 2024 | 14 - 3 - 2024 |
|
| Paris , France | 3 - 3 - 2024 | 7 - 3 - 2024 |
|
| London , UK | 28 - 4 - 2024 | 2 - 5 - 2024 |
|
| Dubai , UAE | 7 - 4 - 2024 | 11 - 4 - 2024 |
|
| Istanbul , Turkey | 14 - 4 - 2024 | 18 - 4 - 2024 |
|
| Kuala Lumpur , Malaysia | 21 - 4 - 2024 | 25 - 4 - 2024 |
|
| Dubai , UAE | 14 - 4 - 2024 | 18 - 4 - 2024 |
|
| London , UK | 14 - 4 - 2024 | 18 - 4 - 2024 |
|
| Paris , France | 7 - 4 - 2024 | 11 - 4 - 2024 |
|
| Paris , France | 14 - 4 - 2024 | 18 - 4 - 2024 |
|
Course Description
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
