Analyzing your data and using pivottables

Friday
19 June 2020
Veldkant 33
Kontich
09:00 - 17:00
EN NL FR
Monday
17 August 2020
Veldkant 33
Kontich
09:00 - 17:00
NL  Dutch
Monday
17 August 2020
Veldkant 33
Kontich
09:00 - 17:00
FR  French
Monday
19 October 2020
Veldkant 33
Kontich
09:00 - 17:00
NL  Dutch
Monday
21 December 2020
Veldkant 33
Kontich
09:00 - 17:00
NL  Dutch

Tailor-made training

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

Description

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.

Contents

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

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.

Prerequisites

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

Duration

1 day

Prix par participant

340 EUR

E-Learning

60 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