FBA140 · One Week
Next Generation Excel - Advanced Business and Financial Reporting
Advance your Excel skills to create business and financial reports that stand out, all with our specialized course. LBTA Training offers Next Generation Excel - Advanced Business and Financial Reporting Course in Finance , Accounting and Budgeting Courses.
- Course Schedule
- Courses Syllabus
- Available Cities
| Venue ⇅ | Start Date ⇅ | End Date ⇅ | Net Fees ⇅ | Details & Registration |
|---|---|---|---|---|
| London, United Kingdom | 02 - Nov - 2026 | 06 - Nov - 2026 | 4,950 GBP | PDF Register |
| Madrid, Spain | 02 - Nov - 2026 | 06 - Nov - 2026 | 6,950 GBP | PDF Register |
| Munich, Germany | 02 - Nov - 2026 | 06 - Nov - 2026 | 7,900 GBP | PDF Register |
| Berlin, Germany | 02 - Nov - 2026 | 06 - Nov - 2026 | 7,900 GBP | PDF Register |
| New York, United States | 02 - Nov - 2026 | 06 - Nov - 2026 | 10,900 GBP | PDF Register |
| Amsterdam, Netherlands | 02 - Nov - 2026 | 06 - Nov - 2026 | 8,100 GBP | PDF Register |
| Milan, Italy | 02 - Nov - 2026 | 06 - Nov - 2026 | 6,950 GBP | PDF Register |
| Dubai, United Arab Emirates | 02 - Nov - 2026 | 06 - Nov - 2026 | 4,988 GBP | PDF Register |
| Paris, France | 02 - Nov - 2026 | 06 - Nov - 2026 | 6,700 GBP | PDF Register |
| Hong Kong | 02 - Nov - 2026 | 06 - Nov - 2026 | 8,500 GBP | PDF Register |
| Tokyo, Japan | 02 - Nov - 2026 | 06 - Nov - 2026 | 9,750 GBP | PDF Register |
| Kuala Lumpur, Malaysia | 02 - Nov - 2026 | 06 - Nov - 2026 | 4,750 GBP | PDF Register |
| Rome, Italy | 02 - Nov - 2026 | 06 - Nov - 2026 | 7,300 GBP | PDF Register |
| Barcelona, Spain | 02 - Nov - 2026 | 06 - Nov - 2026 | 6,950 GBP | PDF Register |
| Zurich, Switzerland | 02 - Nov - 2026 | 06 - Nov - 2026 | 7,950 GBP | PDF Register |
Showing 1 to 15 of 308 entries
Courses Syllabus
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
