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

Microsoft Excel 2019 Advanced Functions and Formulas

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

Course Code
 
OKEAF9
Duration
 
14 Hours (2 Days)
Course Fee
 
$695.50 inclusive of GST
Funding
 
None
This Course is For
 
Anyone who wants to be able to do more with Excel and be more proficient and productive in using Excel for work.

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

Ideally for those who have completed our Advanced level Excel module or have 2 years working experience and comfortable working with Microsoft Excel.

This course is also suitable for users of Microsoft Office 2016.

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


Microsoft Excel for Today's Workplace

In the recent years things have changed drastically, demands on work and proficiency have also increased. What we deemed as too advanced level of Microsoft Excel function and formula, many have become a norm and expected knowledge in users.

Businesses are constantly challenged with obtaining information and results quickly with more complex conditions. It is no longer merely getting simple totals and averages from a list of values but now based on a condition or multiple conditions, and to perform the necessary data integrity checks.

With demands that push for faster and more accurate data, data retrieval has become more challenging, extraction of specific data from a string of data or from specific cell or cells that satisfies certain conditions.

This 2-day course will get you up to speed with what are expected today with Excel usage at work to keep your relevant in today’s workplace. Design and paced with lots of hands-on practices to ensure you understand and become familiar with the many helpful functions and formulas that will be covered.


Course Outline

  • Introduction to Excel 2019
  • Excel 2019 Interface
  • 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 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


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