Excel - Managing Data Lists

Betribsiwwergräifend Formatioun

U wie riicht sech d'Formatioun?

All Zilgruppen

Dauer

3,50 Stonn(en)

Sprooch(e) vun der Déngschtleeschtung

EN

Nächst Sessioun

Virkenntnisser

  • Basic Excel knowledge

Ziler

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

Inhalt

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

Dës Formatioune kéinten Iech interesséieren