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: 18th & 19th June 2019
Venue: Benchmark Electronics (M) 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
Prerequisite:
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
Course Methodology:
This program will be conducted through interactive lectures, practical exercises and group assignments.
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 .
Feel free to contact TSY Consultancy by Call / WhatsApp to +6017-4036965 or email to marketing@tsy.my
Cheers.
Comments