You will install and use libraries to manipulate data and automate processes in Microsoft Excel and Google sheets. Suitable for people with basic Python or good programming skills.
1 starting date
- Duration: 10 weeks
- Time: to
- Fees: £560 (no VAT)
- Occurs: Wednesday
- Location: Online
- Booking deadline:
Want to find out more?
Spreadsheet Data Analysis and Automation with Python Course overview
Suitable for people familiar with basic Python, this intermediate course uses Python frameworks to manipulate Excel spreadsheet and Google Sheets data. We use various Python libraries for manipulating Excel formats, especially OpenPyXL.
We also use xlsxWriter and tools for binary and legacy formats such as pylxsb, xlsd, xlst and xlUtils. These are used to manipulate cell data, worksheets, files, charts, format data and produce summary reports in Excel format, sometimes without opening Excel.
We also automate Excel with xlWings. People with VBA experience will find many of the operations familiar.
Who is it for?
Those familiar with Python basics looking to manipulate and automate data on spreadsheets.
- Tuesday evenings for 10 weeks
- 6:30pm to 8:30pm.
What will I learn?
- Installing Python libraries such as Pandas
- Use openpyxl to manipulate data in Excel format
- Use xlwings to automate Excel
- Use Python to manipulate data in Google sheets.
Assessment and certificates
Learning is hands-on in a sequence of interleaving lectures. There will also be practical exercises that students can work on in their spare time.
Comfortable with basic programming in Python and installing software.
You will need a good level of spoken and written English to enrol on this course.
- Python for Excel – a modern environment for Automation and Data Analysis, by Felix Zumstein, O’Reilly.