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.
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.
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.
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.
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.
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.
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.
On completion of the course, a Learnit certificate is issued as proof of attendance.
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.
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.
“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.”
"I have very good impression of the content of the training and specially of the trainer"
"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."
“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”
“'The first time I have attended a webinar. Definitely worth repeating. Clear explanation. Clear presentation.'”
“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.”
"Excellent course, the open learning format turns out to suit me very well"
“The Open Learning format course allows you to practise and perfect the areas you work with on a daily basis. You can also expand your knowledge by working through the modules in the course book.”
“The training is given in an enjoyable way. You get to work on things yourself, and if you have questions, time is taken for you.”
“Good course based on the individual wishes of the client”
“The course is of good quality and is well geared to practical use.”
“The training course was manageable within the time set. I learned what I came for.”
“This training will save a lot of time in future because of all the tips and trix we learned.”
“Clear and suitable for everyone. The book is described very clearly with plenty of examples and assignments. Nice that you receive both the book and the CD-ROM with all the exercises, so that you can keep practising after the course and maintain your knowledge.”
"Good course. The trainer has extensive knowledge of Excel and explains things calmly and clearly."
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“No pressure to keep up with fellow participants who might be faster, as you would have in a classroom course. A trainer is on hand if needed and comes straight over when you ask.”
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
“A great introduction to getting more out of yourself and Excel.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“The Excel training course was good. We also received good materials to practise with on our own afterwards. The trainer passed on his knowledge to us in an interesting way.”
"A professional course with an expert trainer"
“Plenty of enjoyable exercises that you can join in with and apply straight away. A good, clear trainer who gives everyone attention.”
“This training really is worth recommending: a small group of people, a serious teacher and I learned a lot.”
“The course is well structured. You learn what you want to learn. What was particularly good was that we discussed the issues we as a team often run into at work and that solutions were offered for them. This way you can apply it directly in your work and make your job easier.”
“I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
“A good practical introduction to Python. You learn to programme independently.”
"Excellent course if you want to understand the working methods and logic behind VBA/macros. It ultimately means that, in addition to recording macros, you are also able to write formulas and programs yourself. Gives you plenty to go on when exploring what is possible with VBA. I already knew something about recording macros, but this gave me insight into how VBA works and what to look out for. Great!"
“Enjoyable and very practice-oriented training”
"Bart was very passionate and driven; we could not have wished for a better trainer over those two days. It felt good and approachable, and you could tell he genuinely enjoys Excel. Got some good practical tips. Brilliant!! Bart got me completely enthusiastic even though I had really been dreading it."
"I thought it was a good and worthwhile course. I learned a great deal from it. The trainer gave clear explanations and has extensive knowledge of Excel."
"I found the course very instructive, in a calm and pleasant environment and led by an expert trainer. Thank you."
“The course gave me a good start in better understanding the embedded system I work with at the company.”
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
“Professional training, given by a highly knowledgeable trainer who was very well able to pass on his knowledge in a pleasant and clear way. The content of the training was very sound. The course material really did start from the basics. I found it very pleasant that I could set the pace myself. The course material and the set-up were professional and there was plenty of variety in the assignments/exercises.”
“The course gave me a good start in better understanding the embedded system I work with at the company.”
“Highly recommended; good level, professional guidance and good materials. I particularly enjoy the keyboard shortcuts and knowing new, quick solutions.”
“Enjoyable course because you work through the exercises yourself at your own pace. Skipping things you already know is no problem at all.”
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
"If you want to do anything with data validation, this course comes highly recommended. After this course you will have learned a great deal about validating data."
"Good course, in which you work independently a great deal. Good course material and a pleasant trainer, who helps immediately with questions and explains things very clearly."
“A short, clear course for someone who has worked with pivot tables little or not at all but would like to learn.”
“If you run into problems with Excel in practice, take this course. Alongside the standard course material there is plenty of time to work through your own practical examples.”
“A very professional training course, highly applicable and easy to follow.”
"I found the course very instructive, in a calm and pleasant environment and led by an expert trainer. Thank you."
"If you want to do anything with data validation, this course comes highly recommended. After this course you will have learned a great deal about validating data."
“A good, practical course that you can do at your own pace. There is plenty of room to ask questions while still working at your own pace.”
“Very well prepared training with very easy to follow exercises that will make excel look less of complicated system.”
“The location where the course is held is very easy to reach. The times at which the course took place were very pleasant (10:00 - 17:00, so not too early and not too long). The course itself was very good. You had the space to learn at your own pace and to spend more time on the parts you wanted to know more about.”
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.
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.
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.
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.
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.
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.
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.
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.
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.
Yes, on completion you receive a Learnit certificate as proof of participation.
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.
You will find the current price at the top right of the course page.