Analyzing your data and using pivottables
19 June 2020
17 August 2020
17 August 2020
19 October 2020
21 December 2020
Tailor-made trainingWould 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
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.