Microsoft Excel has proven to be an essential tool in today's fast-paced, technical business environment world, accurate accounting, and calculations can mean the difference between success and failure.
This 2-day Excel: Intermediate training program is a follow up to our Excel Basic course with greater emphasis on data management skills and the features required for it.
This Microsoft Excel training for Intermediate Level is best suited for people who are already familiar with Excel 's basic functions and need to get more out of the software on a daily basis.
Upon completion of this course, you will have a good overview of more advanced Excel functions.
Clerks, operations personnel, security personnel, customer officers, front and backend staff who already have some foundation in Excel.
AGENDA
DAY 1: 9:00am - 5:00pm
9:00 - 10:30am
Module 1 : Main Excel objects
Module 2 : Worksheets & workbooks
Module 3 : Formulas
10:30- 11:00AM TEABREAK
11:00AM - 1:00PM
Module 4 : Insert functions
Module 5 : Formula references
Module 6 : Important Excel functions
1:00- 2:00PM LUNCH
2:00- 3:30PM
Module 7 : Important excel aspects
Module 8 : Rows & columns
Module 9 : Finding & replacing data
3:30PM - 4:00PM TEABREAK
4:00PM - 5:00PM
Module 10 : Excel fonts
Module 11: Drawing borders & coloring cells
End of Day 1
Day 2: 9:00am - 5:00pm
9:00AM - 10:30AM
Module 12 : Apply number formats
Module 13: Cell alignment & cell styles
10:30 - 11:00AM TEABREAK
11:00AM - 1:00PM
Module 14 : Printing excel worksheets
Module 15 : Page layout & other print options
Module 16 : Worksheet tabs
1:00PM -2:00PM LUNCH
2:00PM - 3:30PM
Module 17 : Worksheet views
Module 18 : Formula Auditing
Module 19 : Sorting & Filtering
3:30PM - 4:00PM TEABREAK
4:00 - 5:00PM
Module 20 : Data Tools
Module 21 : Introduction to Excel charts
END OF DAY 2
This is an activity-based workshop to cover Excel features and commands to jump start productivity for existing Excel users. Laptops required.
VINCENT CHIN YUEN CHOON
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer
Vincent has held financial, continuous improvement, and I.T. positions in the banking, shared services and hospitality industries. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist, and HRD Corp accredited trainer.
His previous roles include being an internal change consultant of a global team, a financial shared-services local head, and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA, and process improvement.
Vincent brings to you his 20+ years of work and training experience in multiple industries where he was in charge of financial and business reengineering functions.
He also develops complex VBA applications regularly in process improvement projects which require his expertise.
One of his highest achievements in the role of Financial Controller for several multinational conglomerates was being able to turn a loss-making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank
Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, and HSBC.
Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations.
To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707, email to info@itrainingexpert.com
Or
We have a faculty of specialists that can cater to your organisation's different levels and specific needs.
For training and advisory services, feel free to contact us at info@itrainingexpert.com or call us at +603 8082 3707 | +603 8074 9056 | +6012 6869 628 | +6018 2175 123
“I have learned a lot of knowledge from this course, Excel (Intermediate level). Both the training and the trainer are equally good. I would like to join other Microsoft Office course.”– Secretary, NUR Power Sdn Bhd
“Before attending the course, I felt ready to learn & improve my Excel skills. In the program I learned many methods to work on data in Excel. After the course, I feel I have improved some excel skills. The trainer went above & beyond and share a lot. His training is also easy to understand & very clear.” – Intan Diana, Science officer, ISTIC-UNESCO.
“I felt that I lacked the necessary skills to utilize Excel efficiently. During the course, I learned a lot of different excel functions that could help me in at work. After the 2 days training, I feel like an Excel master. The trainer was very engaging. He answered all my questions and explained them very well.”- Ahmad Safuan, Science officer, ISC ROAP.
“I didn’t have too much knowledge about Excel and its functions. By showing up in the 2 days Microsoft Excel course, I feel gained knowledge & discover many things in this application. The trainer was good at explaining.”- Zarmila Salmi, Admin & Finance officer, ISTIC-UNESCO.
| Normal Fee | Early Bird | Group Fee |
|---|---|---|
| Sign up 1 pax | Sign up 1 pax | Sign up 3 pax or more |
| Pay 1 day(s) before course starts | Pay 14 day(s) before course starts | Pay 14 day(s) before course starts |
| MYR 2590 per pax | MYR 1990 per pax | MYR 1790 per pax |
| USD 760 per pax | USD 580 per pax | USD 550 per pax |
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 Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.
3. HRD Corp Claimable Courses Skim Bantuan Latihan Khas - Applicable to Malaysian Employer Only
We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com
Build on your Excel skills with our advanced train...
This is an in-depth 2-day course covering the impo...
This is an advanced Excel course, covering Excel t...
