Learn Microsoft 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.

Basic knowledge of Microsoft Excel is essential with the following pre-requisites:

• Have attended Microsoft Excel – Foundation and Intermediate Level; OR
• Able to use and apply Database function
• Able to use and apply Logical function (IF, AND)
• Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
• Able to use and apply Mathematical function (SUMIF, SUMIFS)
• Able to use and apply Lookup function (VLOOKUP)
• Able to use Auto and Advanced Filter command
• Able to validate data
• Able to apply Conditional Formatting
• Able to Protect worksheet and workbook

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

• Advance Chart function and PowerPivot 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
• Create Hyperlink in a workbook