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
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.