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

Microsoft Excel 2019 Basic to Intermediate

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

Course Code
 
OKEBX9
Duration
 
14 Hours (2 Days)
Course Fee
 
$353.10 inclusive of GST
Funding
 
SDF / SkillsFuture ID: CRS-N-0050130
UTAP for NTUC Members
This Course is For
 
Anyone who wants to get started in using Microsoft Excel 2019 and attain a better understanding and proficiency level for 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.


Prerequisites

None. This course is also suitable for leaners of Microsoft Office 2016.

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


Jump start your experience in using Microsoft Excel 2019

This 2-days hands-on course covers all the essential basics you will need to enter data and build organized spreadsheets. It also provides guidance on how to create a proper database, organizing your data such that it can be used to work with multiple worksheets. You will also learn how to format your data appearance, create cell referencing between cells in different worksheets or workbooks.

You will also get to learn the effectiveness of Excel in applying and deriving mathematical results quickly and easily in many day-to-day calculations for reports. This will enable you to be more productive at work through the use of formulas and basic Excel functions to perform many of your routine and mundane calculations. You will also be taught how to use the "Do Things Quickly" feature and discover new chart types in Excel 2019.

A hands-on based course coupled with many hands-on practice opportunities will enforce and enhance your understanding of Microsoft Excel and experience Excel’s automatic updates capabilities to increase your level productivity and accuracy at work.


Course Outline

  • Introduction to Excel 2019
  • Excel 2019 Interface
  • New Feature: Do Things Quickly, New Chart Types
  • Understanding the different types of data
  • Manipulating worksheets
  • Different ways of viewing large amount of data
  • Different types of data formatting
  • How to apply formatting on data based on condition(s) set
  • Different types of calculation operators
  • Create formula to automate work and solve problems
  • Create Excel basic functions
  • Create different types of hyperlink
  • Prepare the worksheet for printing
  • Apply worksheets and workbook protection
  • Excel 2019 Charts

Our Friendly Trainer

Ms Daphne Wong
Ms Kendra Ong
Ms Pauline Lee
Ms Ow Yeong Yin Leng

Qualified and Experienced to facilitate this course

  • More than 20 years of training experience
  • Native speaking Trainers
  • ACTA Certified
  • 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.


Reviews

Ms Pauline is an amazing trainer. She is very detailed in explaining the concept to me in a patience manner. I have learned a lot of new Excel's functions that hopefully I am able to apply in my work area. Thank you Pauline :)
- Joanne Lew (Singapore Polytechnic)

The course was properly organize. The instructor Ms Ow Yeong Yin Leng was very well knowledge.
- Rajah Amir Khan (MOM)

Thank you for giving very clear and precise instruction, it aids in my learning when I'm confused.
- Toh Zhirong (SCORE)

Ms Kendra has gone through the syllabus in a very clear and easy-to-follow manner, giving us abundant of time to practice instead of running across the chapters, she is also very patient in answering all our questions
- Fook Zhi Ken (SPF)

Trainer is very informative and engaging. She is patient when guiding us as well.
- Valerie Yeo (MOM)


No Exam
No Exam! Ample hands on practice to master lessons taught.

Certificate
Certificate of Attendance will be given subject to 90% attendance.

Trainer
Local native speaking Trainers with more than 20 years of experience.

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.

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
WhatsApp: Click here
Skype: Click here
Phone: 6423-1183
Online Enquiry: Click here
Locate Us: Click here