Custom number format
Management of hours and their formats
Custom lists

Grouped histogram combined with stacked histogram
Using the shifted function in a graph
Enriching a graph with control buttons to make it more dynamic

Nesting of functions (index function with
Equiv, Shift function, Indirect …) Matrix formulas (Transpose, Sumprod, If in matrix …)
Complex nesting of date functions
Other examples of nesting of functions for complex needs

Sorting with a specific order
Sorting with conditional formatting
Advanced filter with specific criteria

Cascading drop-down menu
Validation rules with formulas (no duplicate, Uppercase, etc.)
Specific validation options

Customization of icon sets, color shades, etc.
Use of functions under conditions

Target value
Solver
Scenario management

Button, Drop-down menu, checkbox…
Parameters specific to the controls
Binding of controls with calculation formulas

Workshop: setting up a form