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: 13th August 2020
Venue: Jinko Solar Technology Sdn. Bhd., Prai, Penang
Upon completion of this program, participants should 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.
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.
This program will be conducted through interactive lectures, practical exercises and group assignments. Case studies on real-world scenarios are included to demonstrate the practicability of the lessons.
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to firstname.lastname@example.org