We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Microsoft Excel - Advanced

ENDED
Training by  ITRAININGEXPERT.com
Inquire Now
On-Site / Training

Details

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

Outline

2 days syllabus
Module 1: Advanced functions and formulas
• Logical functions
• Conditional functions
• Financial functions
• Text functions
• Date and time functions
• Array formulas
• Calculation options
 
Module 2: Lookups and data tables
• Using lookup functions
• Creating data tables
 
Module 3: Advanced data management
• Validating cell entries
• Advanced filtering
 
Module 4: Advanced charting
• Chart formatting options
• Combination charts
• Graphical objects
 
Module 5: Pivot Tables and Pivot Charts
• Working with PivotTables
• Modifying Pivot Table data
• Formatting PivotTables
• Using Pivot Charts
• PowerPivot
 
Module 6: Streamling Workflow: Macros
• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria
• Update a Workbook's Properties
• Modify Excel's Default Settings
 
Module 7: Collaborating with Others
• Protect Files
• Share a Workbook
• Set Revision Tracking
• Review Tracked Revisions
• Merge Workbooks
 
Module 8: Auditing Worksheets
• Trace Cells
• Troubleshoot Errors in Formulas
• Troubleshoot Invalid Data and Formulas
• Watch and Evaluate Formulas
• Create a Data List Outline
 
Module 9: Analyzing Data
• Create a Trendline
• Create Scenarios
• Perform What-If Analysis
• Perform Statistical Analysis with the Analysis ToolPak
• Create Sparklines
 
Module 10: Working with Multiple Workbooks
• Create a Workspace
• Consolidate Data
• Link Cells in Different Workbooks
• Edit Links
 
Module 11: Importing and Exporting Data
• Export Excel Data
• Import a Delimited Text File

Speaker/s

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: [email protected]

Special Offer

Normal fee Sign up 1 pax: Pay before course starts MYR 2,590/ USD 720
Early Bird Sign up 1 person: Pay 14 days before course starts MYR 1,990/ USD 560
Group Fee Sign up 3 pax or more: Pay 14 days before course startsMYR 1,790/ USD 500

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

Certificate
Upon successful completion of this program, you will receive a Certificate of Achievement. 
Certificates are distributed on the final day of the program.

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.

Reviews
Be the first to write a review about this course.
Write a Review

ITRAININGEXPERT GLOBAL PLT is the corporate training arm of The English Expert Publishing and Training Group established since 1999 by consulting partners with extensive training experience from both the government and corporate sector covering Malaysia, Singapore, Australia, China, Vietnam and Indonesia.

All our trainers are experienced practitioners, professionally certified, dedicated and specialized in their respective fields. Our corporate philosophy is of Total Customers Satisfaction. We carry out our task with integrity and full commitment. We continue to keep abreast with industry developments through individual and ongoing continuing education, in-depth training and consulting that your organization demands and deserves.

For 18 years now and counting, we have trained more than 100,000 people to improving their work productivity, leadership & communication skills, language proficiency, sales, negotiation & presentation skills, workplace management and personal development.

What do we SPECIALISE in?

Put it in an easy way, we specialize in Training and Human Development training and consultancy services covering both soft skills and technical skills, a wide range of courses pertinent to the human capital development of high performing organization. ...

Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.