The Excel charts training gives you techniques to turn numerical data into speaking and professional visuals. In one intensive half day, you master choosing the right chart type, visual customization, combo charts and design best practices. A pivotal skill for anyone producing reports or presentations in French speaking Switzerland.
Make your numbers speak with Excel charts that mark the mind
In reporting and analysis roles, knowing how to choose and build the right Excel chart distinguishes a professional deliverable from an amateur one. This Excel training focuses on hands on cases: sales tracking, budget comparison, monthly evolution, distribution by segment. By the end, you take home techniques applicable the next day and a course guide to deepen them.
Module 1: Charts
Module 2: Graphic Objects
Module 3: Graphical analysis of data
An Excel table filled with numbers is rarely read in a meeting. A well designed Excel chart, however, captures attention and conveys the message in a few seconds. The Excel charts training delivers these reflexes in one intensive half day.
The training places significant focus on chart type choice. Column for comparing values across categories, line for tracking an evolution over time, pie for showing distribution as parts, bar for comparisons with long labels, scatter for analyzing a correlation.
A default Excel chart looks like every other default Excel chart. The training details customization techniques that durably change the rendering: consistent color palette, readable labels, optimized axes, titles that speak.
To compare series of different natures (e.g. revenue as bars and margin as line), Excel combo charts are essential. The training shows how to build them and manage a secondary axis.
The training ends with universal visual design best practices applied to Excel charts: lighten the background, remove unnecessary elements, hierarchize visually, choose a primary color and decline it.
The Excel charts training is designed for management controllers, analysts, communicators, sales staff, self employed professionals and anyone producing reports.
In our Carouge and Le Flon centers, ITTA delivers this Excel charts training in an intensive half day with an expert instructor and a limited group. You work on your own data and hold transposable techniques.
How to choose the right Excel chart based on the data?
Column charts to compare, line for evolution, pie for distribution, scatter for correlation.
What is an Excel combo chart?
It is a chart combining two types (e.g. bars + lines) on a single visual to compare series of different natures.
Do I need to know Excel before this charts training?
Yes, regular Excel use is required.
Does the training cover waterfall and funnel charts?
Yes, modern Excel chart types are presented and illustrated.
Is this Excel training held in Geneva?
Yes, at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.
How long to become autonomous on Excel charts?
The essential techniques are acquired in a structured half day.
Which course should follow this Excel charts training?
The Excel Dashboards course to assemble your charts in complete dashboards.
Any Excel user producing reports regularly and wanting to master creation of readable impactful graphics for decision-making. 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 transforming a number table into a speaking chart for committee. A manager producing synthetic Excel dashboards to track team performance. A study officer mastering advanced charts (combined, dual axis, Sparklines). The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.
This training combines well with Excel Dashboards for further reporting, Excel PowerQuery for data preparation, and PowerPoint to integrate graphics in presentation. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.
A poorly chosen chart can transform relevant analysis into confusion. Datavisualization principles (Few, Tufte, Cole Knaflic) are now applied to Excel reporting to produce clear useful charts. This training proposes outfitted approach combining Excel technique and visualization best practices.
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, including milestones and review prompts to ensure the techniques become permanent rather than fading after a few weeks.
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.
Does it cover advanced Excel 365 charts?
Yes, modern charts (maps, funnel, treemap) are presented with use cases.
Do we work on personal data?
Yes, each participant can bring files or use provided sample data.
Does it integrate datavisualization best practices?
Yes, visualization principles (clarity, contrast, chart choice) are integrated.
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.
