Automating Excel with Python
Choose a starting date
Learning modes and locations may be different depending on the course start date. Please check the location of your chosen course and read our guide to learning modes and locations to help you choose the right course for you.
- Start Date: 07 Jun 2025End Date: 21 Jun 2025Sat (Daytime): 11:00 - 17:00Choose either online or in-personLocation: Hybrid (choose either online or in-person)Duration: 3 sessions (over -3 weeks)Course Code: CPPY44Tutors: Muhammad KhanFull fee £289.00 Senior fee £231.00 Concession £188.00
Please note: We offer a wide variety of financial support to make courses affordable. Just visit our online Help Centre for more information on a range of topics including fees, online learning and FAQs.
What is the course about?
Unlock the full potential of Excel by combining it with Python! This course is designed to show you how Python can transform your Excel tasks from mundane to magical. You’ll discover how to automate repetitive processes, manipulate large datasets effortlessly, and create powerful, dynamic reports. By the end of this course, Excel will no longer be just a spreadsheet tool, but a dynamic data engine, powered by Python.
Participants who complete the course will receive a City Lit certificate of attendance, which you can proudly showcase on your CV or for CPD records. The certificate will feature your name, course title, and the dates you attended.
What will we cover?
• Introduction to Python for Excel automation
• Understanding the openpyxl and pandas libraries for Excel manipulation
• Automating Excel tasks such as data entry, formatting, and complex calculations
• Creating interactive and visually appealing reports
• Best practices for automating workflows in Excel.
What will I achieve?
By the end of this course you should be able to...
• Manipulate Excel data with the pandas library
• Create automated reports that update with a single click
• Leverage Python to streamline your Excel workflows, saving you time and effort.
What level is the course and do I need any particular skills?
This course is perfect if you have a basic understanding of Python and Excel and are eager to learn how to automate and optimize your Excel tasks. You should already know how to:
• Write and run simple Python scripts (crash course provided during first session)
• Use Excel for data entry and basic functions.
How will I be taught, and will there be any work outside the class?
The course is hands-on, with a focus on practical, real-world applications. You’ll learn through demonstrations, coding exercises, and problem-solving activities. There may be some optional exercises to reinforce your learning outside of class.
Are there any other costs? Is there anything I need to bring?
No additional costs.
When I've finished, what course can I do next?
Ready to dive deeper into Python or Excel? Check out our advanced programming courses and data analysis workshops. Click here to explore more opportunities to expand your skill set.
Muhammad is a passionate and experienced tutor currently studying for his PhD in Artificial Intelligence. With a strong background as a former Software Engineer and programming tutor, Muhammad combines his deep academic knowledge with practical industry experience to deliver exceptional educational experiences. Notably, he is the first to create a UAV navigation algorithm using Dispersive Flies Optimization (DFO), which outperformed conventional benchmarks typically employed by major corporations. Dedicated to making advanced technology concepts accessible for all, Muhammad is the creator of the 2-step method to mastering any technological skill from conception to completion, where each lesson is related to individually tailored experiences whilst still adhering to a consistent group-based approach. His goal is to democratize AI and technology, ensuring that these powerful tools are available to and usable by every segment of society through digital literacy and empowerment.
Please note: We reserve the right to change our tutors from those advertised. This happens rarely, but if it does, we are unable to refund fees due to this. Our tutors may have different teaching styles; however we guarantee a consistent quality of teaching in all our courses.