Excel from Essentials to Advanced
From structuring spreadsheets to mastering formulas, pivot tables and Power Query.
A hands-on programme that takes participants from the basics to an advanced level of Excel, with real exercises and a final project applied to each company's working context.
For people who work in Excel every day.
This programme was created for people who use Excel daily without getting real value from the tool. It covers everything from organising data correctly to advanced functions and a first approach to Power Query.
- Administrative and back office professionals
- Finance, accounting and billing teams
- Sales and customer service teams working with reports and listings
- Operations, logistics, stock and production
- Human resources and management support
- Any employee who produces or maintains Excel reports
In most companies Excel is used superficially: disorganised sheets, duplicated data, fragile formulas and reports rebuilt by hand every month.
The cost is invisible but high: lost hours, calculation errors, information reaching management late, and dependency on the one or two people who understand the files.
The programme fixes the foundations and moves on to conditional functions, lookup functions, pivot tables and Power Query, so every participant works faster and with fewer errors.
Basic computer skills.
Training programme
Structuring and formatting
How to organise data correctly from the start, so everything else works.
Essential formulas
References, operators and the calculation functions used in daily company work.
Conditional and lookup functions
Deciding with formulas and cross-referencing information between different reports and sources.
Pivot tables
Summarising large volumes of data and answering management questions in seconds.
Introduction to Power Query
Importing, cleaning and refreshing data without repeating manual work every month.
The programme runs at a practical pace: every concept is applied immediately in exercises using data similar to the company's own.
At the end, each participant builds a project applied to their own working context, which ensures the content leaves the room already in use.
- Step by step guided exercises
- Working files provided
- Cases applied to the company's reality
- Questions answered in context
- Individual final project
- Good practice checklists
Apriori certificate of attendance
TrainerCarlos Araújo
What the company gains.
What is included in the programme.
- Delivery of the programme, in person or live online
- Support material and exercise files
- Reusable spreadsheet templates
- Applied final project
- Apriori certificate of attendance
- Post-training executive report when contracted as a corporate programme
Master the Excel your work demands.
Enrol in an open class or request an in company proposal with exercises built on your own company's data.