Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.
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.
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.
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.You may choose to bring your own laptop if you prefer.
When I've finished, what course can I do next?
City Lit offers a variety of progression courses in this subject area. Please click hereto view our Microsoft 365 Excel courses or click here to view our Programming Courses
Disclaimer: Use of Third-Party Software This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.
Ergi Mira is a London-based software engineer and tutor specialising in artificial intelligence, computer vision, and data-driven systems. He holds a BEng (Hons) in Software Engineering from the University of Greenwich, graduating with First-Class Honours and receiving the Best Project Award for his work on embedded real-time AI systems. Ergi’s background combines academic research with industry practice. He has worked as a Software Consultant and IT Service Desk Analyst, developing intelligent software across automation, IoT, and data analytics. His projects include FastAPI/React applications, network-monitoring agents, and AI-driven predictive systems deployed on the edge using Raspberry Pi and Hailo accelerators. At City Lit, Ergi focuses on applying AI in real-world contexts such as healthcare, sustainability, and creative technology. He teaches courses in Natural Language Processing, Computer Vision, Python for Automation, and Data Analysis, blending live coding, guided labs, and project-based learning to help students transform theory into practical, impactful applications.
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.
product
https://www.citylit.ac.uk/automating-excel-with-python343304Automating Excel with Pythonhttps://www.citylit.ac.uk/media/catalog/product/a/u/automating-excel-with-python-cppy43-1024.jpg299299GBPInStock/Courses/Courses/Business, marketing & technology/Courses/Business, marketing & technology/Web design and programming/Programming/Courses/Business, marketing & technology/Web design and programming22851211140816871228512111687<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>002993555Automating Excel with Python299299https://www.citylit.ac.uk/media/catalog/product/a/u/automating-excel-with-python-cppy43-1024_4.jpgInStockDaytimeSatKeeley StreetAvailable courses1 to 4 weeksWeekend2026-06-13T00:00:00+00:00Some experienceJun 2026Business, marketing & technologyCPPY44299299Automating Excel with Python239194299Ergi Miraautomating-excel-with-python/cppy44-2526<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>0000-Available|2026-06-13 00:00:00Unlock 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.<br><br>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.<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>• Introduction to Python for Excel automation<br>• Understanding the openpyxl and pandas libraries for Excel manipulation<br>• Automating Excel tasks such as data entry, formatting, and complex calculations<br>• Creating interactive and visually appealing reports<br>• Best practices for automating workflows in Excel.• Manipulate Excel data with the pandas library<br>• Create automated reports that update with a single click<br>• Leverage Python to streamline your Excel workflows, saving you time and effort.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:<br>• Write and run simple Python scripts (crash course provided during first session)<br>• Use Excel for data entry and basic functions.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.<p>No additional costs.You may choose to bring your own laptop if you prefer.</p><p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"><u>here</u> </a>to view our Microsoft 365 Excel courses or click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_New_Programming_Courses.pdf" target="_blank" rel="noopener noreferrer">here</a> to view our Programming Courses</p><p>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Web design and programmingProgrammingvirtual3043849Automating Excel with Python319319https://www.citylit.ac.uk/media/catalog/product/a/u/automating-excel-with-python-cppy43-1024_5.jpgInStockEveningMonHybrid (choose either online or in-person)Available courses5-10 weeksWeekday2027-01-18T00:00:00+00:00Some experienceJan 2027Business, marketing & technologyCPPY43319319Automating Excel with Python255207319Ergi Miraautomating-excel-with-python/cppy43-2627<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>0000-Available|2027-01-18 00:00:00Unlock 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.<br><br>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.<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>• Introduction to Python for Excel automation<br>• Understanding the openpyxl and pandas libraries for Excel manipulation<br>• Automating Excel tasks such as data entry, formatting, and complex calculations<br>• Creating interactive and visually appealing reports<br>• Best practices for automating workflows in Excel.• Manipulate Excel data with the pandas library<br>• Create automated reports that update with a single click<br>• Leverage Python to streamline your Excel workflows, saving you time and effort.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:<br>• Write and run simple Python scripts (crash course provided during first session)<br>• Use Excel for data entry and basic functions.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.No additional costs.<p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"><u>here</u> </a>to view our Microsoft 365 Excel courses or click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_New_Programming_Courses.pdf" target="_blank" rel="noopener noreferrer">here</a> to view our Programming Courses</p><p>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Web design and programmingProgrammingvirtual239,255299,319194,207CPPY44,CPPY43NONESat,Mon13/06/26 - 27/06/2611:00 - 17:0011:0017:003 sessions (over 3 weeks)31 to 4 weeks,5-10 weeksDaytime,EveningWeekend,WeekdayKSKeeley Street,Hybrid (choose either online or in-person)Ergi MiraSome experienceAvailable courses2026-06-13T00:00:00+00:00,2027-01-18T00:00:00+00:00Jun 2026,Jan 2027Business, marketing & technology299299,319Automating Excel with Pythonautomating-excel-with-python/cppy44-2526,automating-excel-with-python/cppy43-2627<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>0000-Available|2026-06-13 00:00:00Unlock 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.<br><br>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.<p>Transform your workflow by learning how to automate Excel tasks using Python. This course teaches essential techniques to manipulate spreadsheets, streamline data processing, and generate dynamic reports. Ideal for professionals looking to boost productivity and reduce manual work through smart automation.</p>• Introduction to Python for Excel automation<br>• Understanding the openpyxl and pandas libraries for Excel manipulation<br>• Automating Excel tasks such as data entry, formatting, and complex calculations<br>• Creating interactive and visually appealing reports<br>• Best practices for automating workflows in Excel.• Manipulate Excel data with the pandas library<br>• Create automated reports that update with a single click<br>• Leverage Python to streamline your Excel workflows, saving you time and effort.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:<br>• Write and run simple Python scripts (crash course provided during first session)<br>• Use Excel for data entry and basic functions.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.<p>No additional costs.You may choose to bring your own laptop if you prefer.</p>,No additional costs.<p>City Lit offers a variety of progression courses in this subject area. Please click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_Microsoft_365_Excel_Courses.pdf" target="_blank" rel="noopener noreferrer"><u>here</u> </a>to view our Microsoft 365 Excel courses or click <a href="https://www.citylit.ac.uk/media/wysiwyg/pdf/2627_New_Programming_Courses.pdf" target="_blank" rel="noopener noreferrer">here</a> to view our Programming Courses</p><p>Disclaimer: Use of Third-Party Software<br>This course might require you to either use your own personal account or create an account for the purposes of this course. City Lit cannot accept any responsibility for any failings of the third party or provide technical support. Whilst using the software you will be responsible for abiding by the providers terms and conditions and maintaining your own work.</p>Web design and programmingProgrammingconfigurable
14081687Programminghttps://www.citylit.ac.uk/courses/technology-science-and-business/web-design-and-programming/programming1/2/285/1211/1687/14081/Courses/Business, marketing & technology/Web design and programming/Programming
