Planning, Forecasting & Budgeting are 3 of the most important functions in business. Performed properly they can lead to exceptional success. Yet many people do not use the tools available to them to their best advantage. In this conference, we will leverage the power of Excel to demonstrate how to improve your forecasting, planning, and budgeting. By developing better spreadsheets & models, planning is more accurate, forecasting is more precise & budgeting is more attainable. And the time to develop these is dramatically reduced.
Forecasts, plans, and budgets may be improved through extensive what-if analysis to find key factors for management to monitor. Furthermore, these tools can be easily transferred into business plans which provide the guide to the overall performance of the firm.
Understand the various Excel tools available to perform planning, forecasting & budgeting
Perform sophisticated “what-if” scenarios to improve decision making
Know what Excel techniques to use in a given situation
Use the most advanced spreadsheet techniques
Develop an improved understanding of how well prepared Excel models to help the corporate in today’s challenging world.
Understand the risks & rewards of various planning decisions
Calculate the impact of alternative inputs on critical outputs
Enhance their knowledge with the use of the models in the case studies
Financial Accounting Team Members
Cost and Management Accounting Staff
Finance Managers
Budget Managers
Commercial Managers
Capital Investment and Project Team Members
Employees who want to gain great knowledge to improve their career
Worksheet fundamentals
Using the F4 key for Relative & Absolute cell references
Expose ALL formulas in a worksheet using the built-in function for faster review
Naming cells & ranges for quicker, more accurate work
Freeze panes, columns & rows for easier viewing while scrolling
Protecting cells & ranges to stabilize models
Function wizard benefits
Linking cells from various worksheets to reduce errors
Secret keyboard shortcuts
Introduction to planning
What-if analysis:
Scenario analysis techniques
Sensitivity analysis using spinners & scroll bars
Economic Order Quantity (EOQ)
Build out Data tables to see an entire range of options
1-way Data tables
2-way Data tables
Maximizing vs. optimizing techniques
Utilizing The Goal Seek command to calculate a reverse equation
Using Solver to calculate optimal product mix, distribution problems & capital budgeting
What is forecasting?
Qualitative techniques & their uses
Quantitative techniques & their uses
Smoothing techniques
Regression analysis
Time series analysis
Forecasting growth rates for verification
Internal (IGR)
Sustainable (SGR)
MIN and MAX functions
MEDIAN, MODE & AVERAGE functions
GEOMEAN to calculate Average Growth Rate (AGR)
When to use RANK, QUARTILE & PERCENTILE
What is a budget?
How to build a simple budget
Build a Flexible Budget Model
Build out a complete budget
Operating budget elements
Financial budget elements
Linking them
What is the Variance Analysis report & why is it important to improve your budget
Calculating variance analysis to see what must be changed
We all operate in an increasingly complex commercial and professional environment that requires us to negotiate on a daily basis not only with customers, clients, suppliers and contractor, but also with managers, fellow employees and colleagues within our own organisation.
‘Mastering Negotiation Skills’ is a five-day course designed to explain the negotiation process in detail and demonstrate how to use it effectively, giving delegates the negotiation skills and strategies they need to succeed in today’s challenging commercial environment.
The ability to negotiate effectively and manage conflict is one of the most valuable skill sets we can develop within our organization. Not only does developing these skills allow us to negotiate better deals by creating and then claiming value, but it also enables us to manage teams more expertly, interact more constructively with colleagues and manage conflict effectively.
This course provides both a comprehensive strategic analysis of the negotiation process as well as the essential tools for planning and managing every negotiation. Delegates will learn to negotiate excellent outcomes both externally with suppliers, contractors, and customers but also internally within your organization between colleagues, departments, and managers.
One of the major keys to success in the business world is being able to apply “discipline” to your life and actions! This is the key to developing personal effectiveness and professional excellence.
This training course will provide professionals with the knowledge, skills, and attitudes required to manage and lead teams and organizations before, during, and after a crisis or emergency. All leaders are sooner or later confronted with the need to lead and manage their team or organization during a crisis or emergency. The leadership skills and competencies that are required in these demanding circumstances are much more challenging for the leader than normal everyday leadership. This course will also cover the basics of the COVID 19 Virus currently impacting the world. Most of our lives are a combination of work, family, and community involvement. A pandemic can affect all of these areas. Being informed and knowing what to do during a pandemic can help minimize the impact.
This course is designed for IT professionals who are looking to take on the role of Chief Information Security Officer (CISO) in an organization. The course will cover key concepts and skills in information security, including risk management, security governance, incident response, and compliance.
A five-day course on the practical aspects of piping and pipeline design, integrity, maintenance, and repair. The participants will obtain an in-depth understanding of the ASME B31 code rules and API standards, their technical basis, and practical application to field conditions.