Excel - Managing Data Lists

Formation inter-entreprise

À qui s'adresse la formation?

Tout public

Durée

3,50 heure(s)

Langues(s) de prestation

EN

Prochaine session

Prérequis

  • Basic Excel knowledge

Objectifs

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

Contenu

  • 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…

Contact pour cette formation

House of Training

Ces formations pourraient vous intéresser