Formation Excel initiation en présentiel à domicile

Get in touch

555-555-5555

mymail@mailservice.com

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.

See on MonCompteFormation Excel initiation face-to-face at home

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.

ENI certification reference

TRAINING ORGANIZATION

Méthode pédagogique et moyens techniques

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.

Modalités, durée et lieu

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.

Public visé Prérequis

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

Suivi et évaluation des résultats

Attendance sheets.

Oral discussion time and quiz, m

are in situation.

Situation de handicap

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 face-to-face individual courses at home

E-learning course with individual tutoring

Back to training homepage

ABOUT

Muriel ROUSSEAU has been an independent assistant secretary since 2017 and a trainer since 2018.

The Muriel Rousseau Formation organization was born from the observation of the scarcity of skills development training directly related to the profession.

Requests are recurring from independent secretaries when they are launched

and the answers are not necessarily accessible.

Dedicated training provides knowledge of the essential steps and regulations for settling in.

After having undertaken a quality approach, this organization is referenced by the financing organizations, certifying the respect of the quality required by the latter and also allowing support for your training through various financings.

CONTACT

Muriel Rousseau

Head office: 49220 Le Lion d'Angers - FRANCE

Contact: 06 19 73 17 82 or 02 41 25 20 08

Email: contact@murielrousseauformation.fr

Organization registered with the Direccte under number 52490349849

News Contact us Nos formations Legal Notice and Privacy Policy Home page

https://my.website-editor.net/preview/2e0c7ee7a35443aca306340120a25c73?t=1731513536834?showCookieNotification=true&cookieNotificationLanguage=5&device=desktopAfin de vous offrir une expérience en ligne optimale, ce site web utilise des cookies. Choisissez vos options.