Advanced Excel course in Barcelona
For people who live in Excel: advanced lookups, functions with several conditions, data management and a first look at macros.
- People for whom Excel is their main work tool.
- Finance, management control, logistics or data analysis teams.
- Anyone who passes the intermediate block of the level test.
By the end
By the end, the team builds reports that update themselves, keeps its formula errors under control and knows when to move on to VBA macros.
What you will learn
- Module 1
Advanced lookups
- INDEX and MATCH
- XLOOKUP (Excel 365)
- IFERROR to keep errors under control
- Module 2
Functions with several conditions
- SUMIFS and COUNTIFS
- Nested functions
- Module 3
Data validation and management
- Data validation and drop-down lists
- Cleaning and importing data that comes from other systems
- Module 4
Advanced pivot tables
- Calculated fields
- Slicers and timelines
- Simple dashboards
- Module 5
Introduction to macros
- Recording and running macros
- When it's worth automating with Visual Basic
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.
Which version of Excel do we need?
Any recent one. If you work with Excel 365, we also cover its newer functions, such as XLOOKUP.
How long is it?
12 hours, split into sessions that fit your schedule.
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 II · VBA macros
Automate repetitive tasks with Visual Basic macros.
- 9 h
- With FUNDAE, from €279
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?