Excel - Managing Data Lists

Inter-company training

Who is the training for?

All public

Duration

3,50 hours(s)

Language(s) of service

EN

Prerequisites

  • Basic Excel knowledge

Goals

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

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…

These courses might interest you