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
  • 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

Crossurvive Sdn Bhd

(1263470-P)

Address: 713, Block B, Mentari Business Park, Jalan PJS 8/5, Bandar Sunway,
46150, Petaling Jaya, Selangor Darul Ehsan.

Office: 603-5612 8091
Mobile: 6019-933 8631
Email: info@crossurvive.com.my

Registration Form

PHP Code Snippets Powered By : XYZScripts.com