Overview
-
-
-
Duration/Frequency:
16 Hours / 2 Days
-
Mode of Training:
Classroom
Course Objective
This course thoroughly introduces utilising Python with Microsoft Excel for sophisticated data analysis and task automation in manufacturing processes. The course shows participants how to construct and manipulate workbooks and sheets while introducing the fundamentals of Excel automation using Python modules like openpyxl. To insert and format data, the participants will learn how to combine and separate cells, add comments, and use conditional formatting. In addition, the course covers how to apply formulas and data validation in Excel, as well as a variety of chart styles (e.g., columns, lines, pies, bubble charts).