Intermediate Excel course in Barcelona
The course companies ask us for most: conditional functions, lookups and pivot tables, so you stop doing by hand what Excel can do for you.
- People who use Excel every day and want to work faster.
- Admin, purchasing, sales or HR teams who prepare reports.
- Anyone who passes the beginner block of the level test but not the intermediate one.
By the end
By the end, the team combines data from several tables, summarises information with pivot tables and prepares its reports in a fraction of the time.
What you will learn
- Module 1
Filters and advanced formatting
- Advanced and custom filters
- Conditional formatting to spot data at a glance
- Module 2
Logical and conditional functions
- IF, AND, OR
- COUNTIF and SUMIF
- Module 3
Lookups
- VLOOKUP with exact match
- Common errors and how to avoid them
- Module 4
Tables and pivot tables
- Excel tables that grow on their own
- Pivot tables to summarise thousands of rows in a few clicks
- Pivot charts
- Module 5
Productivity tools
- Shortcuts and tricks that save time every day
- Getting data ready for analysis
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.
What if the group has different levels?
Before the course everyone takes the level test and we form the groups so that everyone makes the most of the hours.
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
Advanced Excel
Excel is your main tool and you want to master every detail.
- 12 h
- With FUNDAE, from €479
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?