Microsoft Excel 2019 Advanced Functions and Formulas

---

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