Automating Excel with Python course

Learn to automate Excel with Python. You work with pandas and openpyxl to read, edit and generate spreadsheets. You create formulas, charts and pivot tables. No programming knowledge required.

4,6 on Google NRTO quality mark
For a team or department? Arrange your own group, at your premises or ours. In-company for your team
  • Automate recurring work in Excel with Python scripts
  • Work with powerful modules such as pandas and openpyxl
  • No programming experience needed to get started
  • Small group size with an experienced trainer
  • Directly applicable to your own spreadsheets

Do you work a lot with Excel and want to save time on repetitive work? With Python you automate tasks that take a lot of clicks in Excel. Python is free, runs on any platform and has modules for almost every application. In this course you learn Python in combination with spreadsheets. You process data, create formulas and charts and adjust the style of your workbook. You start from scratch and finish with scripts you can use straight away.

Description

Python is an accessible programming language that you can pick up quickly, even without previous programming experience. Its intuitive set-up means you can build something useful in the very first lessons. In many organisations Excel is used to record and process data, often with the help of VBA. With Python you take a more modern approach.

During this course you learn how to use Python to read, edit and generate spreadsheets. You work with the Anaconda distribution and Jupyter Lab. After that you go deeper into modules such as pandas and openpyxl. With pandas you analyse data and create pivot tables and charts. With openpyxl you edit formulas, formatting and charts directly in an Excel file. You also discover xlwings and xlsxwriter, and learn how to link databases to spreadsheets. The theory alternates with plenty of practical exercises, so you apply what you learn immediately.

For teams and organisations. If a department with a lot of recurring Excel work wants to get started with Python, we also offer this course in-company. In consultation with you, we work with examples from your own practice.

Topics

  • Installing Python via the Anaconda distribution and working in Jupyter Lab
  • Data types: numbers, strings, lists, sets and dictionaries
  • Control statements, loops and comprehensions
  • Functions, modules and reading and writing files
  • Understanding and using classes
  • Working with pandas: Series, DataFrames, pivot tables and charts
  • Working with openpyxl: spreadsheets, formulas, charts and formatting
  • Combining Pandas and openpyxl in a single workflow
  • Linking databases to spreadsheets
  • Other modules: xlwings and xlsxwriter

Result

After this course you will write Python scripts independently to automate your Excel work. You read and write spreadsheets from Python, process data with pandas and build overviews and charts. You add formulas and adjust the formatting with openpyxl. You know which module is best for which task and can also combine them. In addition, you link databases to your spreadsheets. This saves you time and reduces errors in manual steps.

Target audience

This course is intended for Excel users who want to automate their spreadsheet work with Python. Think of data analysts, controllers, finance staff, researchers and anyone who regularly works with large or complex Excel files. Have you worked with VBA before and would you like to move to a modern approach? Then this course is suitable for you as well. You do not need any programming experience to take part.

The course is also suitable for roles in which you repeatedly compile the same reports, exports and overviews in Excel, such as in business control, planning, administration and reporting.

Teaching method

You follow the course in a classroom on location or online via a live connection. Groups are small, so you receive plenty of personal attention from the trainer. Theory and practice alternate. You work on assignments that reflect real situations from your work, so you can apply what you learn straight away. The trainer is an experienced Python developer who gives you targeted feedback. Questions about your own spreadsheets are welcome.

Prior knowledge

You do not need any programming experience. Experience with Excel is useful, however, so that you understand which tasks you are going to automate. A basic knowledge of formulas and functions in Excel will help you relate the material to your own work more quickly. The course starts with the basics of Python and builds up steadily.

Comments

On completion of the course, a Learnit certificate is issued as proof of attendance.

Practical information

Number of days
3 days
Course times
from 10 am to 5 pm
Teaching hours
18 hours
Education level
Suitable for all levels
Preparation time
None
Included
Course materials and lunch on site
Certificate
At the end of the course you will receive a certificate of attendance

Language

