Concerned public
This training is intended for users who have already acquired the basics of the software.
Prerequisites
Master the following concepts:
-
Enter data, format cells, add simple formulas and functions
-
Represent data in graphs
-
Manage list tables (filters, sorts, subtotals, etc.)
Goals
-
Create and customize data in the form of "Tables" (list of data)
-
Create and customize pivot tables and charts
-
Create tables with complex calculations
-
Use advanced Excel features
Indicators of success
Satisfaction rate :
4.8/5
Exam pass rate:
100%
Skills and Abilities
By completing this course, the learner will be able to:
-
transmit and share the produced tables;
-
optimize data entry;
-
integrate more or less complex calculations and calculation functions;
-
improve data formatting;
-
improve the graphical representation of data;
-
print the data in whole or in part;
-
on arrays with large lists of data:
-
exploit the features specific to data tables;
-
use pivot tables (DCT).
Duration and prices
In order to determine the number of hours of training the learner needs to reach the target level, we will ask him to take a quick placement test in our center.
This training requires 20 hours.
Either the session:
Group
Individual
480 €
tax included
880 €
tax included
Exam registration fees are included in the price shown.
Registration for the session
To register for the next training session, please contact us directly by phone (01 84 21 48 56), by email (contact@institutevolution.com) or via the chat (bottom right of the screen). Please specify the desired training action.
Organization of the session
Face-to-face learning with an experienced trainer, in small groups (max 12 apprentices) which allow individualization of the course.
The teaching materials used are as follows: computer, whiteboard and video projector.
All our sessions take place face-to-face in our training center in La Courneuve.
For individual training sessions, we define the schedules according to your availability.
For group sessions, please contact us to find out the dates of the next sessions.
Allow 2 to 4 weeks between your registration and the start of the training.
Evaluation methods
-
Evaluation at the end of training.
-
Evolution Institute training certificate.
Description of the tests
Excel office automation certification by TOSA, ENI or ICDL.
This is a certification of transversal skills, which can be used in various professional situations and are essential for the exercise of many professions and positions which include tasks related to the use of the Excel spreadsheet.
Accessibility for people with disabilities
Our premises meet ERP accessibility standards. For any verification concerning the accessibility of the premises, please contact the disability referent Jawhar MOKNI (contact@institutevolution.com).
You can also view our Public Accessibility Registry here.