⚠️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.
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