OBJECTIVES
Master the features to manage a list of information in an Excel spreadsheet and create a pivot table (or pivot table)
PUBLIC
Anyone having to manage a list (or a database) with Excel
REQUIREMENTS
Knowledge of the basic features of Excel
PROGRAM
Database concept
Definition
Creation
Management of a database
Simple filters and advanced filters
Tris
Research (criteria)
Extraction: in the same worksheet, in another spreadsheet
Deleting duplicates
Calculations on a database
Subtotals
Pivot Tables (TCD or Pivot Tables)
Creating and editing a double-entry table
The crosstab assistant
The filters
The options
Groups
Update a PivotTable
EDUCATIONAL TOOLS
Presentations
Exercises
Practical cases
Good to know
DURATION
0.5 days
Organizer
Reval
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
