Details

Goals

Format a list as a table, use standard and advanced filters, sort a list, use database functions

Prerequisite

Basic Excel knowledge

Contents

Introduction & Format as Table

  • Definition and rules to follow when building a list

  • Freeze panes

  • Remove duplicates

  • Format a list as table

  • Name a table

  • Add a totals row to a table

  • Calculated columns & structured references

Sorts and Filters

  • Sort by values

  • Sort by multiple criteria

  • Sort by colors

  • Autofilter

  • Filter by values

  • Filter by color

  • Advanced Filters

  • Extract data

Database functions

  • Build criteria ranges

  • Use database functions in formulas: DSUM, DAVERAGE, DMAX, DMIN…

Sign up

Next session(s)

Wed. 19 Mar.
cours online 13h30 17h00

Wed. 09 Apr.
cours online 9h00 12h30

Thu. 15 May.
cours online 13h30 17h00

Tue. 27 May.
Online course from 9:00am to 12:30pm

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!