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 top-ics learned in the Basic Level.
Date: 9th November 2021
Format: Remote Online Learning
Client: Ryco Hydraulics (M) Sdn. Bhd., Kuala Ketil, Kedah
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.
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