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…

Kontakt fir dës Formatioun

House of Training

Dës Formatioune kéinten Iech interesséieren

EN
Dag
Excel 2016 - Pivot Tables
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Spreadsheet-Logiciel - Logiciel Excel
22.05.2024
FR
Dag
Excel - Productivité
Blended-Learning
Logiciel - Logiciel Content Management Entreprise - Spreadsheet-Logiciel - Logiciel Excel
06.05.2024