Virtual: Zoom (Learn more)
In-Class (Bring your own laptop)
You can also register by:
Learners who have completed our Microsoft Excel 2019 Basic to Intermediate course or for users with good working knowledge and experience in using Microsoft Excel. This course is suitable for leaners of Microsoft Office 2016.
Must read Things You Would Need to ensure you are properly equiped for this course.
Many jobs today requires the know-how of advanced Excel skills. Quickly diminishing are the days where only basic Excel skills will suffice in today’s job environment. You need to equip yourself beyond simple data entry and formulas in Microsoft Excel.
This 2-day hands-on guided course will enable you to equip yourself with the needed Excel skills to stay competent and more relevant in today’s context. Learn how to write advanced excel formulas for better reports and analysis. Understand auditing and debugging errors in formulas, and combine formulas with conditional formatting to highlight data meaningfully. A good understanding of Excel features like templates, tables and how to establish relationship between tables to create impressive workbooks for reporting is a must have.
Master some of the advanced pivot table features like data model to integrate data from multiple tables, with grouping, slicers and timeline to analyse massive amounts of data with just a few clicks. Equip yourself with the power of database tools, consolidation of data from different worksheets, validation of data, analysing data with Sparkline and the what-if Analysis tools. Knowing how to automate tasks in Excel through macro recording will save you much time. Learning all these Excel features will improve your proficiency, accuracy and productivity to another level.
You will also get a peek into the timesaver Quick Analysis tools, New Templates and Smart Lookup features. You will be given work exercises to enforce your understanding and familiarity of Excel’s ability to apply effectively in your work.
Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng
Qualified and Experienced to facilitate this course
Additional Dates: If the dates listed are not suitable for you and you have a group interested in the same course, you can contact us to arrange a date of your choice, subject to our trainer availability.
Evening classes or Classes in Mandarin are also available on request. Contact us for arrangements.
Group discounts are also available. Request a quote from us.
Trainer was fantastic, able to simplify the difficult concepts and give suggestions on how we can use them in our daily work.
- Ng Hui Ling (SCORE)
Appreciate the Trainer's effort and patience to guide me through the lessons. Thanks for preparing the exercises which are very useful.
- Daryl Lee (Lakeside Family Services)
Pauline is very methodical. She taught the steps in increments that is logical for us to first learn the logic and the skill, and then easier/faster ways to do them on Excel. She is able to break down complicated Excel features into smaller learning topics that is easy to learn and apply.
- Nur Aqilah (State Courts)
The Trainer was very patient, very good.
- Lim Junjie (Clearstream Banking)
Ms Ow Yeong is very patient with all of our enquiries and will always guide us along whenever we need assistance.
- Long Pei Ling (NUS)
No Exam! Ample hands on practice to master lessons taught.
Certificate of Attendance will be given subject to 90% attendance.
Local native speaking Trainers with more than 20 years of experience.
Microsoft Excel 2019 Basic to Intermediate
Microsoft Excel 2019 Advanced
Microsoft Excel 2019 Data Cleaning for Data Analytics
Microsoft Excel 2019 Automating Data Extraction and Cleaning with Power Query
Microsoft Excel 2019 Pivot Table for Data Analysis and Analytics
Microsoft Excel 2019 Advanced Functions and Formulas
Empowering the Enduser is what we are committed to equiping our learners. We understand the challenges and expectations faced in their daily work. To help learners bridge the gap is what drives us. We believe in the common person and their will to succeed.
Select courses can be delivered in Mandarin on request basis via Zoom.