Data analysis and scenarios
This subject focuses on advanced techniques of data analysis and the use of scenarios in Excel. Students will learn to:
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Analyze tables and lists: Students will learn how to use pivot tables and pivot charts to effectively analyze and visualize large amounts of data. They will learn how to create, customize and interpret pivot tables to gain valuable insights into the data.
Filtering and sorting data: This module teaches advanced techniques for filtering and sorting data. Participants will learn how to apply complex filtering criteria and sort data in multiple levels to extract relevant information quickly and accurately.
Create and use scenarios: Participants will learn how to create and use different scenarios to perform hypothetical analysis. This includes creating what-if analyses to explore the impact of different assumptions and decisions on their data and make informed decisions. These two subjects provide participants with valuable skills to increase and execute their productivity, helping them to make informed decisions in their everyday professional lives.
Switch WhatsApp®"
And you will be forwarded directly to the WhatsApp® app.
