Create simple graphs – practice
Turn a table into a graph – practice
Properties of graphs – practice
Stock market chart – practice
Bubble chart – practice
Keyword cloud chart – practice

Formatting cells (reminder)
Pre-programmed cells – Practice
Complete the data with your calculations, create variables
Create a simple calculation and transform it into a variable – practice
Use the functions
The functions and the writing rules
Functions – practice

Reminder on query filters
Combining query filters
Managing priorities between query filters
Using complex operators
Going beyond the limits of complex operators
Combining queries (Minus)
Combining queries (Intersection)
Combining queries (Union)
Usefulness of sub- queries
Create a subquery (InList, ALL)

Add a new request to a document
Automatic
synchronization Manual synchronization
Multi requests in a document: automatic synchronization or not
Delete synchronization
Practice: multi request document and synchronization

Limit of automatic calculations
Benefit of extended automatic syntax in formulas
Use the « where » operator to specify a context
Use the « in » operator to specify a context
Interpretation of the « #VALEURMULTI » error
Calculation context and context d ‘display
Use the « ForAll »
operator Use the « ForEach » operator