CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, May 30, 2012 9:30:00 AM
Summary:
Course Aim: The aim of this course is to produce a rolling forecast in MS Excel (18 months is the case study used). This entails heavy automation to facilitate the re-use of the model to create updated forecasts on an ongoing basis i.e. rolling out into the future and recognizing opening historical position and financial years.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, June 13, 2012 9:30:00 AM
Summary:
Course Aim Creating, editing and formatting basic speadsheets is not enough for accountants. We need to streamline repetitive tasks and enhance our spreadsheets with templates, functions, formulae, tables and by using Excel. This course will help you to use the New and improved features that can help you be more productive, and moves participants towards advanced topics in Excel.
CPD Hours: 6
Learning Mode: Classroom based
Next available date: Thursday, June 14, 2012 9:30:00 AM
Summary:
This course is designed for Accountants who have had limited involvement in business planning on Excel and require more competence in business planning techniques so that they can maximise flexibility and business model dynamics while incorporating future needs. It enables participants to compete for support and resources with the aid of a convincing plan either internally or for their clients.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, June 14, 2012 9:30:00 AM
Summary:
Course Aim This course is intended for experienced Excel users seeking to advance their skills and find short-cuts and tips to get more from Excel. It will introduce participants to Excel’s automated techniques in both forecasting and historical analysis.
CPD Hours: 12
Learning Mode: Classroom based
Next available date: Tuesday, June 19, 2012 9:30:00 AM
Summary:
This two day course is suitable for those who have a high proficiency of Excel and knowledge of Advanced Functions.
CPD Hours: 6
Learning Mode: Classroom based
Next available date: Thursday, June 21, 2012 9:30:00 AM
Summary:
The key benefit will be the ability to use some or all of the techniques and concepts presented for forecast generation within the participant’s own organisation. The second part of the day regarding cash flow forecasting will provide a similar tool for short- term tactical cash flow forecasting purposes.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, July 11, 2012 9:30:00 AM
Summary:
Course Aim This course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others. You will learn how to use the advanced features in PivotTable and PivotChart report to Filter, sort, group, and conditionally format the relevant subset of data to enable you to focus on the information that you want.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, August 22, 2012 9:30:00 AM
Summary:
Course Aim Excel is an ideal tool for creating high-impact dashboards in businesses of all sizes. In this course, learn how to build Excel-based dashboards that extract information from your accounting application along with other databases and to present this data as actionable information in a dashboard setting.
CPD Hours: 6
Learning Mode: Classroom based
Next available date: Thursday, September 13, 2012 9:30:00 AM
Summary:
Our one day Sage Accounts course is suitable for those who wish to utilise existing reports & create ad-hoc reports that will facilitate: Drillable management accounting reporting with difference summary levels and Budget v Actuals variance reporting.
CPD Hours: 6
Learning Mode: Classroom based
Next available date: Thursday, September 20, 2012 9:30:00 AM
Summary:
Our 1 day Microsoft Excel Intermediate / Advanced course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, September 26, 2012 9:30:00 AM
Summary:
Course Aim This course is designed for Chartered Accountants who realise that creating a “To Do” list does not solve their difficulties in managing their work or freeing up time. They recognise that how they manage or participate in the greatest time thief of all – non-productive meetings – impacts on what they can achieve and how they are perceived. They require a practical, reality-based set of techniques and strategies to be more effective and less stressed.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, October 11, 2012 9:30:00 AM
Summary:
Course Aim This course will give the financial professionals the skills to use the new features in PowerPoint 2010 to create dynamic and professional presentations. They will be able to work with multiple shows, include SmartArt, visuals and videos to enhance the presentations.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, October 16, 2012 9:30:00 AM
Summary:
Course Aim This course is intended for experienced Excel users seeking to advance their skills and find short-cuts and tips to get more from Excel. It will introduce participants to Excel’s automated techniques in both forecasting and historical analysis.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, October 30, 2012 9:30:00 AM
Summary:
Course Aim This course refreshes the skills of advanced users of Excel on the basics of Macros, and then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately.
CPD Hours: 6
Learning Mode: Classroom based
Next available date: Friday, November 09, 2012 9:30:00 AM
Summary:
Course Aim Effective business planning is fundamental to success in business. This course shows how building the plan model is the first step in transforming ideas into tangible reality. It demonstrates how a well-organised plan shows if the concepts make sound business sense.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, November 28, 2012 9:30:00 AM
Summary:
Course Aim This course is designed to give accountants the skills to understand that although MS Project is not an accounting package, it does provide cost estimating and tracking for budgetary purposes. MS Project is not concerned with the costs to the company of the resources used doing anything else other than the specific project tasks. This can be frustrating for accountants and lead to them being too hands-off in using MS Project to track costs, with resultant budget overruns which may have been avoidable.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, December 05, 2012 9:30:00 AM
Summary:
Course Aim This course is designed for Course is designed for Chartered Accountants who understand that time management is a choice and that we can all improve our productivity levels. It presents a strategy to use MS Outlook to allocate and monitor tasks and effectively plan and schedule their workload.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, December 11, 2012 9:30:00 AM
Summary:
Course Aim This hands-on course will show experienced Excel users how to operate the package at a higher level and explore its more sophisticated analysis tools.
CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, December 13, 2012 9:30:00 AM
Summary:
Course Aim: The aim of this course is to produce a rolling forecast in MS Excel (18 months is the case study used). This entails heavy automation to facilitate the re-use of the model to create updated forecasts on an ongoing basis i.e. rolling out into the future and recognizing opening historical position and financial years.