Python for Excel Users

Python for Excel Users

Python for Excel Users is ideal for Excel users who want to automate repetitive tasks, work with larger and more complex datasets, and take their Excel skills to the next level. Python can be used to automatically import, clean, analyse and combine Excel data, process multiple spreadsheets, generate reports and perform calculations that would be time-consuming to carry out manually.

This practical course introduces Python in the context of familiar Excel tasks, making it an accessible way for Excel users to learn programming while gaining skills that can significantly improve productivity, accuracy and data-analysis capabilities.

COURSE SUMMARY

Python for Excel Users – 2-Day Practical Course

• Duration: 12 hours
• Format: 2 × 6-hour instructor-led days
• Class size: Ideally 2–4 people
• Level: Beginner Python / intermediate Excel
• Prerequisite: Comfortable using Excel, but no previous Python experience required

COURSE OUTLINE

Day 1 – Python + Excel fundamentals

• Python basics for Excel users
• Variables and data types
• Lists and dictionaries
• Conditions and loops
• Functions
• Reading Excel files with Python
• Writing data back to Excel
• Working with multiple worksheets
• Practical Excel automation exercises

Day 2 – Pandas and business data

• Pandas DataFrames
• Importing Excel data into Pandas
• Filtering and sorting
• Cleaning data
• Missing values and duplicates
• Combining datasets
• Grouping and summarising
• Working with multiple Excel files
• Creating automated reports
• Practical business automation project

WHAT IS INCLUDED:

• PCWorkshops Certificate
• Course notes
• Practical Class exercises
• To assist after the course, 1 free session for questions / revision