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.
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
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
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
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
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
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
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
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
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
Subscribe to our newsletter !
Subscribe to our newsletter to make your work easier and to keep yourself updated on Sylbert news