Microsoft Excel tailored to your objectives

The objectives of the training

Adapter sa pratique d'EXCEL à son environnement de travail pour être plus à l'aise dans l'utilisation et augmenter sa performance

Educational objectives

The objectives will be adapted according to the learner's initial level, from beginner to expert.
At the end of the training, learners will be able to (depending on their objectives):
• Understand the Excel work environment
• Create simple tables with or without calculations
• Use formulas and functions
• Combine charts
• Create Pivot Tables
• Manage data
• Simulate calculations and perform a complete summary between different tables
• Macros
• Adapt tools to your daily life

Training program

Getting to Know the Spreadsheet · General Information about the Environment · The File Ribbon · Opening a Workbook · Managing Windows · Moving Within a Workbook · Entering Data · Editing Cell Contents · Selecting and Deleting Cells · Undoing and Redoing an Action · Saving a Workbook · The "Tell Me Box": A Tool to Help You Perform Actions** Performing Your First Calculations · Entering a Calculation Formula · Calculating a Sum or Other Simple Statistics · Calculating a Percentage Absolute Reference in a Formula · Copying to Adjacent Cells · Copying to Non-Adjacent Cells Presenting Data · Simple Number Formats · Font and Size · Cell Alignment Cell Color · Cell Borders · Using Themes and Styles for Formatting · Screenshot Managing Cells · Display Zoom Full Screen Mode* · Column Width / Row Height Inserting / Deleting Rows, Columns, etc. · Moving Cells Quickly Copying Cell Formatting · Merging Cells · Orientation · Displaying Multiple Rows in a Cell · Copying Calculation Results Printing and Distributing a Workbook · Page Layout Previewing and Printing · Repeating Column/Row Titles on Printing · Hiding Sheet Elements · Print Area · Page Break · Header and Footer · Presenting an Online Table Presenting Figures with Simple Charts · Chart Type Selection Tool · Creating and Moving a Chart · Styles and Layouts · Selecting and Formatting Chart Elements · Editing Chart Text Elements · Legend and Plot Area Advanced Formulas and Functions · Review The concept of relative/absolute references ($) · Naming cells and using names in formulas · Lookup functions, Conditional functions (if - and - or...), Conditional statistical functions, Date and time calculation functions · Conditional formatting · Multi-sheet calculations Data hierarchy using outline view · Using outline symbols · Structuring data (creating, modifying, deleting an outline) · Using outline view Advanced data list features · Using instant fill · Custom filters, Filtering data using slicers · Empty and duplicate values · Criteria area, Filtering and copying rows by criteria area, Statistics with criteria area · Presentation of relationships between tables Analyzing using pivot tables · Concept and creation of pivot tables · Pivot table selection tool · Analysis magnifier Quick Guide · Editing a Pivot Table · Selecting/Copying/Moving/Deleting a Pivot Table · Layout/Formatting a Pivot Table · Slicers or Segmenters · Inserting a Timeline Complex Charts · Reviewing Chart Design · Using the Selection Wizard* · Adding an Item and a Series · Changing the Chart Type on a Series, Managing Axes · Sparkline or Trendline Charts · Pivot Chart · Sunburst Charts

Teaching methods and means

Practical workshop for creating and manipulating data sheets. A computer will be made available to the trainee if needed. Theoretical input. Concrete examples. Tutorials, systematic practical application.

Assessment methods

The achievement of objectives is assessed during the training through a simulation-based assessment. This allows us to measure the achievement of professional objectives based on the objectives defined by the program. These achievements will be confirmed by a certification for certified training courses. Before the training or at the beginning of the training, a level assessment or placement test is conducted. Midway through and at the end of the training, each trainee completes a training evaluation questionnaire designed to improve our services through a quality approach. These achievements will be confirmed by the TOSA EXCEL certification registered on September 14, 2020 under code RS5252 for all certified training courses (mandatory and included in the price for all CPF orders). Approximately one month after the end of the training, a cold questionnaire is sent to collect feedback after the training has been implemented.

Who is this training for?

Open to all.
No prerequisites; our courses are tailored to your level (neophyte, beginner, intermediate, advanced, and expert) based on your initial test.
For anyone with a disability, please contact us to learn about the accessibility requirements for this course and to discuss with us whether any adaptations to the course are necessary.

Duration :

Adapted to your project

Dates:

Continuous start

Training methods:

Training programs that adapt to your goals, your constraints, and your learning style! All our training programs are available individually or in groups, depending on your needs.

Face-to-face

Face-to-face sessions with a trainer, at our premises or within your organization. Ideal for encouraging interaction and practical scenarios.

Synchronous distance learning

Online training, delivered live by a trainer, from your home or workplace. Perfect for gaining flexibility while maintaining personalized support.

TOSA Certification:

The TOSA certification allows you to showcase your skills in digital tools. It strengthens the credibility of your professional profile and provides concrete proof of mastery, useful for both internal advancement and job searches. The test is a 60-minute test, comprising 35 questions in the form of multiple-choice questions or practical exercises. The final score is between 1 and 1000, which allows you to assess the candidate's skill level, from beginner to expert. This certification is recognized and eligible for the Personal Training Account (CPF).

Demander un devis

Télécharger le programme