Definition
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.
Target audience
This course is designed to train advanced users involved in complex accounting, financial or scientific applications.
Objectives
Master several complex functions of the program such as data consolidation, filters (and thus the notion of database), cross tables, etc ...
progress
One week at half time, maximum 6 participants per class
Prerequisites for this training
Windows, Excel Base
Teaching method
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.
Course content
-
Advanced functions (SUM, NUMBER, SEARCH, INDEX)
-
Nested functions (IF nested, AND, OR)
-
Target values
-
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