Profile
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; ORAble to use and apply Database functionAble 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 commandAble to validate dataAble to apply Conditional FormattingAble to Protect worksheet and workbookUpon completion of this program, participants should be able to:Advance Chart function and PowerPivot FunctionAnalyze data Using Pivot TablesPerform What If Analysis using:Goal SeekSolverInput TableScenariosUse VLOOKUP function to extract dataNesting INDEX and MATCH FunctionCombining & Consolidating DataCreate Hyperlink in a workbook