WhatsApp Us9:00am to 5:30pm (Mon-Fri) Stay Safe!

Microsoft Office Essential Advanced Excel Functions for the Workplace

Training Modes
 Virtual: Zoom (Learn more)
 In-Class (Bring your own laptop)

Course Code
7 Hours (1 Day)
Course Fee
$414.20 inclusive of GST
This Course is For
Professionals and office workers using Microsoft Excel in their work, aiming to enhance data retrieval, date manipulation, and text handling skills for increased efficiency in the workplace.

Preferred Date

You can also register by:

  1. Form: Click here to download. Email back to us.
  2. Ministries on HRP / ACE: Inform your Training Coordinator the Course Code, Course Date and the Training Provider is Oaks Training c/o GIL Consultancy.
    IMPORTANT NOTE: OAKS TRAINING begins with the letter O and not the symbol @ in HRP
  3. PHONE: Call +65 6423 1183.


Working knowledge of creating formulas and basic usage of Excel functions.

This course is suitable for users of Microsoft Office 2021 or 365.

Important Note
Must read Things You Would Need to ensure you are properly equiped for this course.

Unlock Your Excel Potential and Excel in the Workplace!

Are you tired of grappling with complex data retrieval, date manipulation, and text handling tasks in Excel? Don't let confusion and intimidation hold you back – we have the perfect solution for you!

In today's fast-paced work environment, Excel proficiency is essential for managing multiple values and handling diverse data sets. Fear no more! Our 1-day Advanced Excel Functions Workshop is designed to equip you with the skills needed to conquer these challenges effortlessly.

Imagine confidently managing and tracking the number of workdays, considering holidays and weekends, without painful calculations or tedious reporting. Bid farewell to the frustration of dealing with disordered or unformatted raw data. With expert guidance, you'll master text-based data manipulation – replacing text, merging strings, extracting data portions, and splitting cell data like a seasoned pro, elevating your performance as a manager or project handler.

Our seasoned instructors will lead you through immersive, hands-on exercises, focusing on crucial Microsoft Excel function categories:

  • Lookup and Reference
  • Math and Trigonometry
  • Date
  • Text

Step up to the demands of today's workplace challenges with our Advanced Excel Functions Workshop. Armed with new skills, you'll fearlessly tackle any data-related obstacle and take your capabilities to new heights.

Don't let data overwhelm you – conquer it with finesse in our 1-day program. Embrace a future of data mastery. Enroll today and unlock your Excel potential!

Our Friendly Trainer

Ms Pauline Lee
Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

  • More than 25 years of training experience
  • Native speaking Trainers
  • Microsoft Certified
  • ITE Certified

Special Request

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.


Coming Soon

No Exam
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.

Empowering the Enduser
Our dedication lies in equipping our learners with the tools to empower themselves. Recognizing the constant evolution of technology in the workplace, we understand the challenges and expectations they face. Bridging this gap for our learners is our motivation. We have faith in the potential of every individual and their determination to achieve success.

Classes in Mandarin

Select courses can be delivered in Mandarin on request basis via Zoom.

  • Microsoft Office
  • Video Editing
  • Essential Digital Skills

Contact Us

Mon-Fri, 8:30am-5:30pm
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here