top of page

TSY In House Training #574: Data Analysis and Reporting In Excel (for Engineering Data)


TSY In House Training #574: Data Analysis and Reporting In Excel (for Engineering Data)
Training in progress.

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.


1 view0 comments
bottom of page