Format a cell Format a
table
Print tools

Workshop: Create a call for tenders

Import of text and CSV files
Management of international parameters
Formatting of imported data
Format as a table
Remove duplicates
Use the convert tool

Workshop: Implementing your file via external data

Reminders on the basic
formulas Conditional formulas: IF, AND, OR, NB.SI.ENS, SOMME.SI.ENS …
Search formulas: VLOOKUP, INDEX and MATCH Pivot
tables: setting up tables, grouping, filter, extractions
Creation of a graph for visual synthesis

Table with several hypotheses
Carry out simulations using the scenario manager

Workshop: Perform simulations according to suppliers

Links between sheets and workbooks
Date formulas: TODAY, YEAR, DATE …
Text formulas: LEFT, STXT, CONCATENATE
Create visual alerts: conditional formatting
Create drop-down menus

Workshop: Create a document serving as a dashboard