IT Courses


Excel 2013 Advanced 2017

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, March 23, 2017 9:30:00 AM

Summary:
This course will extend your knowledge into some of the more specialized and advanced capabilities of Excel by applying advanced analysis techniques to What-If analysis and Scenario planning. You will learn how to use the advanced features in PivotTables and Power Pivots for analysis of large data sets.

Project management essentials for accountants (NEW)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, March 23, 2017 9:30:00 AM

Summary:
Many accountants are thrust into a Project Management role or are doing their current job, but also completing the Project Management function for their business. Others may find themselves unable to control, influence or interface with their teams and projects due to a lack of basic project management knowledge. This course will provide accountants with an understanding of Project Management and will supply them with tools and techniques they can use to plan the scope and timeline required for their projects.

Sage Accounts Report Writing (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, April 04, 2017 9:30:00 AM

Summary:
This course is aimed at utilising existing reports & create ad-hoc reports that will facilitate: Drillable management accounting reporting with difference summary levels. Budget v Actuals variance reporting

Intermediate Excel 2007-2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, April 06, 2017 9:30:00 AM

Summary:
Our 1 day Microsoft Excel Intermediate course is suitable for those with a sound working knowledge of Excel who wish to progress to the more complicated functions and features.

Financial Modelling with Excel 2007-2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, April 12, 2017 9:30:00 AM

Summary:
The aim of this course is to design & structure spreadsheets, use  pivot tables to enhance the functionality of your spreadsheet model, a pply scenario techniques to determine alternatives and constraints in your financial model.

Data Analysis with Excel 2013 (ROI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, April 20, 2017 9:30:00 AM

Summary:
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.

Rolling Forecasts with Excel 2007-2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, April 25, 2017 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.

Advanced Excel 2007- 2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, April 26, 2017 9:30:00 AM

Summary:
At the end of this course you will have a complete understanding of the higher functions of Excel.You will be able to perform the most advanced calculations and functions, manipulate data using pivottables and ‘advanced’ analysis, record macros and integrate with other office applications.

Business Plan Modelling using Excel 2007-2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, May 09, 2017 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.

PowerPivot with Excel 2007-2013 (NI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, May 18, 2017 9:30:00 AM

Summary:
PowerPivot is an add-in for Microsoft Excel 2010/2013 that enables you to import millions of rows of data frommultiple data sources into a single Excel workbook, create relationships between heterogeneous data, createcalculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analysethe data so that you can make timely business decisions without requiring IT assistance.

Excel - Macros from A-Z with VBA 2013

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, May 24, 2017 9:30:00 AM

Summary:
This course refreshes the skills of Advanced users of Excel on the basics of Macros, then builds on the knowledge of participants to enable them to create, vet and edit Macros effectively and accurately using VBA.

Business Plan Modelling Using Excel 2013 (ROI)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, May 25, 2017 9:30:00 AM

Summary:
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.

Rolling Forecast using Excel 2013

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, June 07, 2017 9:30:00 AM

Summary:
The aim of this course is to produce a rolling forecast in MS Excel (18 months). This entails heavy automation to facilitate the re-use of the model to create updated forecasts on an ongoing basis. This involves rolling out into the future and recognising opening historical position and financial years.

Automating Analysis with Advanced Features of Excel 2013

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, June 08, 2017 9:30:00 AM

Summary:
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.

Data Visualisation with Excel and Powerpoint For Accountants

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Tuesday, June 20, 2017 9:30:00 AM

Summary:
This course is designed for people who present technical or financial information using a combination of MS Excel and MS PowerPoint. It will cover a wide range of tools and techniques such as quick features in Excel, charts, conditional formatting, pivot table/charts and dashboards. It will challenge the way we present information and seek to create new insights into how we can get our audience to understand and interpret information more effectively.

Dashboard Reporting with Excel 2013

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, June 21, 2017 9:30:00 AM

Summary:
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.

Power Pivot for Excel 2013

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, June 22, 2017 9:30:00 AM

Summary:
This course is for participants with a sound working knowledge of Microsoft Excel, particularly those who will be using Excel to make business decisions.

Power BI desktop introduction - Next step Beyond Excel (NEW)

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Friday, June 23, 2017 9:30:00 AM

Summary:
Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources. This course provides a solid introduction to using Power BI Desktop to connect to data, create visualisations, query the data and publish reports.

Excel 2013 Intermediate 2017

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, July 12, 2017 9:30:00 AM

Summary:
This course focuses on the need to produce real time reports using Charts and Pivot Tables. It introduces some techniques using functions and Named ranges that will help you help you be more productive

Powerpoint 2013 - Intermediate to Advanced

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Thursday, October 12, 2017 9:30:00 AM

Summary:
This course will give the financial professionals the skills to use the new features in PowerPoint 2013 to create dynamic and professional presentations. They will be able to include SmartArt, visuals and tables to enhance the presentations.

CPD Blitz 2017

CPD Hours: 7
Learning Mode: Classroom based
Next available date: Wednesday, November 22, 2017 9:30:00 AM

Summary:
Content to follow

IT Courses

Site Login

Login:  
 


CPD & Events Calendar