Overview In this course you will learn to build a financial model by working in Excel and how to perform sensitivity analysis in Excel. You will also learn the formulas, functions and types of financial analysis to be an Excel power user. By attending this course, you will be able to effectively prepare and build financial models. Objectives Harness Excel's tools within a best practice framework Add flexibility to their models through the use of switches and flexible lookups Work efficiently with large data volumes Model debt effectively Approach modelling for tax, debt, pensions and disposals with confidence Build flexible charts and sensitivity analysis to aid the presentation of results Learn and apply Excel tools useful in financial forecasting Understand and design the layout of a flexible model Forecast financial statements of a public or private company Apply scenario analysis to the forecasted financial statements and prepare charts for data presentation
Serious about starting your own soap business? Set yourself up for success from the very beginning, in a private course with Paula Mateo, award winning founder of Old Bexley Soap & Candle Co.
Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Course Overview This dynamic online Diploma in Digital Strategy & Planning course covering topics in digital communications, analytics, marketing automation and budget & strategy formulation giving you the skills, know-how, strategy and techniques to be that change. Here is power. The power to influence. To speak to billions of people. Specialization is for when you don’t just want to play the digital marketing game anymore, you want to drive it. To change it. the DMI SPECIALIST online Digital Strategy and Planning certification is perfect for you to become an online digital marketer. Become a member and connect to the industry and white-hot opportunities. Here is power. The power to influence. To speak to billions of people. What’s New? Develop true Digital Marketing Strategy expertise with DMI Specialist. Learn digital communications, analytics, marketing automation and budget & strategy formulation from Industry Skills Experts. Learn every aspect of Digital Marketing Strategy across 9 modules of interactive learning to give you a highly relevant and deep knowledge of digital strategy, all wrapped up with the world’s most recognized digital marketing certification on completion. Program learning outcomes and content: WHAT WILL I LEARN? We give you the thinking and tools to become a leading player on the digital stage. Create powerful and dynamic digital strategy. See it manifest into real world, business-changing action. The modules are building blocks – of knowledge, of your vision, of the leading Certified Digital Marketing Specialist – Digital Strategy & Planning that is you. Here is what you need to know. Course Content: Introduction: We bring science to thought. We have created the 3i Framework which is designed to help you select the best digital strategy for your organisation and make it happen. The 3i is smart and rigorous. It’s transformative. And you shall be impressed. This module introduces this nifty piece of brainwork. Later modules expand on it. • The fundamental concepts underpinning the DMI 3i Methodology. • The how-to’s of business strategy development. • Key components in an effective digital strategy. • Strategic management, a long-sighted look at lasting, growing success Traditional Communications: In this model, we explore how the marketing classics still anchor any campaign – yet the contemporary digital campaign is a far more fantastical vessel. We look deep into how our tech is changing the consumer experience, and how we must respond. Digital Communications: We are living through extraordinary times. The opportunities are as big, sprawling and diverse as the World Wide Web. The challenge too is bigger. Markets are sophisticated and fragmented. Now, more than ever, thy most know thy consumer (and thy digital channels). Here we look at: the fundamentals of digital communications planning, improving ROI, understanding your audience. Where can they be found? How to engage them? Budgeting for your digital strategy and effective resources reviewing, measuring, and analysing your digital strategy. Digital Channels: Facebook, Linkedin, Instagram, Twitter, Snapchat and so on. They multiply and they proliferate. Yet in this great distraction and fragmentation, there is also great opportunity. This module covers: inbound and outbound strategies, cross media planning, the digital channel mix, and mobile marketing social media marketing. Content marketing that is relevant, timely and riveting the what, how and why of search engine marketing email marketing, affiliate marketing, and marketing automation display and video advertising best practice. Because we have eyes to see. Marketing Automation: Automation doesn’t beat inspiration but it sure makes a marketeer’s life easier and more exciting. Here is superpower, working quieting and perfectly under your orders, night and day. See how smart businesses are sharpening their edge with CRM software for better sales enablement, lead nurturing and way more. Budget & Resourcing: Money makes marketing go round. But value is where it’s at. This model goes deep on how to hit max ROI for any given budget. Then some consideration for that other precious resource, human talent. Explore: • Key factors to consider when planning a marketing budget. • Setting that marketing budget. • How to monitor and optimize a budget during campaign, execution. • The human element. • Recruit, train and keep top people. Big Data & Analytics: The Big Data & Analytics module will provide you with a broad understanding of Big Data, Advanced Analytics and Artificial Intelligence. You will learn the fundamental frameworks and understand how cutting-edge analytics tools are being used to help businesses succeed wildly. Digital Leadership: We are living in extraordinary times, which call for extraordinary leaders. That means you. You shall lead the transition from the remnants of traditional marketing and into the brave, new digital marketing world which you are helping to invent. And you shall lead with razor-sharp thought and strategy. You shall take your brand and your organisation to places yet undreamed of. Strategy Formulation & Plan: By now, you’ll have come a long way. You are (almost) ready to go forth, carve out new and unexplored neural pathways and digital markets. You are standing on the very edge of the leading-edge, and you are just about ready to spread those new digital super-wings and soar. But first, the ultimate strategy module; the ultimate in strategy. DURATION 8-10 Weeks WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate
Microsoft Excel is the world's most popular spreadsheet program, learning how to use the software with Osborne Training shows that you've taken one of the best Excel training courses available. A comprehensive training course with up to date material to practice at home and during your class. You will also be provided a step by step manual of all the tricks you can do using Excel spreadsheets to gain better management reporting and budgeting skills. It is a fundamental programme for professional Accountants. Excel spread sheets are the most powerful tool, extensively used for reporting and analysis. Having advanced skills on excel can excel your career and help you to stand ahead of the competitive job market. Advanced skills on excel is a must for any potential professional accountants. You will receive an attendance certificate once you complete the course successfully. Excel Course Content Creating worksheets, formatting text Simple and complex formulas Handling rows and columns Autocomplete, using styles, headers and footers, Average, max and min functions and using charts. Use of IF Formula Summing Techniques Cell References Formula Linking Sumifs Tables and Bordering Look up References (Vlookup, Hlookup,etc) Data Validation Conditional Formatting Date & Time Formulas Charts & Graphs Protection & Security Creating Pivot Table Pivot Table Analysis
Running a successful project requires skills in planning, budgeting, tracking deliverables and stakeholder management. An area that can be neglected by project managers is the 'people side' - not the project team themselves but the end-users, those who will be affected by the project. Too often there is a single line at the end of the project plan that says 'Comms and Training'. If people are going to have to work differently and learn some new processes, then there is work to be done by the project team to help them through the emotional side of the change. This session explores why it's important to bring people along when a change is being made. It will provide project teams with the skills and knowledge either to manage the people change plan themselves or to secure the right resources for their project. Understand the importance of the 'people side' of change 8 'Golden Rules' of change management - overview How to create a simple but effective change plan Adoption Benefits of good change management 1 Introduction Objectives and agenda People and projects - why is it important? The Change Curve - the emotional side of change 2 8 'Golden Rules' of change management - including... Role of the sponsor Communication Resistance to change 3 Change plan Elements of a change plan Change impact assessment Alignment with the project plan 4 Adoption Who owns the change? The vital role of the manager Feedback and action loops 5 Benefits Estimating the costs / benefits 6 Next steps Summary of key learning points Reflection on next steps 7 Close
AAT Level 4 Professional Diploma in Accounting AAT Level 4 is the highest level or final stage of the AAT Accounting qualification. This qualification provides the skills necessary for a 'Finance Officer' role including the complex management accounting tasks, general management skills, drafting financial statements and specialist learning areas. This provides you with an opportunity to become a professional member of AAT and use MAAT after your name. You are also entitled to exemptions in the UK's chartered and certified accounting qualifications. Besides, if you want to pursue your career further in University, you are entitled to exemptions for up to two years in various universities in the UK. You will be awarded âAAT Level 4 Professional Diploma in Accounting certificateâ from the Association of Accounting Technicians (AAT), once you have passed all the professional-level qualification exams and skill tests. Once you finish Level 4 you become a professional member of AAT and you may use MAAT after your name to stand out from the crowd as an officially Accredited Accountant. What you will gain? Here you'll learn how to draft financial statements for limited companies, perform complex management accounting tasks and develop your own management skills, perform tax calculation for business & individuals and other specialist learning areas. The Level 4 Professional Diploma in Accounting covers the following areas: Management Accounting: Budgeting Management Accounting: Decision and Control Financial Statements of Limited Companies Accounting Systems and Controls Business Tax Personal Tax
Masterclasses? Refreshers? Introductions? It depends what you're looking for and where you want to pitch them, but here are six tried-and-tested highly focused sessions that organisations can take individually or as a series, to help develop their teams' project management capabilities one topic at a time. Objectives for each individual session are set out below, as part of the session outlines. Taken together, as a series, however, these modules are an ideal opportunity to develop your team's levels of project management capability maturity, whether that's by introducing them to the basic principles, refreshing them on best practice, or giving them the opportunity to really drill down into a specific area of challenge in your particular operating environment. Session outlines 1 Stakeholder management Session objectives This session will help participants: Understand why stakeholders matter to projects Be able to identify and engage stakeholders Be able to categorise stakeholders by their significance 1 Key principles What does 'stakeholder' mean - in theory? What does this mean in practice? Why stakeholders matter Consequences of missing stakeholders The stakeholder management process:IdentifyAssessPlanEngage 2 Identifying stakeholders Rapid listing CPIG analysis PESTLE analysis Drawing on the knowledge and experience of others Other ways to identify stakeholders 3 Assessing stakeholders Which stakeholders are significant? Stakeholder radar Power-interest maps Power-attitude maps 4 Planning The adoption curve Dealing with obstacles Who should engage which stakeholder? How should the project's organisation be structured? How will communication happen? 5 Engaging Seven principles of stakeholder engagement 2 Requirements and prioritisation Session objectives This session will help participants: Understand how clarity of requirements contributes to project success Use different techniques for prioritising requirements Agree requirements with stakeholders Manage changes to requirements 1 Understanding and managing stakeholder needs and expectations What are 'requirements'? What is 'requirements management'? Sources of requirements - and the role of stakeholders Are stakeholders sufficiently expert to specify their needs? Do they understand the detail of what they want, or do they need help to tease that out? What do stakeholders want to achieve? Working within constraints Prioritising requirements - three techniques 2 MoSCoW prioritisation 'Must have', should have', 'could have, 'won't have this time' When to use MoSCoW 3 The Kano Model Customer satisfaction - 'attractive' and 'must-be' qualities When to use Kano 4 Value-based prioritisation Understanding risk v value Using risk v value to prioritise features and schedules 5 Agreeing requirements Perfect v 'good enough' Establishing acceptance criteria Requirements traceability Agreeing project scope 6 Changing requirements Why requirements change Why change control matters Impact on projects A formal change control process Paying for change - managing change for different types of project 3 Estimating Session objectives This session will help participants: Understand the different purposes estimates satisfy Be able to use different estimating techniques Understand how to achieve different levels of accuracy 1 Key principles What's an estimate? Informed guesswork What needs to be estimated? Costs, resources, effort, duration Tolerances Precision v accuracy 2 Estimating through the lifecycle Start Plan Do 3 Early estimates Comparative ('analogous') estimating Parametric estimating Using multiple estimating techniques 4 Bottom-up estimating Bottom-up ('analytical') estimating Pros Cons 5 Three-point estimating Three-point ('PERT': Programme Evaluation and Review Technique) estimating Uncertainty and the range of estimates Calculating a weighted average Three-point with bottom-up 4 Scheduling Session objectives This session will help participants: Understand how to create a viable schedule Be able to use different forms of schedule Understand the concept of the critical path 1 Key principles The planning horizon Rolling wave planning Release planning 2 Viable scheduling Creating a viable schedule Define the scope Sequence the work Identify the risks and build in mitigations Identify the resources Estimate the effort and durations Check resource availability Refine until a workable schedule is produced 3 Critical path analysis The critical path Network diagrams Sequence logic Practical application:Network diagram with estimated durationsThe 'forward pass'The 'backward pass'Calculating total floatIdentifying the critical pathCalculating free float Gantt charts 5 Risk and issue management Session objectives This session will help participants: Understand the difference between risks and issues Be able to identify and assess risks Understand ways of mitigating risks Manage issues 1 Key principles Understanding risk Threats and opportunities The risk management processPreparation - proactive risk managementThe process - identify, assess, plan, implementStakeholder communication Roles and responsibilities Risk management strategy The risk register Risk appetite 2 Risk identification Brainstorming Interviews Assumption analysis Checklists 3 Risk assessment and prioritisation Probability, impact and proximity Triggers Qualitative risk assessment Qualitative impact assessment Qualitative probability assessment Probability / impact grid Bubble charts Risk tolerance 4 Planning countermeasures To mitigate or not to mitigate? Categories of risk response Avoid and exploit Reduce and enhance Transfer Share Accept Contingency Secondary risks 5 Issue management What is an issue? Tolerances Issues and tolerances The PRINCE2 view of issues Ownership of issues An issue management process Issue register 6 Budgeting and cost control Session objectives This session will help participants: Understand what to include in a budget - and why Choose - and use - the appropriate estimating technique Align the budget with the schedule Understand how to monitor spend and control costs Trouble-shoot effectively to get projects back within budget Session format Flexible. The session can be tailored to the participants' average level of project management maturity - a 60-minute session (delivered virtually) is an effective introduction. A 90-minute session allows for more in-depth treatment. A half-day session (face-to-face or virtual) gives time for a more challenging workshop, particularly to discuss specific cost control issues with any of the participants' current projects. 1 Where is the money coming from? Can we pay from revenue? Do we need to borrow? How long will the project take to pay back? The lifecycle of the budget Through-life costs Stakeholder involvement 2 Estimating costs Reminder: the relationship between estimates Reminder: possible estimating techniques What do we need to estimate?PeopleEquipmentMaterialsFacilities and operating costsWork package estimateEstimated project costs Estimating agile projects 3 Aligning budget and schedule Scheduling and financial periods Spreading the budget 4 Reserves and agreeing the budget Contingency reserve Management reserve Agreeing the budget 5 Cost control Planned spend over time Actual spend over time Work completed over time Evaluating different scenarios: delivery v spend 6 Trouble-shooting Why are we where we are? What has caused the project to spend at the rate it is? Why is it delivering at the rate it is? What are the root causes? What can we do about it?
This course will move a manager’s focus away from simply reviewing last year’s financial performance, toward the development of an interactive approach, designed to really understand financial performance and the consequence of inaction. PARTICIPANTS WILL LEARN HOW TO: • The confidence to use budgeting tools and techniques • An understanding of the demands of financial management • The ability to analyse and challenge financial and accounting • Information • An understanding of fixed and variable costs and how these affect the sales price and profitability • Understanding the challenges of overhead allocation • Understanding the P&L • Developing awareness of fundamental investment appraisal techniques COURSE TOPICS INCLUDE: • Budget Definitions & Planning • Designing and developing a budget • Performance reporting systems & cost control • Zero-based budgeting systems • Understanding business costs (FC & VC) • Understanding variance analysis • Profit and Loss & Balance Sheet
Learn how to plan your home renovation project successfully in just 3 weeks with our evening course !
Understanding how to plan for capacity, be able to forecast and manage budgets is a critical skill in today's leadership and management environment. This programme will not only support your understanding but will also help you to practically put the learning into practice.