Skip to main content

Remote training Excel: Working with lists and tables

Version: Office 365
Duration: Half a day
Price incompany training: € 475 VAT excl./ Terms for incompany training.

Description

Understanding your Excel data

Do you have a huge amount of data? Good! But how to transform it into a manageable whole in order to obtain a comprehensible analysis? In this first part we will focus on converting your list into a table and how to optimise it for a powerful analysis.

Target Group

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

Prerequisites

Participants have completed an introductory Excel course or have the equivalent knowledge.

Content

Lists and tables

  • What is the difference between a list and a table?
  • What are the advantages of tables?
  • Table options: Formatting, banded rows, banded columns, total row, converting to range …
  • Sorting (Default sorting, custom sorting (e.g.: months, weekdays)
  • Filters (Autofilter, Advanced filter, Slicer)
  • Adding calculated fields to a table
  • (Defining a custom table style)
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?