Excel is the spreadsheet of the Microsoft Office suite. This version offers advanced features for use in the areas of accounting and financial programs or any other field where the creation of tables and calculations is important.
This course is designed to train advanced users involved in complex accounting, financial or scientific applications.
Master several complex functions of the program such as data consolidation, filters (and thus the notion of database), cross tables, etc ...
One week at half time, maximum 6 participants per class
Prerequisites for this training
Windows, Excel Base
The "Advanced Excel" course is based on a theoretical support, the practice using exercises related to current professional situations, and a personalized coaching by a trainer. Each participant has a workstation.
Advanced functions (SUM, NUMBER, SEARCH, INDEX)
Nested functions (IF nested, AND, OR)
Databases (basics, data entry, sorting, filters and subtotals)
PivotTables (creation, use, modification, graphics)
The working group
Consolidation by position and category
Attestation / Certificate
Certificate of participation
Certificate if the final test is successfully passed
Level reached on request