Information Technology
Microsoft Office Course Schedule
January & February 2017 | The Dynamics to Excel DAY
JAN 2017
FEB 2017
FEES (RM) NONMEMBER
MEMBER
13 20 20 14-15 27-28 20 27 14-15 21-22 27-28 13 -
212.00 233.20 424.00 477.00 212.00 233.20 424.00 530.00 901.00 530.00 477.00 424.00 477.00 212.00 233.20 424.00 530.00 901.00 530.00 477.00 212.00 233.20
180.20 201.40 371.00 424.00 180.20 201.40 371.00 434.60 795.00 424.00 424.00 371.00 424.00 180.20 201.40 371.00 434.60 795.00 424.00 424.00 180.20 201.40
16-17 23-24 14-15 21-22 21-22 23-24 -
424.00 477.00 424.00 477.00 424.00 477.00 424.00 477.00
371.00 424.00 371.00 424.00 371.00 424.00 371.00 424.00
MICROSOFT OFFICE 2007/2010/2013/2016 COURSES
Automate Financial Consolidation with Microsoft Excel 2007 Financial Consolidation entails combining multiple divisions/subsidiaries with varying accounting practices and procedures. All these push for a need of a more effective use of accounting applications and spreadsheet in managing this task. In this course, you will learn the hands-on step by step approach on how to design a flexible and dynamic Excel-based consolidation process, streamline data collection process, translate foreign currencies, manage consolidation adjustments which ultimately automate the routine and tedious work in performing group accounts all at a click of a few buttons. Automating Financial Reports with Microsoft Excel 2007 Finance department faces intense pressures and compliance to regulatory requirements. The process of preparing financial reports and analysis can be daunting, e.g. coming up with quarterly statement may take-up much resources and an analyst may require much time in entering, validating and verifying data. Microsoft Excel’s ability to help automate the way data is captured, shared, reported and analysed can be astounding. This training presents to participants the many Microsoft Excel reporting functions that will expedite and allow information to be automatically pulled into financial reports and statements. Interactive Visual Reporting and Analysis with Microsoft Excel 2007/2010/2013 Data Visualisation is increasingly becoming an essential need in enhancing business decisions. This course brings users to the forefront on the technology of data visual display to enhance reporting, analysis and performance management. With visual analytics, users can spot business issues and problems needing attention at a glance and take action on a timely manner. Microsoft Excel is an ideal tool in putting all these data together, making meaning out of it and displaying the analysis easily in an interactive dashboard form. Manipulating Data Effectively with Microsoft Excel 2010 These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way can not only help you save time, but it will also help you become better at your job and can give you time to focus on things and people that matter. This is an ideal course for users who desires to manage data, sort and filter, analyse data, and learn to automate some common Excel tasks. PowerPivot: Powerful Data Analysis and Data Modelling in Microsoft Excel 2010/2013 With PowerPivot, Microsoft brings the dynamism of Business Intelligence tools to Excel, transforming enormous amount of data/records into meaningful information. It helps to generate rich and interactive analysis solutions. It is an extension to things you already know about Excel and it comes FREE with the software (Excel 2010 and above). Kindly contact us for the course content of other programmes.
Microsoft PowerPoint 2007 (Fundamental & Intermediate) Microsoft PowerPoint 2007 (Advanced) Microsoft Word 2010 (Fundamental & Intermediate) Microsoft Word 2010 (Advanced) Microsoft PowerPoint 2010 (Fundamental & Intermediate) Microsoft PowerPoint 2010 (Advanced) Microsoft Access 2010 (Fundamental & Intermediate) Microsoft Access 2010 (Advanced) Microsoft Project 2010 (Fundamental & Intermediate) Microsoft Visio 2010 Microsoft Publisher 2010 Microsoft Word 2013 (Fundamental & Intermediate) Microsoft Word 2013 (Advanced) Microsoft PowerPoint 2013 (Fundamental & Intermediate) Microsoft PowerPoint 2013 (Advanced) Microsoft Access 2013 (Fundamental & Intermediate) Microsoft Access 2013 (Advanced) Microsoft Project 2013 (Fundamental & Intermediate) Microsoft Visio 2013 Microsoft Publisher 2013 Microsoft PowerPoint 2016 (Fundamental & Intermediate) Microsoft PowerPoint 2016 (Advanced)
1 1 2 2 1 1 2 2 2 1 1 2 2 1 1 2 2 2 1 1 1 1
16 23 10-11 19-20 4 16 12-13 17-18 19-20 9 4 19 20
CORE MICROSOFT EXCEL COURSES MICROSOFT EXCEL 2007/2010/2013/2016 COURSES
Microsoft Excel 2007 Essential Skills (recommended for Basic user) Manipulating Data Effectively with Microsoft Excel 2007 Microsoft Excel 2010 Essential Skills (recommended for Basic user) Manipulating Data Effectively with Microsoft Excel 2010 Microsoft Excel 2013 Essential Skills (recommended for Basic user) Manipulating Data Effectively with Microsoft Excel 2013 Microsoft Excel 2016 Essential Skills (recommended for Basic user) Manipulating Data Effectively with Microsoft Excel 2016
2 2 2 2 2 2 2 2
5-6 12-13 12-13 19-20 10-11 17-18 17-18 23-24
HIGH END MICROSOFT EXCEL COURSES MICROSOFT OFFICE 2003/2007/2010/2013/2016 COURSES
Tasks Automation with Microsoft Excel 2003/2007/2010/2013/2016 Macro / VBA (Fundamental & Intermediate) What If Analysis with Microsoft Excel 2003/2007/2010/2013/2016 Microsoft Excel Functions & Formulas 2003/2007/2010/2013/2016
2
10-11
14-15
1007.00
901.00
1 2
16 10-11
14-15
636.00 1007.00
530.00 901.00
23-24
1049.40
943.40 424.00
MICROSOFT OFFICE 2007/2010/2013/2016 COURSES
Tasks Automation with Microsoft Excel 2007/2010/2013/2016 Macro / VBA (Advanced) Data Management with Pivot Table using Microsoft Excel 2007/2010/2013/2016 Microsoft Excel 2007/2010/2013/2016 Interactive Charts Unleash the Power of Microsoft Excel 2007/2010/2013/2016 Lookup Functions Interactive Visual Reporting and Analysis with Microsoft Excel 2007/2010/2013/2016 Mastering Microsoft Excel Array Formulas 2007/2010/2013/2016
2
17-18
1
9
13
530.00
1
-
27
477.00
371.00
1
-
13
636.00
530.00
2
25-26
23-24
1378.00
1309.10
1
-
20
636.00
530.00
MICROSOFT OFFICE 2010/2013/2016 COURSES
PowerPivot : Powerful Data Analysis and Data Modeling in Microsoft Excel 2010/2013/2016
2
23-24
16-17
1908.00
1696.00
2 1
-
21-22 28
1484.00 848.00
1378.00 742.00
The underlined indicates the version used to conduct the course. FINANCIAL COURSES
Automating Financial Reports with Microsoft Excel 2007 Automate Financial Consolidation with Microsoft Excel 2007 The above programme fee is inclusive of 6% GST.
What business needs does Financial Series address? With Financial Series workshop, financial reporting and budgetary process becomes completely structured and integrated. This offers many advantages including: • Save time & effort - Generate budgets, plans and month end manage reports with greater speed and less effort; • Greater accuracy - Avoid manual linking and data entry that has high risk of errors; • Better financial control - Manage profit and cash flow effectively. Identify financial problems before they arise; • Reduce cost - No need to purchase additional specialist software. You could leverage on the power of Microsoft Excel to automate the routine financial reporting process and save time to evaluate the financial results instead. This tool will assist the Finance team to be more productive and efficient!
METHODOLOGY All programmes will be held in a computer lab for practical hands-on exercises, accompanied by group exercises.
TRAINING VENUE & CONTACT INFO Venue : PentaWise Sdn Bhd Suite 37-8, The Boulevard Mid Valley City, Lingkaran Syed Putra 59200, Kuala Lumpur Contact : Farhana Tel : 03 2722 9291 Fax : 03 2722 9009
8
CPE HOURS GAINED Per Day CLAIMABLE UNDER
HRDF THE SBL SCHEME
Claimable Institut Akauntan Malaysia
20
LIMITED PARTICIPANTS ONLY PER CLASS
PARTICIPANTS' DETAILS Participant 1 Full name as per I/C (Dato' / Datin / Dr / Mr / Mrs / Ms):
o Vegetarian Meal
Membership No.: Designation: Email: *o Member
*o Non-member *o Sponsored Staff1 (Sponsoring MIA member’s name & membership no.)
Participant 2 Full name as per I/C (Dato’ / Datin / Dr / Mr / Mrs / Ms):
o Vegetarian Meal
Membership No.: 1
Designation: Email: *o Member
*o Non-member *o Sponsored Staff1 (Sponsoring MIA member’s name & membership no.)
Participant 3 Full name as per I/C (Dato’ / Datin / Dr / Mr / Mrs / Ms):
o Vegetarian Meal
The above programme fee is inclusive of 6% GST.
Membership No.:
MIA GST Reg. No.: 000955203584
Designation: Email: *o Member
ENQUIRIES AND REGISTRATION
*o Non-member *o Sponsored Staff1 (Sponsoring MIA member’s name & membership no.)
ORGANISATION'S DETAILS Organisation: Industry:
Contact Person:
Head Office Tel : 03 2722 9000 Fax : 03 2722 9009 Email :
[email protected] Address : Malaysian Institute of Accountants Dewan Akauntan Unit 33-01, Level 33 Tower A, The Vertical Avenue 3, Bangsar South City No. 8, Jalan Kerinchi 59200 Kuala Lumpur
Address:
Email:
Tel: Fax:
TAX INVOICE to be issued under: o Company o Individual
Signature & Company Stamp:
PAYMENT DETAILS Payment by Cheque Bank & Cheque No.:
Amount RM:
Payment by Credit Card
o Visa
o Master
Cardholder's Name: Card No.:
Expiry Date:
I Authorise Payment of RM:
Cardholder's Signature:
Date:
For complete programme details, please download the full brochure(s) from: pd.mia.org.my Our programmes can be customised to meet your in-house training requirements. Please call for details.
PROGRAMME FEE • Fee is payable to MALAYSIAN INSTITUTE OF ACCOUNTANTS • Fee includes course materials and 2 tea breaks per day. • Full payment of the above amount shall be made within thirty (30) days from the date of the Payment Advice or on the day of the event, whichever earlier. • Admittance may be denied upon failure to make full payment as per the above requirement. CANCELLATION/ TRANSFER Upon registering, participant(s) are considered successfully enrolled in the event. Should participant(s) decide to cancel/ transfer their enrolment, a cancellation/ transfer policy shall be applied as follows. a) Written cancellation/ transfer received less than seven (7) days from the date of the event: - A refund (less administrative charge of 20%) will be made - Unpaid registrations will also be liable for 20% administrative charges b) Written cancellation/ no show on the day of the programme: - No refund will be entertained - Unpaid registrations will also be liable for full payment of the registration fee - Partial cancellation is not allowed You can substitute an alternate participant if you wish to avoid cancellation/ transfer charges. Any difference in fees will be charged accordingly.
IMPORTANT NOTES: Registration is on a first-come-first-served basis. Only fully completed registration form will be processed.
*Please select the participant classification carefully as it determines the fee payable. No alteration will be allowed after the registration is accepted. Terms and conditions apply. 1 The Sponsored Staff must report directly to the sponsoring MIA member in his/ her firm or company. CERTIFICATE OF ATTENDANCE AND CPE HOURS • Upon full attendance of the programme, participants will be issued an “E-certificate”. Participants will receive an email with a download link and are required to download the e-certificate within 30 days. For this purpose, it is COMPULSORY to fill in the email address clearly. • For MIA members, the CPE hours will be credited into the Membership System within 2 weeks of the event. DATA PROTECTION Personal Data is gathered in accordance with the Personal Data Protection Act 2010 (Act 709). DISCLAIMER Malaysian Institute of Accountants (MIA) reserves the right to change the speaker(s), date(s) and to cancel the programme should circumstances beyond its control arises. MIA also reserves the right to make alternative arrangements without prior notice should it be necessary to do so. Upon signing the registration form, you are deemed to have read and accepted the terms and conditions.