Excel automatiseren met Python incompany
A three-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.
NRTO quality mark
- Tailored: matched to the level and goals of your team
- Trainers from the field, who do the work themselves
- At your premises, at ours or online, on a date that suits you
- In Dutch or English, in the language of your choice
What the course covers
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.
Lees het volledige programma van Excel automatiseren met Python
How an in-company course works
- RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
- AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
- The courseOn the day and at the place you chose, with course materials for every participant.
- AfterwardsEvery participant receives a certificate of attendance.
Practical information
- Duration
- Three-day course
- Group
- Only your own people
- Location
- At your office, at one of our locations or online
- Date
- You choose
- Language
- Dutch or English
- Included
- Course materials and a certificate of attendance
- Price
- Vaste prijs per groep, in een offerte op maat
Veelgestelde vragen over Excel automatiseren met Python incompany
Waar vindt de incompany training Excel automatiseren met Python plaats?
Wherever suits you: at your office, at one of our training locations or online. You also choose the date.
Can the content be tailored to our organisation?
Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.
How large can the group be?
That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.
Wat kost Excel automatiseren met Python incompany?
Je krijgt een vaste prijs voor de hele groep, in een offerte op maat. Met een groep is dat voordeliger dan iedereen los inschrijven.
Can the course be delivered in English?
Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.
Do participants receive a certificate?
Yes, every participant receives a certificate of attendance afterwards.
How do I request a quote?
Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.
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.
Excel automatiseren met Python voor jullie team?
Request a quotation without obligation and you will hear from an adviser soon.