Remote training Excel: Working with lists and tables

  • Version: Office 2016/Office 365
  • Duration: Half a day
  • Price open training: € 255 VAT excl. / Cheaper course?

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.

Choose a date and location

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 a list or table in Excel?
  • What is the difference between a table and a database? (Excel <-> Access)
  • Split text quickly with Flash Fill
  • Defining a table
  • Choosing a table style using the ribbon
  • The ‘Table tools’ contextual tab
  • Defining your own table style
  • Formatting a table: banded rows, banded columns, show totals
  • Sorting a table
  • Filtering a table using the autofilter
  • Filtering a table using the advanced filter
  • Filtering a table using slicers
  • Converting a table back to a range
  • Adding calculated fields to a table

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info open training course

The practical info and applicable cancellation conditions related to this open training course.

 

Choose a date and location

€ 255 VAT excl.
Cheaper course?

Would you like to organize this online training/webinar for your employees?

We transform your requirements into the perfect solution.

Request