Analyzing your data and using pivottables

Friday
22 November 2019
Villermontstraat 9
Kontich
09:00 - 17:00
EN NL FR

Tailor-made training

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
Iedere organisatie werkt op een andere manier en geen enkele werknemer is hetzelfde. Wij bieden al onze opleidingen ook op maat van jouw organisatie.
Continue reading