EXCEL INITIATION TRAINING in 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 who wishes to acquire a mastery of the basic functionalities of Excel,

essential for professional use.

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 face-to-face training.
  • Includes passage of the ENI certification at home.
  • 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.


Passage of the 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.

Individual face-to-face training at home coupled with distance education, to 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, and of


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 trainee in the best conditions, the latter will contact a disability partner to arrange an adapted environment.