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.

exe-101

Become familiar with the essential features of Excel

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)

 

3 hours

English - French

Beginner

125$ per pers.
exe-102

Master calculations, formulas, and basic functions of Excel

Goals

+

With this training, you will be able to:

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

3 hours

English - French

Beginner

125$ per pers.
exe-103

Discover the basics of formatting and page layout in Excel

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

3 hours

English - French

Beginner

125$ per pers.
exe-202

Learn how to use Excel to manage your data lists efficiently

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)

3 hours

English - French

Intermediate

125$ per pers.
exe-203

Show your Data Graphically in a Clear and Precise Way

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

3 hours

English - French

Intermediate

125$ per pers.
exe-301

Discover all the Possibilities offered by Excel Built-In Functions

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

6 hours

English - French

Advanced

250$ per pers.
exe-302

Take Full Advantage of Excel PivotTables

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

3 hours

English - French

Advanced

125$ per pers.
exe-303

Simplify the use of Excel by automating your actions

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

3 hours

English - French

Advanced

125$ per pers.

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

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