learn | unlearn | relearn
Virtual Public Programmes
Who should attend
Senior Level, administrative staff including
- Senior Sales & marketing executive
- Finance staff
- Senior Account Executive
- Personal Assistant
- Senior IT staff
- 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.
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.
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