TRAINING TO USE EXCEL AUTONOMY in E-LEARNING
allows you to follow your course independently while benefiting from individual tutoring and is based on the ENI certification reference system in order to enhance your level of mastery of the software.
It is open to anyone wishing to acquire a mastery of Excel, more particularly for professional use.
Training, mentoring and certification.
Duration: 16 or 26 hours depending on the tutorial chosen.
100% remotely in e-learning with individualized tutoring.
Eligible for CPF and other funding.
Price: from €580.00 depending on formula,
certification included.
TRAINING STRENGTHS
- Training combining autonomous e-learning and personalized individual tutoring.
- Experienced trainer in office automation for 4 years.
- Includes the passage of the ENI certification remotely and your trainer accompanies you for the preparation of the exam.
TARGET SKILLS & PEDAGOGICAL OBJECTIVE
Content intended for anyone wishing to acquire autonomy in the daily use of Excel, and to certify their level of proficiency.
At the end of the training, the trainee will be able to:
- Control and personalize your work environment.
- Independently design and format an elaborate table.
- Create different types of tables incorporating graphics and images.
- Use conditional formatting.
TRAINING CONTENT
Based on the certification reference system, it will be adapted to the level of the learner.
PROGRAM
Basics revisions in Excel
- Control your environment: the screen, the ribbon and its tabs, the quick access bar, the formula bar.
- Create a table integrating different calculation formulas.
- Insert, delete rows and columns and impact on formulas.
- Move, copy cell content, use incremental copy.
- Apply different formatting.
Create an elaborate table
- Highlight information with conditional formatting.
- Insert a text box, a shape, an image, a Word Art object, a chart.
- Format the cells according to their content: number, thousands separator, currency, percentage.
- Use the average, minimum, maximum, SI functions.
- Sort, filter data.
Manage and format a workbook
- Insert, copy, move or delete a sheet.
- Insert a text box, a shape, an image, a Word Art object, a chart.
- Change margins, layout, preview and print the workbook.
- Add a presentation page.
- Configure headers, footers, page numbering, title repetition.
- Preview and print your workbook.
Practical exercises throughout the training.
Intermediate quiz to assess the points to be deepened.
Passage of the ENI certification at the end of the training
The field of use of certifications in office automation concerns all trades and functions that require the use of software on a workstation and regardless of the sector of activity.
They fit perfectly as the culmination of a large number of training courses, and anyone can apply for certification, whether they are inexperienced or have significant experience of the software concerned.
The exam is based on a solution including both MCQs and real manipulations of the software during scenarios encountered in business. Skills are thus truly assessed and validated.
The exam is adaptive, the level of the questions evolves according to the answers of the candidate in order to refine the evaluation of his score.
There is no pass or fail. The objective is to certify their level of mastery of office software.
Key points assessed:
- The work environment
- Data entry
- Managing workbooks and sheets
- Calculations
- The impression
- Data presentation
- Graphics
- Collaborative work
- Data mining
A preliminary questionnaire will identify the profile of the learner.
The reception will be done remotely by videoconference.
Theoretical contributions and practical exercises will be offered in the form of videos, supported by individual tutoring sessions.
Times for discussions as well as quizzes for the evaluation of acquired knowledge will be offered throughout the training.
Course materials will be provided.
A “debriefing” time is planned at the end of the training.
Location: national and international.
Duration: 16 or 26 hours, depending on the formula chosen, ENI certification included.
Autonomous distance learning.
Remote autonomy training with tutoring sessions to be planned with the learner.
Attendance sheets.
Time for discussion and support via individual tutoring.
Traceability of connections and route tracking.
Hot evaluation at the end of the training and cold evaluation after 60 days, satisfaction survey.
Certification exam at the end of training.