Formatting a cell
Formatting a table
Reminders on basic formulas: simple calculations, concatenation, etc.
Printing tools

Import of text and CSV files
Management of international parameters
Formatting of imported data
Use the convert tool on an Excel database

Workshop: Implementing your file via external data

The essentials: SUM, AVERAGE, MAX, MIN…
The conditional and logical functions: IF, AND, OR, NB.IF.EN, SUM.IF.EN …
The search functions: VLOOKUP, INDEX and MATCH
the functions of text: TEXT, LEFT, CAPITAL, DELETE …

Dates functions: TODAY, DATE, YEAR, MONTH, DATEDIF …
complex calculations with dates functions MONTH OFFSET, workdays, NB.JOUR.OUVRE (nested functions) …
Use predefined and custom formats pm
The negative hour formats and calculations

Workshop: create an hourly cost management table

Creation of the table structure
The information to be filled in (name, salary, entry date, etc.)
Apply conditional formatting
Format in a table
Sort and filter the employees
set up data validation: date, drop-down menu…
Entry message Entry restriction Alert message

Use the Pivot Tables: grouping, filter, segment
Produce statistics by centers, functions, seniority, salaries …
Calculations on: payroll, average, minimum and maximum salary …
Perform graphic representations: Age pyramid …

Workshop: Create different summary tables