The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.

This course for your team?

Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.

  • Your date and location
  • Tailored content
  • Multiple groups or an academy are also possible
  • More than 25 years' experience
Request a quote No obligation, an adviser will be in touch shortly How in-company works

What others say about this course

“This is a good course for delving into the basics of the Excel package without it becoming very complicated straight away. Without any prior knowledge, you can create attractive Excel sheets with appealing formatting and charts.”

Peter Anuels
Praclox BV
Excel Basics
9.0

"I have very good impression of the content of the training and specially of the trainer"

Participant
Excel Expert

"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."

Participant
Excel Pivot Tables, formulas and functions

“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”

J. Watulingas
Excel Expert
8.0

“'The first time I have attended a webinar. Definitely worth repeating. Clear explanation. Clear presentation.'”

C. Leenders
Academisch Ziekenhuis Maastricht
Free webinar Pivot Tables in Excel 2010 and 2013
9.0

“If you want to take a tailor-made course where everything is well organised and well looked after, I would recommend Learnit to anyone. I have had a very good experience.”

Ralph van Erkel
Wierden en Borgen
Excel Basics

Training formats

Classroom

3 days€ 1875,-
  • Pleasant venue with a good trainer
  • Small groups
  • Inspiring and motivating
Choose a date

Online

3 days€ 1620,-
  • Online with a trainer
  • Personal
  • Practical and interactive
Choose a date

In-company

Bespoke trainingOn request
  • 100% for your group
  • Bespoke training
  • At your place or ours
View in-company

Workshop

Up to 4 hours for groupsOn request
  • Suitable for events
  • Interactive and inspiring
  • Large groups too
Request a quote

Private training

At our place or yoursOn request
  • 100% just for you
  • Achieve a lot in little time
  • Whenever you want
Request a quote

Frequently asked questions

What will I learn in this course?

You learn to automate Excel work with Python. You start with the basics of Python and go on to work with modules such as pandas and openpyxl. You read and write spreadsheets, edit data, create formulas and charts and adjust formatting. You also learn to link databases to Excel and work with xlwings and xlsxwriter.

Who is this course for?

The course is intended for anyone who works a lot with Excel and wants to speed up their work with Python. Think of data analysts, controllers, researchers and finance staff. This course is also suitable if you previously used VBA and want to switch to Python.

What prior knowledge do I need?

You don't need any programming experience. It is useful, however, if you are a confident Excel user and familiar with formulas and functions. That way you will more quickly recognise which tasks you can automate.

What does the course look like?

You alternate between theory and practical exercises. First you learn the basics of Python. Then you move on to pandas and openpyxl and build real scripts that manipulate spreadsheets. You finish with topics such as databases and additional Excel modules.

What is the delivery format?

You can take the course in a classroom on location or online via a live connection. In both cases you work in a small group with personal attention from the trainer.

Who teaches the course?

The course is taught by an experienced Python developer with practical experience in data analysis and Excel automation. The trainer also answers questions about your own working situation.

What do I get after the course?

You will receive a Learnit certificate as proof of participation. You also take away your own practice scripts and course materials, so you can look back on what you have learned later on.

How can I prepare?

Extensive preparation is not necessary. It helps if you think beforehand about tasks in Excel that you repeat often or that take up a lot of time. That way you can ask specific questions during the course and practise with situations from your own work.

What if I can't attend?

Let us know as soon as possible. We will look at a suitable alternative together, for example another date. You can find our cancellation terms on the website.

Do I receive a certificate?

Yes, on completion you receive a Learnit certificate as proof of participation.

How do I register?

You register via the button on the course page. Choose a date and enter your details. You will then receive a confirmation by e-mail with all the practical information.

What does the course cost?

You will find the current price at the top right of the course page.

Is this course suitable if I currently work with VBA?
Yes. You do not need VBA knowledge for this course. Python is a different language from VBA, so you learn the basics of Python and then apply them to your spreadsheets.