Course Overview
What are the 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
Who should attend this course
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.
Course Curriculum
What are the 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.
Course Modules
Exam & Certification
This course is not associated with any Certification.
