Cette formation est proposée sous forme de formation à distance. En savoir plus

Description

Objectives
  • Format a list as a table, use standard and advanced filters, sort a list, use database functions
Programme
  • 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…

Prerequisites
  • Basic Excel knowledge

Modalités

Support de cours

Course material will be provided at the beginning of the course.

Lieu
Classe virtuelle
A distance
Calculer l'itinéraire

Sessions et horaires

Télécharger le planning (PDF)

  • mar. 27.09.2022

    13:30 à 17:00

    3H30

    Excel - Managing data lists

    Classe virtuelle