Automate Excel Spreadsheets/Tables With Python For Beginners
About This Course
This course equips learners with the foundational skills and practical techniques needed to automate Excel workflows using Python. Participants will begin by learning core programming concepts, including Python syntax, data structures, control flow, and functions. Emphasis is placed on writing clean, modular code and documenting updates—essential habits for building maintainable scripts. Learners will also gain the ability to debug and troubleshoot errors effectively using traditional techniques and modern tools like ChatGPT and Gemini, supporting real-time problem-solving in workplace scenarios.
Building on this foundation, learners will explore the power of open-source libraries such as pandas to automate and simplify spreadsheet-based tasks. They will learn to process, transform, and summarize tabular data using real-world case studies and business scenarios. By the end of the course, participants will be able to translate business requirements into Python programs, generate structured outputs, and refactor their scripts for improved performance and clarity. This practical, business-aligned training ensures learners walk away with immediately applicable skills that support digital transformation and operational efficiency in their organisations.
What You'll Learn
- Define programming and coding and the use of basic Python syntax, including documenting updates and changes with comments.
- Describe data structures and control flow in Python, and how control flows can be implemented with nested data structures to extract intended data for business needs.
- Explain how Python functions can be used to create independent and reusable pieces of codes to organise your entire codebase.
- Evaluate Python code to detect errors and implement effective debugging strategies using Generative AI tools like ChatGPT and Gemini.
- Explain what open source libraries are, their benefits, and how to apply different open source libraries like Pandas to solve different business requirements.
- Learn about the Colab platform and how it differs from other Python distributions
- Code solutions by applying various methods of the pandas library to process tabular data like spreadsheets such as: selecting subset of rows, merge, concat, groupby and aggregation
- Analyse business requirements and strategic objectives to determine opportunities for spreadsheet automation using Python.
- Write Python programs using pandas to transform AS-IS data into TO-BE outputs that meet business requirements.
- Correct Python scripts to improve readability, efficiency, and accuracy in meeting business outcomes.
-
Entry Requirements
Target age group: 18 - 60
Required years of experience in relevant domain: No domain experience required for entry
Minimum education level: Have good English proficiency (English language at GCE 'O' Level of B4 and above, or WSQ Workplace Literacy skills of Level 7 and above).
Other relevant details on entry requirements: Able to perform basic functions in Excel (e.g. using cell references, IF() formula)