learn | unlearn | relearn

Virtual Public Programmes

Countdown Expired!

Who should attend

Senior Level, administrative staff including

Senior Sales & marketing executive
Finance staff
Senior Account Executive
Personal Assistant
Senior IT staff
Purchase
executive
Operation staff
Retail staff
Whom job description require them to not only enter data but to analyze data into Excel.
Those who play a supportive role in decision making process will find this course useful.

Programme Intro

The Microsoft Excel Data Analysis Class is a hands-on practical training where you will be teaching you some of the most powerful Excel Advanced function that will improve your productivity, your ability immediately with industrial case study related to finance, HR, Sales, manufacturing, retail.

Course Objectives

At the end of this training, you will be able to:
• Analyze data faster and easier than you think
• Understand VLOOKUP function completely
• Understand how to use IF function to perform data analysis.
• How to combine multiple function together to perform data analysis
• Idea that can help you improve your performance in creating monthly report.
• How to protect the report you created.
• How to highlight item that meet certain requirement
• How to use Pivot Table, Pivot Chart, Slicer
• How to use Named Cell, Named Range in complex Excel formula
• How to use INDEX, HLOOKUP, MATCH
• How to create a dropdown list