icon icon

Excel charts – data presentation and visualisation

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Clear data highlighting - You will learn to use conditional formatting to spot outliers, exceptions and key values instantly, without manually scanning long tables and dense spreadsheet ranges.

icon

Better chart selection - You will understand how to match the chart type to your message, so you can present comparisons, trends and relationships clearly and avoid misleading visuals.

icon

Faster chart creation - You will practice building column, bar and line charts efficiently and learn keyboard shortcuts that help you prepare reports and visual summaries much faster.

icon

Professional information display - You will improve chart readability, use diagrams and SmartArt effectively, and highlight the most important points so your reports and presentations look polished.

icon

Full control of chart elements - You will master editing plot areas, axes, labels, data series and trendlines, so you can tailor each visualization precisely to the story your data should tell.

icon

Advanced custom charts - You will build custom charts such as Gantt, gauge, thermometer and comparison histograms, helping you present business data in a more engaging and practical way.

icon

Confident visual interpretation - You will see how scale, perspective and grouping shape the viewer's conclusions, which helps you avoid false interpretations and recognize manipulation in charts.

icon

Charts ready for reuse - You will learn how to copy charts into PowerPoint, Word and Outlook and how to print them properly, so they keep their layout, quality and readability everywhere.

Training programme

What are the prerequisites for participating in the training?

icon

Basic Excel skills - You should be comfortable moving around a worksheet, entering and editing data, selecting ranges, and using basic commands on the ribbon and in Excel menus.

icon

Working with data tables - You should know how to prepare a simple table with headers, organize data in rows and columns, and understand what a clean data layout for analysis looks like.

icon

Basic formulas and references - You should understand simple Excel formulas, including basic calculations and cell references, because this will make chart building and data analysis much easier.

icon

Basic Windows operation - You should use Windows confidently, save files, open documents and copy content between applications, so you can work smoothly throughout the training session.