Microsoft 365 trainings

Excel

Excel is a must-have in the workplace and in the Microsoft suite. Calculations, databases, graphs, dashboards, financial modelling… The possibilities to exploit it are multiple. And if the interface seems rather intuitive, this tool requires knowledge and good practices to help you save time and improve your productivity.

97%

of satisfaction

exe-101

Become familiar with the essential features of Excel

Get a quote

Goals

+

With this training, you will be able to:

  • Master the Excel work environment
  • Use quick methods for data entry 
  • Know how to move quickly through a table
  • Manipulate your rows and columns efficiently (insert, delete, show, hide, width and height)

View course outline
exe-102

Master calculations, formulas, and basic functions of Excel

Get a quote

Goals

+

With this training, you will be able to:

  • Understand formulas and master basic mathematical operations ( + – X / )
  • Understand the most used functions (SUM, AVERAGE, NB, NB.SI, etc.)
  • Work with references in formulas
  •  (A5, A$5, $A$5)
  • Apply these calculations on multiple Excel sheets

View course outline
exe-103

Discover the basics of formatting and page layout in Excel

Get a quote

Goals

+

With this training, you will be able to:

  • Use formatting to customize the look and feel of your tables and reports 
  • Improve the layout of your tables and reports for efficient printing
  • Master the most popular conditional formatting options

View course outline
exe-202

Learn how to use Excel to manage your data lists efficiently

Get a quote

Goals

+

With this training, you will be able to:

  • Organize your data lists better and faster 
  • Avoid input errors through data validation (drop-down list, etc.)
  • Use simple or custom sorting and standard or advanced filters 
  • Display and group the main data of a table (Outline)

View course outline
exe-203

Show your Data Graphically in a Clear and Precise Way

Get a quote

Goals

+

With this training, you will be able to:

  • Learn how to choose the right chart based on your data 
  • Illustrate your different reports with graphs 
  • Manipulate all elements of a chart
    (title, legend, etc.) 
  • Add options to your charts
    (secondary axes, trendline, etc.)
  • Save and reuse your custom templates

View course outline
exe-301

Discover all the Possibilities offered by Excel Built-In Functions

Get a quote

Goals

+

With this training, you will be able to:

  • Calculate statistics (IF, AND, OR, SUMIF, AVERAGEIFS…) 
  • Create and modify complex and nested functions
  • Merge values from multiple cells into one
  • Search for a value in another table according to a criterion (VLOOKUP, XLOOKUP, etc.)

View course outline
exe-302

Take Full Advantage of Excel PivotTables

Get a quote

Goals

+

With this training, you will be able to:

  • Analyze and group data
  • Synthesize your data by date or segments
  • Correctly add new data to update a table
  • Make calculations in a PivotTable
  • Have a global overview of the data  in a table and keep it up to date

View course outline
exe-303

Simplify the use of Excel by automating your actions

Get a quote

Goals

+

With this training, you will be able to:

  • Save execution time with the use of macros
  • Automate repetitive tasks to reduce the risk of error
  • Differentiate a relative macro from an absolute macro
  • Associate an icon with a macro
  • Use a macro with multiple workbooks

View course outline

Presentation of the training courses under the skills table

+
Download the table

Would you like more information or to find out which course is right for you?

In addition to your skills Excel…

Our clients testify

What could be better than the opinion of our participants who have experienced our courses.

  • Cette formation sera vraiment utile pour mon travail au quotidien! Non seulement pour la gestion de toutes nos bases et listes de données mais aussi pour la création de budget (avec les sous-totaux, etc.). J'aime vraiment l'approche d'Annie et les exercices pratiques qui permettent vraiment de mieux absorber les nouveaux apprentissages.

    Participant anonyme au cours EXE-202

    See more testimonials

Subscribe to our newsletter !

Subscribe to our newsletter to make your work easier and to keep yourself updated on Sylbert news