EXCEL INITIATION TRAINING in E-LEARNING

is offered to anyone wishing to master the basic functionalities of Excel

to produce and manage simple tables for professional use.


It is based on the ENI certification reference system which allows you to enhance your level of mastery of the software.


The e-learning course allows you to follow your training independently

while benefiting from individualized support with the trainer.


ENI training and certification.

Duration: 16 h or 26 h depending on the length of tutoring chosen.

100% remote course, with individual tutoring.

Eligible for CPF and other possible funding.

Price: from €580.00, certification included.

TRAINING STRENGTHS


  • Individual training in autonomy combining e-learning and individualized support.
  • Unlimited access to the platform..
  • Includes passing the ENI certification remotely.
  • Your trainer accompanies you for the preparation of the exam.


TARGET SKILLS & PEDAGOGICAL OBJECTIVE

Content intended for anyone wishing to master the basic functionalities in Excel in order to use it independently on a daily basis.


At the end of the training, the trainee will be able to:


  • Personalize your work environment.
  • Create tables with basic Excel formulas
  • Manage data tables and perform sorting.
  • Design simple data analysis charts.


TRAINING CONTENT

Based on the certification reference system, it will be adapted to the level of the learner.

PROGRAM


Discover Excel

  • Discovery of the spreadsheet
  • General information on the Excel environment
  • The File tab
  • Opening a workbook

Create and customize a workbook in Excel

  • Create and save your workbook
  • Name a sheet (tab) and assign it a color
  • Inserting, deleting sheets
  • Moving, Copying, and Hiding a Sheet
  • Window management
  • Moving in a workbook.

Performing simple calculations and formatting data in Excel

  • Entering data into Excel
  • Editing cell content
  • Selecting and deleting cells
  • Undoing and redoing an action
  • Entering a calculation formula
  • Absolute reference and relative reference
  • Calculating a sum or other simple statistic
  • Calculating a percentage
  • Copy to adjacent or non-adjacent cells
  • Simple number formats
  • Become familiar with the Excel feature wizard and help

Use and sort lists with Excel (data table)

  • Creating a data list type table
  • Using Flash Fill
  • Automatic sorts and filters
  • Automatic calculations in an Excel table

Presentation and formatting of a table in Excel

  • Display zoom / full screen mode
  • Column width / row height
  • Insertion / deletion of rows, columns
  • Cell format: font, color, alignment, border
  • Displaying multiple rows in a cell.
  • Copy the formatting of a cell
  • Orientation
  • Simple conditional formatting
  • Use themes and styles.

Make a simple graph

  • Chart type selection tool
  • Creating and moving a chart
  • Formatting
  • Editing Chart Text Elements

Print an Excel workbook

  • Layout
  • Titles repeated in print
  • Hiding Sheet Items
  • Print area
  • page break
  • Header and footer
  • Preview and print


Practical exercises throughout the training to assess what has been learned.


ENI CERTIFICATION AT THE END OF 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 be done remotely by videoconference.

The training consists of videos for theoretical contributions as well as practical exercises in the software (duration 11 hours).

Individual tutoring is carried out over 2-hour sessions by videoconference, in order to accompany you on the points requiring further study and answer your questions.

MCQs for the evaluation of prior learning are also offered during training.

Course materials will be provided.

A time of "debriefing" as well as the passage of the ENI certification (compulsory) are planned at the end of the training.

Location: national and international.

Duration: 16h or 26h depending on the formula chosen, including individual tutoring and passing the ENI certification.

Tutoring sessions will be planned with the learner.


Thishe training is open to anyone who is new to Excel.

It is necessary to be familiar with the use of Windows and to have a PC equipped with Excel as well as a stable internet connection for the online training.

Individual remote tutoring requires that you have a videoconference solution (Skype, Teams, GoogleMeet).of


Sign-up sheets.

Traceability of connections and route.

Put into practice through exercises.

Time for oral exchange during tutoring sessions.

Intermediate quizzes.

Hot evaluation at the end of the training and cold evaluation after 60 days, satisfaction survey.
Certification 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 trainee in the best conditions, the latter will contact a disability partner to arrange an adapted environment.

Other e-learning courses with individual tutoring

Share by: