What will I learn in this course?

You will 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 will also learn to connect 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 do not need any programming experience. It is useful, however, if you can use Excel well and are familiar with formulas and functions. That way you will more quickly recognise which tasks you are going to 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 edit 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 will also answer questions about your own working situation.

What do I get after the course?

You will receive a Learnit certificate as proof of participation. You will also take your own practice scripts and course materials with you, so that 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 often repeat or that take up a lot of time. That way you can ask targeted 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 for 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.

You can register using the button on the course page. Choose a date and enter your details. You will then receive a confirmation by email with all the practical information.

What does the course cost?

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

Automating Excel with Python course

Name: Automating Excel with Python
Price: 1875.0 EUR
Availability: InStock

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.

Language

The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.

Number of days:

3 days

Course times:

from 10 am to 5 pm

Study load:

21 hours

Education level:

This training is suitable for all levels.

Exemptions:

Exemptions do not apply to this course.

Preparation time:

No preparation time applies to this course.

Certificate:

At the end of the course, a certificate is issued as proof of participation.

The best training for you

At Learnit you will always find a course that takes you further. From (technical) IT skills to communication or personal leadership. You can also choose the training format that suits you best: a classroom course, a tailor-made course at your own office, an online course or an e-learning. We have the right course and the right format for everyone. Because learning in the way that suits you best delivers the best results.

Moving forward together

Taking a training course at Learnit means learning together. Together with your experienced trainer, together with your course group or together with your colleagues. And whether you take the training at home, at your office or at one of our training locations, we are always available to help you. To share our knowledge with you in a way that is genuinely useful to you. Getting further together through personal attention and understanding each other well; that is what we believe in.

Apply it directly in your work

Learning theory from a book that you can then hardly use in your work? Not at Learnit! Whichever training you take with us, you can put it to use at your workplace straight away. Because of the unique learning objectives you set together with the trainer at the start of the training. Because of the alternation between theory and (interactive) practical assignments. And by bringing the challenges you face in your daily work along to the training.

Automating Excel with Python course