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.
 
 

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

Maintain correct data lists

  • Difference between a list and a table (and switching between them)
  • Creation of a correct data list
  • Explore the functionalities of a data list
  • Draw up a data list and its additional parameters (alternating rows/columns, etc.)
  • Sort a data list by one or more columns
  • Filter a data list using the autofilter
  • Filter a data list with the advanced filter
  • Secure data entry with data validation rules

Analyzing a data list with PivotTables

  • Analyzing a data list using conditional formatting
  • Design and customize a pivot table
  • Group values in a pivot table (for dates, figures, texts)
  • The layout of a pivot table (with predefined or custom styles).
  • Add new fields in a PivotTable
  • The formatting of a (numeric) field in a pivot table
  • General formatting settings of a pivot table
  • The display options on numeric fields: as % of the total, etc.
  • Use slicers to filter in a pivot table

Chart attached to a pivot table

  • Quickly create a (pivot) chart based on a pivot table
  • Changing a PivotChart

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

E-Learning

95 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