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: 18th & 25th August 2022
Client: ESCATEC Electronics Sdn Bhd, Bayan Lepas, Penang
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.
Pre-requisites:
Completed Excel Intermediate Level training or have mastered the following skills:
Perform various cell locking methods.
Use various Statistical functions for reporting.
Use various Logical functions for reporting.
Apply data filters.
Apply data standardization
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