Overview
Skills Covered
Upon completion of this program, participants should be able to:
- Create formulas and functions, like:
- AVERAGEA &AVERAGEIFS Function
- SUMIF & SUMIFS Function
- IF Functions
- Nested Functions
- Validate data in a Worksheet
- Filter data using Auto & Advanced Filters
- Visualizing Data as a Graphics
Prerequisites
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation Level; OR
- Able to create a spreadsheet with simple formatting
- Able to print a spreadsheet with headers and footers added
- Able to apply Freeze Pane command
- Able to create basic formulas – Addition, Subtraction, Multiplication and Division
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
Target Audience
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Module 1: Referencing Calculations
Topic A: Formula Reference
- Relative References
- Absolute References
- Mixed References
Module 2: Working with Functions
Topic A: Conditional Data Summary 1
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
- SUMIF / SUMIFS
Topic B: Conditional Data Extraction
- IFERROR
- IF
- IFS & Nested IF
Module 3: Organize Dynamic Data Range with Table
Topic A: Create and Modify Tables
- Create table
- Table Styles and Options
- Removing Duplicate Values
- Total Row with SubTotal Functions
- Rename table
- Convert table to range
Topic B: Data Validation
- Data Validation Using Lists
- Data Validation Using Whole Number / Decimal
Topic C: Sort and Filter Data
- Sorting Data by value
- Sorting data by color
- Filtering Data
Module 4: Data Visualization
Topic A: Conditional Formatting
- Highlight Cell Rules
- Data Bars
- Icon Sets
Topic B: Create Charts
- Chart Insertion Methods
- Resizing and Moving the Chart
- Adding Additional Data
- Switching Between Rows and Columns
Topic C: Modify and Format Charts
- Formatting the Chart with a Style
- Chart Elements
- Title
- Axis
- Legend
- Data Label
- Data Table
Dates & Locations
July 9, 2026 - July 9, 2026
July 9, 2026 - July 9, 2026
September 10, 2026 - September 10, 2026
September 10, 2026 - September 10, 2026
October 8, 2026 - October 8, 2026
October 8, 2026 - October 8, 2026
December 3, 2026 - December 3, 2026
December 3, 2026 - December 3, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
