Managing large volumes of data with Microsoft Excel
- Next date
- 18.05.2026
- Duration
- 1 day
- Level
- Basic
- Price
- €890 per person plus VAT
- Location
- Online, on site
- In-house available
- Yes
Summary
Microsoft Excel lets you manage and analyse large volumes of data. In this seminar you learn how to import data from different sources and then filter, sort and clean it. You also learn to build pivot tables and charts that make your data visible and readable, and you pick up tips and tricks for professional reports and dashboards in Excel.
Importing and cleaning data
An introduction to importing data from different sources (text files, web pages, databases). Filters, sorting, conditional formatting and removing duplicates. Formulas and functions for calculating and transforming data (SUM, COUNT, AVERAGE, IF, VLOOKUP)
Pivot tables and charts
Building and adjusting pivot tables and charts to summarise and analyse data. Grouping, segmenting, slicers and timelines. Calculated fields and items for measures of your own
Reports and dashboards
Building and designing professional reports and dashboards in Excel. Sparklines, charts, tables and shapes for showing data. Hyperlinks, buttons and macros for interaction and automation
Learning objectives
After completing the course you will be able to …
- you can import data from different sources into Excel and clean it
- you are at home with the basic functions and formulas for calculating and transforming data
- you can build and adjust pivot tables and charts to analyse your data and show it
- you can design and present professional reports and dashboards in Excel
Who it is for
Anyone who wants to manage and analyse large volumes of data — in particular people who already work with Microsoft applications.
What is included
Certified, experienced trainers. Personal attention: at most 12 participants per trainer. Online course with no technical requirements
Interested? Book the course now
Managing large volumes of data with Microsoft Excel
Das Formular wird geladen …
You might also be interested in these courses
Let's talk about your project.
Tell us what you have in mind. Your message goes straight to our team.
Daniel Tölgyesi
CEO
Loading the form …