Overview
Skills Covered
Upon completion of this program, participants should be able to:
- Create formulas and functions, like:
- COUNTA & COUNTIFS Function
- AVERAGEA &AVERAGEIFS Function
- SUMIF & SUMIFS Function
- IF Functions
- Nested Functions
- Database Function
- 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
Topic B: Apply Range Names
- Adding a Range Names Using the Name Box
- Adding a Range Names Using Define Name
- Adding multiple names using Create from Selection
- Editing and Deleting Range Name Using Name Manager
- Using Range Names in Formulas
Module 2: Working with Functions
Topic A: Data Summary with Function
- COUNTA
- AVERAGEA
Topic B: Conditional Data Summary 1
- COUNTIF / COUNTIFS
- AVERAGEIF / AVERAGEIFS
- SUMIF / SUMIFS
- MAXIF
- MINIF
Topic C: Conditional Data Extraction
- IFERROR
- IF
- IFS & Nested IF
Topic D: Conditional Data Summary 2
- DSUM
- DCOUNT / DCOUNTA
- DAVERAGE
- DMAX
- DMIN
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
- Data Validation Using Date
Topic C: Sort and Filter Data
- Sorting Data by value
- Sorting data by color
- Filtering Data
- Advanced Filtering
Module 4: Data Visualization
Topic A: Conditional Formatting
- Highlight Cell Rules
- Data Bars
- Icon Sets
- Creating New Rules with Formula
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
Topic D: Adding Sparklines
- Adding Sparklines
- Removing Sparklines
Topic E: Editing Sparklines
- Showing and Hiding Data
- Changing the Style
- Changing the Sparkline and Marker Color
- Setting Axis Options
Module 5: Setting Up Reports as Pages
Topic A: Working with Different Views
- Using Page Break Preview for Page Setup
- Using Page Layout View for Express Header & Footer
- Using Custom view
Dates & Locations
July 13, 2026 - July 14, 2026
July 13, 2026 - July 14, 2026
September 14, 2026 - September 15, 2026
September 14, 2026 - September 15, 2026
October 12, 2026 - October 13, 2026
October 12, 2026 - October 13, 2026
December 7, 2026 - December 8, 2026
December 7, 2026 - December 8, 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
