Analyzing your data and using pivottables

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.


Like most Excel users, you probably work with lists very often. Then you are probably familiar with the basic features for using lists. Yet there is a lot more functionality there, that you are probably not aware of and that could save you a lot of time. In this module you will learn all the finer points of working with and analysing lists of data.


Working with Lists and Tables

•What is a list or table in Excel?
•What is the difference between a table and a database? (Excel Access)
•Defining a table
•Selecting table styles using the ribbon
•The contextual ‘Table tools’ tab
•Defining your own table style
•Formatting a table: banded rows, banded columns, show totals
•Sorting a table
•Filtering a table using autofilter
•Filtering a table using the advanced filter
•Converting a table back to a range


•The various components of a PivotTable: Filter Fields, Row Fields, Column Fields and Values
•Creating a PivotTable
•Formatting a PivotTable and creating PivotTable Styles
•View and hide subtotals at the top/bottom
•Calculating in a pivottable: sum, count, average, ...
•Formatting calculations: Number of decimals
•Viewing calculations differently: % relative to total, % relative to row total …
•Grouping data: text, data, numbers
•Analysing data from an external database using a PivotTable

Target audience

This course is addressed to good basic users, who wish to explore Excel further by learning a number of best practices in their usage.


You have completed the Excel introduction training course or you have a comparable level of knowledge.


1 day


90 EUR
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading