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 see how the basic knowledge of Excel will be used to support advanced results. We will explore the different techniques to summarise, link, consolidate and lookup data.
Date: 6th & 7th April 2021
Venue: Ansell Industrial & Specialty Gloves Malaysia Sdn Bhd, Kulim, Kedah
Course Objectives:
Upon completion of this program, the participants will be able to:
Group and summarise data using Outline.
Group and summarise data using PivotTable.
Use the What-If Analysis tools to facilitate decision making.
Use various Lookup & Reference functions for reporting.
Perform data linking and embedding.
Consolidate data.
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.
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments