Python for Excel Users

Research
Prerequisites: 

Took Introduction to Python or previous basic knowegle of Python

Description: 

Excel is a popular and Powerful tool for data storage and analysis. The openpyxl module allows Python to read and modify Excel files, automate your boring tasks and increase your work efficiency. In this workshop, you will learn:

  • How to import Excel workbook
  • Change sheet name
  • Create / remove sheet 
  • Change fonts
  • Write values to certain cells
  • Automate your boring tasks with code

 

Course Materials & Resources

Dates for this Short Course

Friday, June 4, 2021 - 10:00am to 11:30am
Location: 
Zoom. Zoom meeting ID and password will be emailed to you a day before the workshop if you sign up.
Research Data Tags: