This ultimate Excel bundle is for anyone from zero knowledge to expert level. We have split the training into 3 sections. Foundation, Intermediate andAdvanced. The Foundation course is taught by Rezall, Intermediate taught by Jarina, and last but not least, Advanced is taught by Azrul. All 3 of them are certified trainer for Microsoft (MCT). They have more than 40 years of experience combined.

Course Objectives:
ExcelFoundation
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.

Upon completion of this program, participants should be able to:

• Getting Started with Microsoft Excel 2019, Identify the Elements and Interface of Excel

• Performing Calculation, Basic Formula and Functions

• Modify worksheet & Formatting Worksheet

• Printing and managing large workbook

Excel Intermediate
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.

Upon completion of this program, participants should be able to:

• Create simple to complex 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

• Advanced Chart Formatting

• Clean Duplicate Records

• Visualizing Data as a Graphics

Excel Advanced
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.

Upon completion of this program, participants should be able to:

• Create Subtotal Using the Subtotal Function

• Analyze data Using Pivot Tables

• Perform What If Analysis using:

• Goal Seek

• Solver

• Input Table

• Scenarios

• Use VLOOKUP function to extract data

• Nesting INDEX and MATCH Function

• Combining & Consolidating Data

• Summarizing & Analyzing with Pivot Table and Pivot Charts

• Record and Run a Macro