Analyzing your data and using pivottables
6 June 2024
Kontich
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
PivotTables
•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.