Live Training Microsoft Excel - Useful Excel functions for data analysis
PivotTables are not always suitable for analyzing your data. Learn another approach using functions and conditional formatting to analyze your tables.
Description
After taking this course: the analysis, valuation and automatic summary of tables will have no more secrets for you. Learn how to enhance your summaries with automatic and graphical formatting.
All our trainings, especially on the uses of summaries in Excel, are carried out by our expert trainers.
You need to create data summaries easily and quickly.
At the end of this training, you will know:
Target audience: Users who are familiar with the features of Microsoft Excel and want to learn how to showcase their data with PivotTables
Startup Level: Intermediate
Prerequisite: Know the basic features of Microsoft Excel and be able to use the tool independently
45-min Distance Learning (and/or its video recording)
1 Course Knowledge Validation Quiz
If you use Microsoft Excel on a daily basis, you've probably used or heard of PivotTables. Indeed, they are among the most common features of your spreadsheet application.
PivotTables allow you to link multiple data sources, to derive results and make summaries. This type of table allows you to precisely filter and segment your data, which is very useful when you have a lot of data.
Microsoft Excel also allows you to translate your results into graphs, for better readability.