The pivot table training gives you the method to efficiently analyze large volumes of Excel data. In one intensive half day, you learn to filter, build a pivot table, configure value fields, create pivot charts and use slicers and timelines to dynamically drive your analyses. A central skill in analytical roles in French speaking Switzerland.
Make your Excel data speak in a few clicks with pivot tables
For profiles based in Geneva or Lausanne, the pivot table is the most powerful and fastest Excel analysis tool. This Excel training centers on operational practice: summarizing sales by product and month, breaking down a budget by department, analyzing visitor traffic by customer segment. You wrap up the training with reflexes usable the next day and course materials to dig deeper.
Module 1: Filtering and extracting data
Module 2: Inserting a pivot table
Module 3: Field settings
Module 4: Pivot Charts
Module 5: Using Slicers and Timelines
The pivot table is, hands down, the most powerful Excel analysis tool. In a few clicks, it transforms a large data table into a multidimensional summary: sales by product and region, headcount by department and age range, expenses by supplier and month. The pivot table training gives you this method in an intensive half day.
The stake is concrete: knowing pivot tables saves hours on every recurring analysis and radically changes how you approach a data file. It is a pivotal skill that recruiters and managers expect in any analytical role.
The training gives a central place to building the pivot table. You learn to choose the right source range, structure fields in rows, columns, values and filters, and understand the aggregation logic that turns raw data into a summary. These reflexes are essential to produce reliable and readable analyses.
The goal is not to know all the options by heart but to develop a method: what do I want to show, what are my analysis axes, what value to measure. The Excel pivot table then flows naturally from this reflection.
A pivot table is not just used to count or sum. The training covers advanced value field settings: average, standard deviation, count, percentage of total, percentage by row or column, difference from another item. These options turn a basic pivot table into a rich analysis tool.
You also see how to add calculated fields directly inside the pivot table to create custom indicators without modifying the source table.
Beyond the table itself, the training covers pivot charts linked to the pivot table, which automatically update when the analysis changes. Slicers let you filter one or several pivot tables in a click, turning a static analysis into an interactive dashboard.
Timelines are the date version of slicers, particularly useful to dynamically drive a pivot table over a time range. These interactive tools change the analysis experience for the file reader.
The pivot table training is designed for management controllers, analysts, reporting managers, HR staff, self employed professionals and any Excel users who handle data and want to analyze it efficiently. Regular Excel use and knowledge of basic functions are required.
At our ITTA centers in Carouge and Le Flon, this Excel data analysis training runs as an intensive half day with an expert instructor and a small group to ensure personalized follow up. You work on real data, build your own pivot tables and leave with course materials.
What is an Excel pivot table?
It is an Excel tool that automatically summarizes a large data table along chosen axes: rows, columns, values, filters. Ideal to analyze without complex formulas.
What are slicers used for in a pivot table?
Slicers let you filter a pivot table by clicking on visual buttons. Useful to turn a static table into an interactive analysis.
What is the difference between a pivot table and a regular table?
A regular table shows data as is. A pivot table summarizes it along chosen axes with automatic aggregation (sum, average, count).
Do I need to know Excel formulas to build a pivot table?
Regular Excel use is enough. Pivot tables do not require advanced formulas, they replace them in most simple analyses.
What is an Excel timeline?
It is an interactive date filter for pivot tables, letting you navigate between years, quarters, months or days in a single click.
Is this training held in Geneva?
Yes, the training takes place at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.
What is the natural next step after this pivot table training?
The Excel Dashboards course to build complete dashboards, or the Excel Preparing for Data Analysis course to better structure sources before analysis.
Analyst, controlling, finance, marketing, operations profiles regularly analyzing large data volumes in Excel. In Geneva and Lausanne, the course welcomes participants from international organizations, banking, consulting and growing SMEs. No specific prerequisite is required other than a concrete willingness to progress on the subject.
You leave with an operational mastery of the fundamentals, reusable canvases on your concrete cases, a structured action plan for the weeks that follow. Many participants report a visible effect from the first week back, with sustainable anchoring over four to six weeks of regular practice. The course combines short theory inputs, practical exercises on your real situations and personalized trainer debrief.
An analyst moving from 3-hour manual consolidation to 5-minute pivot table. A controller producing 12-month budget analyses in clicks. A salesperson analyzing sales by product, region and quarter simultaneously. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.
Combines well with Excel Fundamentals, Excel Dashboards, PowerQuery for data preparation. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.
Pivot tables remain the most used data analysis tool in business, accessible without technical background. Recent evolutions (slicers, timelines, Power Pivot measures) considerably modernize capabilities. This training targets profiles wanting to professionalize their data analysis.
Most participants report a noticeable effect from the first week of return, with deeper anchoring over four to six weeks of regular practice on real files. The course closes with a personalized practice plan calibrated on your professional context.
The features covered are used daily by millions of professionals across Geneva and Lausanne organizations. Mastery transforms repetitive work into efficient routine. This training relies on real cases and offers an outfitted approach calibrated for the 2025-2026 evolutions of the platform.
At ITTA centers in Geneva and Lausanne, this course runs in a small group with an expert trainer and a format alternating concise theory, practical exercises and personalized debrief. Group confidentiality is explicit and held. Each participant arrives with a real case and leaves with an action plan calibrated to their context. The course integrates recent evolutions of the domain (digital tools, hybrid formats, 2025-2026 practices) without losing focus on fundamentals.
Is Power Pivot addressed?
Yes, Power Pivot is introduced for advanced users.
Slicers and timelines treated?
Yes, treated in depth.
Personal data?
Yes, each participant can bring real data.
Where do sessions take place?
ITTA has three centers in French speaking Switzerland: in Geneva (Carouge, Route des Jeunes 35), in Lausanne at the Flon (Rue des Cotes de Montbenon 16) and at Lausanne Mon-Repos (Avenue de Mon-repos 24). The training is also available in virtual classroom.
Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00
ITTA
Route des jeunes 35
1227 Carouge, Suisse
Monday to Friday, from 8:30 am to 06:00 pm.
