Excel training (Microsoft Office)

Excel training program (expert)

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Excel office training . Our experienced trainers will help you improve and master the Microsoft Office suite Excel software. .

Goal: Perfect your skills on Excel software (Microsoft Office suite).
Create graphs from tables.
Choose the right type of graph for a specific problem, increase the impact of graphs (simulation and analysis).
Customize the environment in Excel and automate tasks.
Discover the usefulness, limits and constraints of VBE macros.
Maintain existing macros and intervene in the code generated by the macro recorder.
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: I often use Excel and I know the advanced features.
Public: Anyone with knowledge of Excel software
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: TOSA, B2i, PCIE, ENI

The objectives of your Microsoft Excel training

Our Excel training is one of our training courses in our office catalog. It will help you to master all the features of Excel software . Among other things, this training will allow you to: perfect your skills in Excel software, create graphs from tables, choose the right type of graph in relation to a specific problem, increase the impact of graphs (simulation analysis), customize the environment in Excel and automate tasks, discover the usefulness, limits and constraints of VBE macros, maintain existing macros and intervene in the code generated by the macro recorder.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

Your Excel training program (Expert)

The content of the Excel training program is organized into 6 major areas, and will be adapted according to your objectives and your needs:


Module 1: Advanced graphics

  • Add elements of analysis and synthesis on a series.
  • Add objects to the graph.
  • Add objects outside Excel to the chart.
  • Create a graph using the 'series' dialog box in the wizard.
  • Create a graph from several tables.
  • Specific graphics (stock market, bubbles, sectors, point clouds, rings, etc.).
  • Create a combined chart.

Module 2: Complex graphics

  • Two-axis graphics.
  • Create a custom template.
  • Create a graph from a large table.
  • Charts and PivotTables.
  • The structure of tables and graphs.

Module 3: Customize Excel to adapt it to your use

  • Define work options.
  • Data validation.
  • Personalized lists.
  • Protections: sheets, filing cabinet ...
  • Edit and create toolbars.
  • Custom displays.
  • Modify the basic Excel model: classeur.xlt.
  • Use the XLSTART directory.

Module 4: Forms and input templates

  • Insert controls into a spreadsheet.
  • Create drop-down lists, check boxes or option buttons.
  • Specify validation criteria for a cell or range of cells.
  • Use formulas as validation criteria.

Module 5: Automate: matrix calculations, mega-formulas and macro-commands

  • Understand the value of matrix calculations.
  • Use matrix functions: FREQUENCY (), SUMPRODUCT () ...
  • Combine the INDEX () and EQUIV (), OFFSET (), INDIRECT () functions.
  • Set up complex and nested formulas.
  • Practice semi-absolute addressing.
  • Perform an audit of its formulas.
  • Record macro commands to automate repetitive tasks.

Module 6: Simple macros

  • Edit a recorded macro.
  • Example of usual macros: printing, sorting ...
  • Concept of procedure.
  • Assign a macro to a button, an object.
  • Assign a macro to a toolbar, a menu.
  • Save a macro in the personal macro folder: Perso.xls.

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Excel training is eligible for the CPF (Personal Training Account) .


excel expert training program

Microsoft Excel in video training, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This Excel training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your Excel training. .