Excel PivotTable Skills Assessment
About this course
A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in data. This practical assessment is designed to evaluate participants' proficiency in Excel PivotTable skills, a powerful tool for data analysis and reporting.
Upon passing the assessment, participants will receive a badge and a certificate that will certify their competency in PivotTable usage, making them stand out in their professional and educational pursuits.
The assessment will be based on real-world scenarios and will require the use of Excel to create PivotTables, analyze data, and slice and dice data to gain insights. Participants will need to demonstrate their ability to create PivotTables accurately, use filters and sorting effectively, create calculated fields to answer business case questions. This assessment will provide a valuable opportunity for participants to validate and improve their Excel PivotTable skills, gaining a competitive edge in their careers.
Download the data and analyze it to answer the business questions.
Business case requirements