London Business Training Academy
HomeManagement and Leadership CoursesFinance, Accounting and Budgeting CoursesHuman Resource Management CoursesProject, Procurement and Contracts CoursesSecretarial and Administration CoursesPR, Customer Services, Sales and Marketing CoursesQuality and Productivity CoursesMaintenance Engineering Training CoursesOil and Gas Training CoursesWarehouse, Logistics, Supply Chain and Inventory Courses

Next Generation Excel - Advanced Business and Financial Reporting Course

Advance your Excel skills to create business and financial reports that stand out, all with our specialized course. LBTA offers Next Generation Excel - Advanced Business and Financial Reporting Course in Finance , Accounting and Budgeting Courses.

◎English⧗One Week●Confirmed£from 4,700 GBP

Upcoming schedule

210 sessions
VenueStartsEndsNet feesBook
Bali, Indonesia5-Jul-20269-Jul-20268,100 GBPRegister
Barcelona, Spain5-Jul-20269-Jul-20266,950 GBPRegister
Dubai, UAE5-Jul-20269-Jul-20264,987.5 GBPRegister
Interlaken, Switzerland5-Jul-20269-Jul-20268,950 GBPRegister
Kuala Lumpur, Malaysia5-Jul-20269-Jul-20264,750 GBPRegister
London, UK5-Jul-20269-Jul-20264,950 GBPRegister
Madrid, Spain5-Jul-20269-Jul-20266,950 GBPRegister
Milan, Italy5-Jul-20269-Jul-20266,950 GBPRegister
New York, United States5-Jul-20269-Jul-202610,900 GBPRegister
Paris, France5-Jul-20269-Jul-20266,700 GBPRegister
Rome, Italy5-Jul-20269-Jul-20267,300 GBPRegister
Tokyo, Japan5-Jul-20269-Jul-20269,750 GBPRegister

Course 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

Related courses

Financial Accounting, Reporting and Business Support in the Oil and Gas Industry CourseRisk Based Internal Auditing CourseDeveloping, Improving and Monitoring the Internal Audit Function CourseActuarial Valuation Principles and Practices CourseChartered Financial Analyst - CFA Level 1 Preparation Course CourseCost Analysis to Support Strategic Decisions Course