Excel VBA macros course in Barcelona
Learn Visual Basic for Excel from scratch and turn the tasks that take you hours every week into a single click.
- People with advanced Excel skills who repeat the same steps every week.
- Teams that prepare regular reports from several files.
- Anyone who wants to understand and maintain the macros their company already has.
By the end
By the end, everyone automates their repetitive tasks and can understand and adapt the code of the macros their company already uses.
What you will learn
- Module 1
Visual Basic from scratch
- The macro recorder and the VBA editor
- Basic objects: workbooks, sheets and ranges
- Module 2
Programming with logic
- Variables
- Conditionals (If)
- Loops (For, Do)
- Module 3
Task automation
- Reports that generate themselves
- Copying, sorting and formatting data across sheets and workbooks
- Module 4
Connecting with other programs
- Working with other files and Office applications from Excel
Excel training in Barcelona, at your offices or by video call
We mainly work with companies in Barcelona and its metropolitan area. There, the trainer comes to your office; elsewhere, the training is online and live, with the same method.
- Barcelona
- L'Hospitalet de Llobregat
- Badalona
- Cornellà
- El Prat de Llobregat
- Sant Cugat del Vallès
- Sabadell
- Terrassa
- Granollers
- Mataró
- At your officesIn Barcelona and the surrounding area we come to you, with the materials and exercises ready.
- Online, liveThe same training by video call, for teams anywhere in Spain or spread across several offices.
- In your languageSpanish, Catalan and English: classes in the language your team works in.
Questions about this course
Any other question? Message or call us: a person replies, not a bot.
Do I need to know how to program?
No, but you do need advanced Excel skills. If you're not sure, take the level test first.
How long is it?
9 hours, in smaller groups (4 to 10 people) so we can review everyone's code.
Where are the Excel courses in Barcelona held?
At your company's offices, in Barcelona or the surrounding area: we come to you with all the materials. If you prefer, the same training can be done live by video call.
Can the courses be funded through FUNDAE?
Yes, with a guaranteed discount of at least €420. FUNDAE is Spain's state training credit for companies. We handle the FUNDAE paperwork: you just apply the discount to your social security contributions.
Other Excel courses in Barcelona
Beginner Excel
For people with little or no knowledge of Excel.
- 10 h
- With FUNDAE, from €279
Intermediate Excel
You use Excel every day and want to take your skills up a level.
- 12 h
- With FUNDAE, from €379
Advanced Excel
Excel is your main tool and you want to master every detail.
- 12 h
- With FUNDAE, from €479
Shall we run this course for your team?
Tell us how many people you are and when would suit you. We'll reply with groups, dates and a fixed price.
Who is the training for?