ITE's mission is to provide IT Training for Accountants and Analysts that:
- is the most relevant
- is the best available
- is inspiring
- leads to business intelligence
Know how is at the heart of working quicker and smarter.
Available courses
i) Excel Fundamentals
This course is suitable for a novice. It is aimed at administrative and accounting staff that have some PC skills and would benefit from a formal Excel training session to equip them to advance an intermediate skill level.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Open, create, print, save
- Spreadsheet Navigation
- Enter / Edit Data
- Basic Formulas
- Formatting
- Manipulation
ii) Excel Excellence For Accountants
A practical hands-on workshop for accountants designed to provide a specialised insight into Excel's programming capabilities, and the approach for applying those to a broad range of accounting applications. Improve your efficiency by doing this cost effective training, designed for accountants by an accountant.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Rolling Reports
- Vlookup
- Advanced Functions
- Sum If and Count If
- Subtotals and Filters
- Pivot Tables
- Connecting to databases
- Macro introduction
iii) Advanced Charting
Excel has extensive charting capabilities, most of which remain unknown to the majority of users. Find out what can be done without figuring out the hard way by trial and error.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Some formatting and display tips
- Custom & User Defined Chart Types
- Interactive Charting Techniques
- VBA - for ultimate charting flexibility
iv) Macros = Excel VBA
Most Intermediate users are familiar with the Macro recorder in Excel, but this is just the tip of the iceberg!
Find out what lies behind the program beyond the simple record Macro function.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Variables and Variable Types
- Terminology
- Tools
- Loops
- Procedures
v) Access for Accountants
A comprehensive training in the relevant use of Access for Data Analysis purposes.
The essence of this course is linking to servers, showing you how you can tap directly into your company data bases. Then build queries to manipulate and summarise the data sets and how to feed this information into Excel.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Access Tables
- Access Queries
- Access Forms
- Access Macros
- Access Objects
vi) Demystify Business Intelligence
'The term Business Intelligence (BI) represents the tools and systems that play a key role in the strategic planning process of the corporation. These systems allow a company to gather, store, access and analyse corporate data to aid in decision-making.' www.bkdai.com.
Register Online or call 09 - 3684844
At the end of the course, participants should be familiar with:
- Business Intelligence Architecture and terminology
- Reporting Vs Budgeting Tools
- Comparative Overview of Access vs SQL Server
- Understanding queries
- Extract Transform Load process in SQL Server Integration Services
- Building Cubes in Analysis Services
- Online reporting - Reporting Services and SharePoint Server