Excel training (Microsoft Office)

Excel training program (advanced)

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 suite Excel software .

Goal: Consolidate your skills on Excel software (Microsoft Office suite).
Use and link multiple sheets from the same workbook or link cells from different sheets and different workbooks.
Create summary tables (summaries).
Operate and organize information lists, synthesize them, obtain statistics.
Learn to communicate and value data and figures.
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 . This training will allow you among other things: to consolidate your skills on Excel software, to use and link several sheets of the same workbook or to link cells of different sheets and different workbooks, to create summary tables (summaries), to use and organize the lists of information, to synthesize them, to obtain statistics, to learn to communicate and to value data and figures.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

The program of your Excel training (Advanced)

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


Module 1: Managing Workbooks

  • Insert, delete, move a sheet inside a workbook.
  • Modify several sheets simultaneously: working group.
  • Link spreadsheets to integrate results.
  • Perform calculations through different sheets.
  • Use the 3D functions (transverse calculations).
  • Protection of cells and filing cabinets.

Module 2: Creating and modifying simple graphics

  • Generate graphs from tables.
  • Choice of abscissa axes, ordered.
  • Modify the presentation.
  • Add text.
  • Selection of cells.
  • Insert a graphic as an object near the table.
  • 3D graphics and 3D view.
  • Add or delete series.
  • Print the graph, table, graph and table.

Module 3: Summary tables (consolidation and cross tables)

  • What can we consolidate?
  • Consolidation of similar tables:
    • with operators
    • with the sum in 3D
    • with position consolidation
  • Consolidation of different tables: consolidation by categories.
  • Links to source data.
  • PivotTables from tables spread over several sheets.
  • Updating tables.

Module 4: Setting up complex formulas

  • The different types of addressing: relative (A1), absolute ($ A $ 1), mixed (A $ 1, $ A1).
  • Use the function assistant, explore the different categories of functions.
  • Name cells, ranges of cells.
  • Calculate statistics: AVERAGE (), NBVAL (), NB (), MEDIAN (), MAX (), RANK () ...
  • Functions concerning numbers: ENT, ROUNDED, TRUNK ...
  • Use names to simplify formulas.
  • Calculate on dates, times: DATE (), DAY (), MONTH (), YEAR () ...
  • Manipulate text: LEFT (); RIGHT (); STXT (); CNUM (); NBCAR () ...
  • CONCATENATE: combine formulas and text in the same cell.

Module 5: Conditional functions

  • Set up simple, complex, nested conditions: IF (), OR (), AND ().
  • The SUM.SI (), NB.SI () functions.
  • Test the content of the cells: ESTVIDE (); ESTTEXT (); ESTNUM () ...
  • Conditional formats.

Module 6: Special functions and simulation tools

  • From a loan schedule: the target value and the scenario manager.
  • Define hypothesis tables with 1 or 2 entries: Data / Table.

Module 7: Research tools

  • Reminder: use the names to simplify the formulas and reminders of the simulation tools.
  • The VLOOKUP function.
  • Determine the relative position of information (EQUIV), locate a value by its position in a matrix (INDEX), nest the INDEX and EQUIV functions.

Module 8: Using a database / list

  • Organize your data.
  • Multi-criteria and personalized sorting.
  • Query a list: automatic and personalized filters.
  • Extract records by elaborate filters.
  • Use the statistical functions of the database: BDSOMME (), BDMOYENNE (), etc.
  • Set up pivot tables in one, two or three dimensions.
  • Display pages, group information.

Module 9: Linking sheets, filtering and extracting data

  • Dynamic simple and complex external links: copy / paste with link.
  • Consolidate tables from the same workbook: three-dimensional formulas.
  • Consolidate tables by Data / Consolidate.
  • Import data using a query: filter, sort, reconcile data ...
  • Distribute the entry among several users and consolidate.

Module 10: PivotTables

  • Implementation of a pivot table.
  • Calculation options.
  • Modify and format the TCD.
  • Hide rows or columns in the crosstab.
  • Group rows or columns in the crosstab.
  • Extract data from the crosstab.
  • Create calculated fields or elements.

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


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