This workshop equips participants with the practical skills to build accurate, efficient, and dynamic budgets by integrating traditional budgeting techniques with modern automation and AI technologies. Participants will learn how to design structured and standardized Excel models, utilize advanced analytical tools for forecasting and optimization, and apply Generative AI to automate repetitive tasks, predict future trends, and generate insightful financial reports.
By the end of this training, participants will be empowered to transition from manual data processing to strategic financial planning—achieving higher accuracy, speed, and foresight in budgeting and forecasting.
Day 1 – Budgeting Foundations and Excel Modeling Essentials
- Module 1: Budgeting Overview & AI Context
- Module 2: Spreadsheet Design & Core Functions
- Module 3: Building Core Budgetary Statements
- Module 4: Forecasting Techniques
Day 2 – Advanced Modeling, Automation, and AI Integration
- Module 5: Advanced Analysis – Optimization & Risk
- Module 6: Scenario Planning & Sensitivity
- Module 7: Automation & Budget Consolidation
- Module 8: Integrating Generative AI
Learning Outcomes / Key Takeaways
- Prepare accurate and reliable budgets and forecasts in less time
- Build complete and error-minimized budgetary models in Excel through structured
spreadsheet design - Apply Excel analytical tools such as decision logic, Data Tables, and Scenario Manager for scenario-based budgeting
- Utilize optimization methods including Excel Solver and Goal Seek for resource allocation and performance optimization
- Employ advanced Excel features (e.g., IF, VLOOKUP, XLOOKUP) for efficient data
manipulation and reporting - Automate repetitive tasks using VBA macros to streamline data preparation and report generation
- Integrate Generative AI tools (such as ChatGPT or similar AI tools) to enhance forecasting accuracy through pattern analysis and predictive modeling
- Combine human strategic insights (e.g., KPIs, business goals) with AI efficiency for optimal budgetary decision-making
- Consolidate multi-departmental budgets
Prerequisites
Participants should ideally have:
- Prior experience in preparing budgets or forecasts
- A foundational understanding of financial statements (P&L, Cash Flow, Capital Budgeting)
- Basic proficiency in Microsoft Excel (data entry, formulas, and navigation)
This workshop qualifies for 14.0 CPE hours in Information Technology (Category 5).
Please bring along your laptop and USB drive.
- Software: Microsoft Excel / Microsoft 365 (recommended for access to modern functions such as XLOOKUP, FILTER, and Power Query)
- Generative AI Tool: Access to a Generative AI platform such as ChatGPT-4, which supports interactive financial analysis and automated reporting
- Hardware & Connectivity: A reliable laptop with sufficient RAM and CPU, plus stable internet connectivity to handle large Excel files and AI integration
- Accountants
- Finance Managers & Controllers
- Department Heads & Senior Managers
- Managers involved in the preparation of Budgets and Cash Flows
- FP&A Professionals and Finance Leaders embracing digital transformation
Participants should ideally have:
- Prior experience in preparing budgets or forecasts
- A foundational understanding of financial statements (P&L, Cash Flow, Capital Budgeting)
- Basic proficiency in Microsoft Excel (data entry, formulas, and navigation)
Dr Lim Thou Tin is an accomplished business and IT strategist, senior management consultant, certified adult educator, and curriculum developer with over 40 years of combined experience in finance, IT, and professional education.
Dr Lim specializes in enhancing the capabilities of professionals in finance, accounting, and auditing through the strategic application of information technology, automation, and business analytics. His work focuses on bridging financial expertise with emerging AI-driven tools to help organizations modernize their workflows, strengthen analytical capabilities, and achieve operational excellence.
