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

  Trainer - Azrulnizam

  Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others.