Training Theme 

PivotTables are not always suitable for analyzing your data. Learn another approach using functions and conditional formatting to analyze your tables. 

All our trainings, especially on data analysis in Excel, are carried out by our expert trainers. 

Training Objectives 

You need to analyze a data table and understand how Microsoft Excel functions can help you with it. 

At the end of this training, you will know: 

• How to apply a simple formula that meets a desired calculation rule 
• How to use the main statistical and mathematical functions 
• How to  manage conditional calculations 
• How to automate the retrieval of information between tables 
• How to highlight important items by combining formulas and formatting 

Prerequisite and Target Audience 

Target audience: Experienced users of Microsoft Excel, comfortable with the application's analysis tools and wishing to improve their summary methods through functions 
Startup Level: Advanced
Prerequisite: Know the confirmed features of Microsoft Excel, know how to use the application to analyze data 

Means and Methods 

• Virtual classroom: The training is carried out remotely with a virtual classroom tool. Live interaction with a trainer enabling participants to ask questions. 
• Virtual class replay: Recording of a virtual class allowing a complete approach to the application by means of concrete examples of use.
• Documents and other materials: Additional information or educational activities to complement this course.  

Training Content 

45-min Distance Learning (and/or its video recording) 

• Functions if, COUNTIF, VLOOKUP, ... 
• Calculations with dates 
• The matrix calculation 
• Use a formula to apply conditional formatting 

1 Course Knowledge Validation Quiz 

Learn more about Microsoft Excel

The Microsoft Excel spreadsheet application is the ideal tool to connect, summarize and analyze your data. You've probably already used PivotTables to process your data. It's a powerful tool, but it doesn't fit all situations. So, which Microsoft Excel feature to use for your analyses? 

Fortunately for you, the Microsoft 365 solution software has many other possibilities to calculate, summarize, search... your data. These are grouped under the term "Functions" and range from mathematical calculation to statistical function, including conditional formatting formulas. From the simple addition of cells to the most complex function, Microsoft Excel covers all fields in terms of analysis and summary!