Description

Get insight into your Excel data

You have a large amount of data? Great! But how do you turn that into a clear overview so you can move on to a solid analysis? In this Excel training 'Lists and tables' we zoom in on converting your list into a table and optimising it for powerful analysis.

Target audience

Employees who regularly work with data lists in Excel and want to analyse their data.

Prerequisites

Participants have taken an introductory Excel course or have equivalent knowledge.

Contents

Lists and tables

• What's the difference between a range and a table?

• What are the benefits of tables?

• Table options: formatting, banded rows, banded columns, total row, converting to a range

• Sorting: standard sorting, custom sorting (e.g. months, weekdays)

• Filters: AutoFilter, Advanced Filter, Slicer

• Adding calculated fields to a table

• (Defining your own table style)