⚠️Important HRD Corp Update:Effective 15 June 2026 onwards all grant approvals MUST be obtained at least 14 calendar days before the training commencement date.
⚠️Important HRD Corp Update:Effective 15 June 2026 onwards all grant approvals MUST be obtained at least 14 calendar days before the training commencement date.⚠️Important HRD Corp Update:Effective 15 June 2026 onwards all grant approvals MUST be obtained at least 14 calendar days before the training commencement date.
☰

Microsoft Skills

Microsoft Excel (2019) Intermediate

2-Day Course l 100% HRDC Claimable

Course Introduction

Building on the fundamentals, “Microsoft Excel 2019 Intermediate” is a two-day, instructor-led program for professionals ready to move beyond basic spreadsheet use into more purposeful, analytical work; assuming a working familiarity with Excel, including simple formulas, basic charts, printing, AutoFilter, and Freeze Panes, the course lives up to its name by introducing more sophisticated functions such as COUNTIFS, AVERAGEIFS, SUMIFS, and IF statements, enabling participants to summarize and extract data conditionally rather than relying on simple calculations alone, while also covering Excel Tables, advanced sorting and filtering, duplicate-removal, and data visualization through conditional formatting and charts, all rounded out by refreshed workbook management and print preparation skills, equipping learners to work with data more efficiently and present it with far greater clarity and impact.

Learning Objectives

  • Create simple to complex formulas and functions
  • Filter data using Auto & Advanced Filters
  • Clean Duplicate Records
  • Visualizing Data as a Graphics

Training Modules

Module 1: Referencing Calculations Topic A: Formula Reference

Module 2: Working with Functions

Module 3: Organizing Dynamic Data Range with Tables 

Module 4: Data Visualization

Module 5: Managing Large Workbooks

Module 6: Printing Workbook Contents

Request for a Quotation
or Chat with us LIVE

Target Audience

Ideal for clerks, officers, executives, supervisors, administrators, and managers at every level, as well as personnel who already possess a solid grasp of Microsoft Excel and wish to sharpen their skills for more effective, hands-on use.

Training Methodology

This course can be conducted Physically and Online.

Physical Training Methodology
The trainer will provide live guidance and immediate feedback
to strengthen understanding and practical application.

Online Training Methodology
Clear visuals and guided facilitation ensure interactive learning and effective application from any location.

Customization

Duration
Flexible learning options from half a day to a 3-day sessions (and beyond)

Content
100% customizable modules to match your organisation’s exact training needs

Methodology
Delivered in your preferred format, be it physical, online or a blended approach

Request for a Quotation
or Chat with us LIVE

Not exactly what
you're looking for?

No worries, just click on the WhatsApp icon to chat with us immediately or email us at aria@atcen.com