Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Use formulas in Excel

Use of a referent cell ($)
Reminder on the basic formulas (SUM, AVERAGE, MAX …)
Formulas with condition (IF, NB.SI, SUM.SI …)
Date and time formulas ( TODAY, WEEKDAY …)
Text formulas (SMALL, LEFT, CONCATENATE …)
Search formulas ( VLOOKUP, HLOOKUP )

Workshop: Realization of a summary document with the main Excel formulas

Use formula audit tools

Create named areas and integrate them into formulas
Find antecedents and dependents to formulas
Check formulas for errors
Change the way your workbook is calculated

Select the data to integrate into the graph
Choose a type of graph according to needs (histogram, curve, sector in 2D or 3D)
Define a quick layout for its graph
Add additional information to the graph (axis title, data labels, curve trend …)
Choose the visual aspect of your graphic via the styles

Apply table updates to associated charts
Change the chart type
Move a chart within its workbook
Customize the style of its chart
Integrate a chart into an external document (Word, PowerPoint)

Workshop: Generate a graph according to your needs

The principle of a pivot table
Define which calculation and label fields will be
Select the source of its pivot table
Place the fields to analyze
Apply a style to the pivot table

Integrate multiple calculations
Define grouping and sorting criteria
Insert segments
Integrate custom calculation fields

Workshop: Highlight the desired statistics from your table

Integrate subtotals into a table
Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Enable tracking of changes
Protect your workbook and sheets