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.
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:
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
45-min Distance Learning (and/or its video recording)
1 Course Knowledge Validation Quiz
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!