MS Excel - Data Visualization Tools (MSEG)

Microsoft Office, Excel

Learn practical techniques and modern principles for inserting and formatting charts in Excel, plus tools for presenting complex information clearly. The course covers chart choice, style and labels so you can show trends using charts, formatting and infographics.

Hands-on exercises and tips help you build basic and advanced visuals, combine chart types and create reusable templates. Learn to link charts to live data sources, control what displays and improve readability using templates, dynamic data and infographics.

Location, current course term

Brno + online (volitelně)	11/14/2025 - 11/14/2025 CZECH Order
Praha + online (volitelně)	10/20/2025 - 10/20/2025 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• Principles of inserting charts and examples of chart use
1. Chart types and when to use each
2. Data sources for a chart
3. Dynamic sparklines and how to insert them into a cell
4. Formatting sparklines and practical uses

• Chart formatting and editing options
1. Chart style and layout
2. Using themes and templates

• Chart elements depending on the selected type
1. Options for titles, legend, labels, and more
2. Editing and formatting data series and data points

• Combined (combo) charts

• Custom chart templates

• Advanced chart techniques
1. Dynamic data sources
2. Controlling data series display with form controls

• Infographic elements for data presentation
1. Conditional formatting rules to show value strength and trends
2. Using icons, illustrations and shapes as visual indicators

Assumed knowledge:

Basic user-level knowledge of Excel.

Recommended previous course:

MS Excel – Effective data handling for advanced users (MSE2)

Schedule:

1 day (9:00 AM - 5:00 PM )

Course price:

144.00 € ( 174.24 € incl. 21% VAT)

Language: