Programme Listings - Information Technology  View Month : - Select - September October November December Print

The following is a list of programmes   CODE IT005 Performance Dashboards & Analysis With Excel 2007 (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) This course will enhance and supplement analysis and reporting using Microsoft Excel and how to speed up and improve the information retrieval process using open database connectivity (ODBC). Using PivotTables, charts, and PivotCharts, coupled with ODBC, necessary to get the information from your financial and operational systems. Leader   Dr. Lim Thou Tin, DBA, MKM, MInfSys, DipSA, DipIntelligentSys Duration   2.0 days (14.00 ICPAS CPE hours) Date  01 Nov 2010, 02 Nov 2010 Time 9:00 AM - 5:00 PM Fee Members $609.90 Non-members $716.90 View programme details   CODE IT008 Advanced Excel Spreadsheet Skills (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) It has been said that the 95/5 rule applies in the Excel spreadsheet world. 95% of the users used only 5% of its power. Most users realized that they could further harness the power of Excel if they could have a better handle of its structure, formulas and functions. This is much complicated by the incomprehensive jargon and procedures. Leader   Dr. Lim Thou Tin, DBA, MKM, MInfSys, DipSA, DipIntelligentSys Duration   2.0 days (14.00 ICPAS CPE hours) Date  08 Feb 2010, 09 Feb 2010 22 Mar 2010, 23 Mar 2010 19 Apr 2010, 20 Apr 2010 17 May 2010, 18 May 2010 08 Jul 2010, 09 Jul 2010 19 Aug 2010, 20 Aug 2010 16 Sep 2010, 17 Sep 2010 07 Oct 2010, 08 Oct 2010 11 Nov 2010, 12 Nov 2010 09 Dec 2010, 10 Dec 2010 Time 9:00 AM - 5:00 PM Fee Members $609.90 Non-members $716.90 View programme details   CODE IT004 VBA for Accountants (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) The objective of this programme is not to learn programming. It provide you with the commonly used VBA modules, pre-built by fellow accountants and Microsoft. Understanding these modules and how to combine the various modules in an orderly manner will enable you to develop solutions to meet your exacting needs. Leader   Duration   2.0 days (14.00 ICPAS CPE hours) Date  13 May 2010, 14 May 2010 01 Jul 2010, 02 Jul 2010 20 Sep 2010, 21 Sep 2010 Time 9:00 AM - 5:00 PM Fee Members $1,177.00 Non-members $1,391.00 View programme details   CODE IT030 Excel Macro Fundamentals (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) There is little dispute that Excel is one of the main tools in the accountants’ toolbox, and yet many are self taught in its features. It is natural for some to feel comfortable with the basics, and to keep away from the more perplexing black art of trying a hand in writing macros. Leader   Dr. Lim Thou Tin, DBA, MKM, MInfSys, DipSA, DipIntelligentSys Duration   2.0 days (14.00 ICPAS CPE hours) Date  04 Mar 2010, 05 Mar 2010 20 May 2010, 21 May 2010 22 Jul 2010, 23 Jul 2010 23 Sep 2010, 24 Sep 2010 25 Nov 2010, 26 Nov 2010 Time 9:00 AM - 5:00 PM Fee Members $609.90 Non-members $716.90 View programme details   CODE XBRL2010A Preparation and Management of Financial Statements in XBRL format (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) FS Manager is a free online tool provided by ACRA for the preparation of financial statements. Singapore incorporated companies which are either unlimited or limited by shares will be required to file their financial statements in XBRL with effect from 1 November 2007. Leader   Christy Chung, CPA Singapore Duration   1.0 day (7.00 ICPAS CPE hours) Date  11 Oct 2010 Time 9:00 AM - 5:00 PM Fee Members $267.50 Non-members $321.00 View programme details   CODE IT069 Excel Budgeting Techniques (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) In any organization the budget is a central aspect of the planning and control systems utilized by the organization. Regardless of the organization’s size or complexity, or the product, the market or the service provided by the enterprise, a budget will always feature as a key aspect of financial planning. Leader   Dr. Lim Thou Tin, DBA, MKM, MInfSys, DipSA, DipIntelligentSys Duration   2.0 days (14.00 ICPAS CPE hours) Date  15 Mar 2010, 16 Mar 2010 13 May 2010, 14 May 2010 02 Aug 2010, 03 Aug 2010 14 Oct 2010, 15 Oct 2010 Time 9:00 AM - 5:00 PM Fee Members $609.90 Non-members $716.90 View programme details   CODE IT011 Power Design For Presentations (Category as per Public Accountants' Competency Map: C6) To design Microsoft PowerPoint presentation slides in a way to allow people to visually capture and digest information more effectively, thereby boosting the presenter in driving his message across to the audience. Leader   Kelvin Lee, Certified Microsoft PowerPoint specialist Duration   2.0 days (14.00 ICPAS CPE hours) Date  19 Oct 2010, 20 Oct 2010 14 Dec 2010, 15 Dec 2010 Time 9:00 AM - 5:00 PM Fee Members $609.90 Non-members $716.90 View programme details   CODE IT021 Financial Data Management with Pivot Tables (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) Pivot table is one of the most powerful features of Excel, yet few accountants use them in their day-to-day activities. For some, pivot tables are too intimidating and for others, pivot tables are unknown. With a little instruction and guidance, you will be using pivot tables to accomplish routine analysis and reporting. Leader   Dr. Lim Thou Tin, DBA, MKM, MInfSys, DipSA, DipIntelligentSys Duration   1.0 day (7.00 ICPAS CPE hours) Date  01 Apr 2010 14 Jun 2010 12 Aug 2010 21 Oct 2010 Time 9:00 AM - 5:00 PM Fee Members $299.60 Non-members $395.90 View programme details   CODE XBRL2010 XBRL Reporting 2010 (Category as per Public Accountants' Competency Map: B2) Approved for SDF funding for SMEs (eligibility criteria apply) FS Manager is a free online tool provided by ACRA for the preparation of financial statements. Singapore incorporated companies which are either unlimited or limited by shares will be required to file their financial statements in XBRL with effect from 1 November 2007. Leader   Daniel Chee, FCPA Singapore Duration   1.0 day (7.00 ICPAS CPE hours) Date  05 Feb 2010 12 Apr 2010 28 Jun 2010 Time 9:00 AM - 5:00 PM Fee Members $267.50 Non-members $321.00 View programme details   CODE IT010 Data Mining & Business Analytics – An Overview (Category as per Public Accountants' Competency Map: B2) To provide an overview and introduction to the issues related to data mining and its applications; and to provide a platform for questions on this subject to be raised during a Q & A session. Leader   Prof Koh Hian Chye, FCCA, FCPA Duration   0.5 day (2.00 ICPAS CPE hours) Date  25 Jun 2010 Time 9:30 AM - 12:00 PM Fee Members $609.90 Non-members $716.90 View programme details