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.
NRTO quality mark
- 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.
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.
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
What others say about this course
“'Expert tailored work, highly recommended!!”
"The material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
“Efficient for people who already use databases in Excel a great deal.”
“Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”
"An enthusiastic trainer who explains Excel very clearly with good examples. The assignments tie in with this very well. The Utrecht location is a pleasant place to attend the course and is easy to reach by public transport."
“A complete course with clear exercises, given by a very experienced and pleasant trainer. Highly recommended.”
“Practical training course with good personal guidance in an excellent environment.”
"Practical and instructive. A quick way to get a good grasp of Excel."
“The course is well geared to practical use, is presented clearly and is set up in such a way that it is easy to follow at all levels.”
“The Excel 2010 Basics course gives you a good picture of what the new Excel has to offer. You'll be amazed by the new possibilities with charts. 180 pages won't make you a guru, but you will become a good deal more capable.”
“Over the past 2 days I followed the Excel Basics course and it has made me a good deal more skilled with Excel.”
“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.”
“A carefully designed course in which my learning objectives received concrete attention.”
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
"This course ties in well with your individual objective and is applicable to your work."
“Good teaching method. Plenty of material. Very satisfied with Learnit.”
"This training course is excellent for those who have a good grounding in Excel and want to improve further. The trainer was very professional and helpful. The right way to run this kind of course."
“Excellently organised and very professional training, and highly applicable in practice.”
“Excellent course thanks to good guidance and clearly structured assignments that allowed the newly acquired knowledge to be applied straight away.”
"The PowerPivot training course gave our group a great deal of insight. Along the way you pick up plenty of tips and tricks that make your work far more efficient. For people who process or analyse a lot of data, this course is definitely recommended."
“Interesting course. Even though I already had some knowledge of Excel, I learned how to work faster and more efficiently. Everyone got the attention they needed. There is a relaxed atmosphere in which a lot of work is done and a lot is learned.”
“It was an instructive course and you could learn everything calmly at your own pace.”
“I was very pleased with my Excel course, and I was fortunate enough to have a friendly and helpful trainer (Albert Keupink) whom I would happily recommend to others!”
“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, professional training course with plenty of 'tips & tricks' for every starting level."
“An instructive course for understanding the basics of Excel and putting them to use. Also instructive for people who already work with Excel quite a lot, because the course is very comprehensive.”
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
“This training will save a lot of time in future because of all the tips and trix we learned.”
“A very worthwhile course. And certainly well looked after at Learnit! The trainer was very knowledgeable and gave good support.”
“Gaining more understanding and knowledge of Excel at your own pace. The group is fairly small, so there are minimal distractions. The organisation and the trainer are a breath of fresh air, and I am not easily satisfied.”
“An excellent introductory course in Excel in which everything is well explained and readily applicable.”
“The open learning format is well worth recommending if you like working independently at your own pace. The trainer answers your questions when needed and is happy to give advice and extra useful information suited to your level. The course material is clear and lets you practise new skills several times so that you really master them.”
"F. Van den Berg - "Good training. Good course material. Recommended!" - Rating: 8.0"
“I sincerely recommend it, training at a good level with very carefully prepared materials.”
“At our own location, under the guidance of an expert trainer, we were brought up to speed on using Excel in a very pleasant way.”
"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."
“The course material is clear and gives you the chance to work through the topics and practise at your own pace. There is no pressure from other participants and no one holds you up. Combined with the good instructor, this makes for an effective course.”
“A good, comprehensive training course with a good trainer. I can go through everything again at home at my leisure. Definitely recommended.”
“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.”
“Very good course! Everything is perfectly organised and I would certainly recommend taking a course at Learnit.”
“If I had known about these possibilities in Excel earlier, it would have saved me a lot of time and effort!”
“Sjoerd Jellema made the course personal by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader who has a good command of the subject matter but also carries the group along with the material being covered. I found the course very practical, and cases I brought along myself were also dealt with. This brought the theory to life in practice.”
“Interesting course. To really master all the material, it is advisable to set aside enough time for it.”
"Great course and very useful!"
“If in doubt, do get advice from Learnit. I found these 2 days interesting, all the more so because this course was taught in an expert manner.”
“A good addition to an Excel user's knowledge, even if you have already been using it on your PC for years. There are many more possibilities, which the trainer points out clearly.”
“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!!”
"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."
“In two days you learn to apply the basic skills of Excel properly”
“Good course for beginners, even if you have no affinity with computers at all. Anyone can do it!”
Training formats
Classroom
3 days€ 1875,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want
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.