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

Workshop: Establish an expense report

Import of text and CSV files
Management of international parameters
Formatting of imported data: number format, text format, etc.

Essentials: SUM, AVERAGE, MAX, MIN …
Conditional and logical functions: IF, AND, OR, COUNTIFS, SOMME.SI.ENS …
Dates functions: TODAY, DATE, YEAR DATEDIF …
The calculations and formats of hours
Accounting and financial functions: AMORLIN, VPM, INTER, PRINCPER…

Workshop: Create an amortization or loan schedule

Manage the display of databases: freeze panes, split, new window …
Apply conditional formatting
Format in table
Use sorting and filter (simple and advanced)
Use the subtotal
tool Validation tool data with drop-down menu

Text functions: TEXT, LEFT, STXT, CNUM, etc.
Use the convert tool
Search functions: VLOOKUP, INDEX and MATCH Pivot
tables: Setting up tables, grouping, filter, segment
Use standard graphics or graphics dynamic crosstabs for an accounting or financial analysis
Use the links between sheets or workbooks for inventory work

Workshop: setting up analytical reports and assessments on activities and results

Adapt the result of a calculation via the target value
Perform simulations using the scenario manager
Constraints management using the solver

Workshop: Perform simulations according to customers