This course is specially customized to cover a number of key areas relating to the visualization of data to produce useful engineering reports.
Date: 28th & 29th March 2024
Venue: NationGate Solution (M) Sdn. Bhd., Prai, Penang
Course Objectives:
By the end of the course, participant will be able to:
structure data efficiently with the correct data type.
use Sparklines to show data trend.
use Conditional Formatting to highlight specific data.
use advanced charting techniques to visualize data.
create PivotTable and PivotChart which is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.
create useful engineering methods in Excel
Prerequisite:
Participant must have attended DATA ANALYSIS IN MICROSOFT EXCEL (Basic) or have the basic knowledge of Microsoft Excel as below:
Managing Workbooks and Worksheets
Formatting Cells
Formula Syntax, Simply Operators, and AutoSum Functions
Data Fill
Course Methodology:
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.
Who Should Attend:
Participant - especially engineer - who needs to interpret and communicate large quantities of information clearly by summarizing it into an interactive reports for more effective way to analyze data.
More Pictures:
Feel free to contact TSY Consultancy by Call / WhatsApp to +6012-6243921 or email to marketing@tsy.my
Cheers.
Comments