TRAINING TO USE EXCEL IN AUTONOMY (improvement)

face-to-face at home

allows you to benefit from a personalized course and is based on the reference framework of a recognized certification allowing you to enhance your level of mastery of the software.

It is open to anyone wishing to benefit from individualized support and improve their practice to acquire the advanced functionalities of Excel applicable in the professional environment.

ENI training and certification.

Duration: 16 hours.

Individual training face-to-face.

Eligible for CPF and other possible funding.

Tarif : 1 280,00 €, certification incluse.

TRAINING STRENGTHS


  • Tailor-made individual face-to-face training and remote support.
  • Includes passage of the ENI certification at home or in an individual room.
  • 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.
  • Create pivot tables and analysis charts.

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 trainees.
The reception will take place in a dedicated equipped room or at the trainee's home for individual training.
Each participant must have a PC (Windows).
Theoretical contributions will alternate with a practical application based on concrete examples, supported by oral and visual explanations.
Discussion times as well as MCQs for the evaluation of prior learning will be offered to participants throughout the training.
Course materials will be provided.
A “debriefing” time is planned at the end of the training.

Location: Pays de la Loire and nearby surroundings.

Duration: 16 hours, ENI certification included.

Face-to-face training over 2 days, in groups of 2 to 6 people.

Individual face-to-face training at home coupled with distance education, to be planned together.

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

It is necessary to have a PC equipped with the software.

Attendance sheets.
Oral discussion time and quiz, m
 are in situation.
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.
Share by: