Managing data systematically and logically is very important to produce a proper report. The latest Microsoft Excel offers more features and enhancements to better manage your spreadsheet. In this Level, we will explore the usage of Functions and Table to generate and analyse reports as well as digging deeper into the features of selected topics learned in the Basic Level.
Date: 24th & 25th May 2022
Client: ESCATEC Electronics Sdn Bhd, Bayan Lepas, Penang
Course Objectives:
Upon completion of this program, the participants will be able to:
Perform various cell locking methods.
Use various Statistical functions for reporting.
Use various Logical functions for reporting.
Use colours to uncover important data.
Apply data filters.
Apply data standardisation.
Apply various protection to Workbook and Worksheets.
Pre-requisites:
Completed Excel Basic Level training or have mastered the following skills:
Perform AutoFill.
Use basic formulas – Addition, Subtraction, Multiplication and Division.
Use basic functions – AutoSum.
Create a basic Chart.
Adjust page layout and print.
Who Should Attend:
This course is suitable for Administrative staff such as Human Resource, Sales and Marketing, Technical staff such as Engineers, IT and Analysts as well as Managers of all levels.
Training Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments.
More Training Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments