Data checking for null, unique value and formatting
Data cleaning for null, spaces, cases and duplicates
Data preprocessing by merging, sorting, grouping and breakdown
Data extraction by location, by label, by condition
Data filtering by conditions (AND,OR,NOT)
Data summary by subtotal and pivot
Data output to Excel or to CSV
OpenPyXL Introduction
Read Excel File
Iterating Rows and Columns
Iterating from a range
Create and Add Content to a Workbook
Write a List to Worksheet
Rename, Add and Remove Worksheet
Insert and Delete Rows and Columns
Set the Font, Alignment and Color for the Cells
Use OpenPyXL to consolidate Excel invoices distributed in different files and sheets
Instructor
Dannis Mok
who has rich experience in business web and apps system development and have over 20 years of teaching experience.
He has great passion in learning and teaching new technologies and his teaching style is clear to point and can explain complex technologies in simple terms.
He has delivered various workshops and classes for different corporate, government departments and local universities and is the principal lecturer for NCC Education and University of Greenwich.
Besides BSc degree in IT, he also got a MBA, MSc in IT and MSc in Telecommunication degree.