Microsoft Excel- Advanced

This highly practical Microsoft Excel; Advanced training prepares you to take up business analysts roles and this Advanced Excel 2010 course increases one's  productivity and improve efficiency by streamlining the workflow

• compute and calculate with advanced functions and formulas
• organize worksheet and table data using multiple techniques
• create and modify charts and graphs.
• analyze data using Pivot Tables and Pivot Charts
• insert graphic objects for clear illustration in reports and proposal
• collaborate with others using workbooks
• audit worksheets
• analyze data.
• Work with multiple worksheets and workbooks
• Import and export data in Excel

Anyone who would like to learn more about Microsoft Excel and those who need the advanced features for work and business and financial analysis.


Prerequisites

Participants should understand the basics of Windows Operating System. They should already have at least 1-year experience working with Excel such as using SUM, COUNT.

They should understand difference between cell A1, cell A$1 and cell $A1.

This is an activity-based workshop to cover advanced Excel features and commands to jump start productivity for existing Excel users.

Mr C.T. Tai accumulated 18 years of corporate and training experience as a result of his career as a Computer Programmer, Software Architect, SAP Consultant, Project Manager and PMO Manager. His passion for Microsoft Excel training sparked from his experience in delivering training to his team of consultants.

Mr Tai had vast of experiences in Microsoft Excel corporate training, which covering multi-national businesses, local businesses, and non-profit organizations. He has trained corporations including Petronas, AirAsia, Maxis, Red Bull, Intel, CISCO, Freescale, Schneider Electric Industries, Gutor Electronic Asia Pacific, CHEP, Coppertech, LKC Group, QEL Group, C & J Clark, Worldtech Solutions. Brandt Malaisie, United Nations Development Programme, Ministry of Health Malaysia.

He is a Microsoft Certified Excel Expert, MBA holder, certified PSMB Trainer and PRINCE2 Practitioner. He commands well in English, Bahasa Melayu and Mandarin. He designed and delivered various Microsoft Excel training, ranging from regular usage to advanced usage, from Macro/VBA programming to data analytic with PivotTable/ PowerPivot.

On a personal level, he is a strong believer of continual improvement is a journey of self-learning. In his classes, he guides the participants on forming their own solutions. He did not attend any formal classes on Microsoft Excel, however he acquired the skills and knowledge as a Certified Excel Expert via self-learning. He is a living proof of continual improvement.

Mr Tai is also a highly sought after Microsoft Excel Trainer. He received regular feedback from his participants for being inspiring in his nature. He relates his trainings and teaching with the practical side of the corporate world. He is known as a trainer and teacher who instil the essence of learning.

To contact Tai, please call +6012 6869628 or +603 8074 9056 or email: info@itrainingexpert.com

(Fee inclusive of GST, Buffet Lunch, Refreshment, Welcome Pack, Training Materials Certificate of Achievement)

Payment mode:

1. ONLINE PAYMENT  by Credit card:  You can opt to register and pay online with our latest payment integration system through our website.

2. BANK IN CHEQUE
Bank in and then scan the Bank-in slip and email to us before the course commence to confirm your seat.
Courier your cheque payment to our Finance HQ.
*Note that we DO NOT take any payments during the event.

3. BANK IN CASH: You can also pay by cash through bank-in our company bank account.

4. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.