Des millions de personnes utilisent Excel au quotidien, mais beaucoup n'ont jamais suivi de formation. Dans cette série, nous examinons les aspects les plus couramment utilisés du logiciel, des bases telles que la création de calculs, le tri, le filtrage et l'ajout de graphiques, aux niveaux intermédiaires tels que les fonctions de recherche, les fonctions logiques, les fonctions de texte, les tableaux, les tableaux croisés dynamiques et la visualisation des données avec des cartes, pour terminer par des sujets plus avancés tels que la consolidation des données, l'analyse de sensibilité, l'analyse What If, l'audit, la gestion des erreurs et la protection et la création de tableaux de bord. Toutes les sessions durent une heure et sont complétées par des exercices pratiques et des notes écrites.
This one-hour session is an essential for any Excel user that has never had formal training or is a bit...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...
Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour...
This one-hour session explores fundamental Excel skills that every user should benefit from including...
One of the most used features of Excel is the ability to visualise data with charts, and this session...
Learn how to get the most out of Microsoft Excel. In this course, you will learn how to automatically...
Logical functions in Excel allow you to have the program make decisions based on criteria you specify....
Every Excel user knows that VLOOKUP is a tricky function to manage, but there are alternatives few people...
Auditing tools allow users to problem solve formulas and ensure accuracy and error handling is an essential...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...
This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second...
This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...
In the final Pivot Tables session we conclude our training on this subject by discovering how the same...
Excel has many functions dedicated to dates and times, for example, to “date stamp” an invoice...
Excel has a number of tools that allow predictions to be made depending on several variables. This can...
If your role involves combining sets of data that span several periods of time, it can be tricky if they...
Because of Excel’s tabular format a lot of people believe that they are already familiar with tables,...
Excel added a new feature a few years ago that makes it super easy to fill lists of things in a different...
Excel, and indeed all of Microsoft 365, has recently been upgraded with AI-powered tools. This Hints...
In this session we discover how a simple Pivot Table and Chart can be graphically filtered to show your...
In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table...
Tips and tricks for Microsoft Excel including how to insert a chart, format shortcuts and incrementing...
Sensitivity analysis is a process by which different results can be predicted according to a number of...
Excel has a number of functions specific to text rather than numbers. In this one-hour session we look...