4.5 Read 8 reviews
Overview
What you will study
- In the Spreadsheet Data Analysis and Automation with Python course offered by City St George's, University of London , 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.
Programme Structure
The program focuses on:
- 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
- Review of Python data structures; Python documentation
- Installing Python libraries such as pandas, numpy, openpyxl
- Charting; Matplotlib library
- Installing Anaconda, using virtual environments
- Automating Excel and Office with xlwings and win32.com
- Working with Google sheets
Key information
Duration
- Part-time
- 2 months
Start dates & application deadlines
- Starting
- Apply before
-
- Starting
- Apply before
-
- Starting
- Apply before
-
Language
English
Delivered
Online
Campus Location
- London, United Kingdom
Disciplines
Data Science & Big Data Data Analytics View 36 other Short Courses in Data Science & Big Data in United KingdomWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- Comfortable with basic programming in Python and installing software. No special maths knowledge required.
- You will need a good level of spoken and written English to enrol on this course.
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residents595 GBP / full≈ 595 GBP / full -
Domestic Applies to you
Applies to youCitizens or residents595 GBP / full≈ 595 GBP / full
Funding
Improve page content