Live Training Microsoft Excel - Useful Excel functions for data analysis
- 0h 50 min
- Viewed 756 times
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:
- 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.
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!
DiLeaP AI: THIS MIGHT BE HELPFUL
Live Training Microsoft Power BI - In-Depth Data Analysis with Power BI Desktop
In this course, we discuss how to create relationships between your tables, how to create your own measures to perform more complex calculations using the Data Analysis Expressions (DAX) language, and how to analyze your data.
- 8 Views