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


Examples of certification exam results.

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.

ThisThe training is open to anyone witha basic practice of Excel.

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.

A needs assessment is carried out prior to the training in order to determine the feasibility of the training.
If the organization does not have the means to accommodate the intern in the best conditions, it will redirect the intern to a disabled partner to create an adapted environment.

Other e-learning courses with individual tutoring

Share by: