Welcome to Excel Workout #20!
Difficulty Level:
This week’s challenge is designed to test your knowledge on Consolidate Feature.
Consolidate Feature
The Consolidate feature in Excel is a tool that allows you to combine data from multiple ranges or worksheets into a single summary. It is particularly useful when you have data scattered across different sheets or workbooks and want to analyze or summarize it in a unified manner.
Task
-
Construct an annual report that exhibits an overview of aggregated information pertaining to every Seller throughout the year, encompassing all types of goods, while preserving a link to the source data.
-
The initial data are on sheets 1stQuarter … 4thQuarter.
-
Position the outcome at the start of the spreadsheet (A1 Cell).
Submission
Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.
Period
This workout will be released on Friday June 02, 2023, and the author’s solution will be posted on Wednesday June 7, 2023.
Challenge #20.xlsx (8.3 MB)
Good luck,
Ilgar Zarbaliyev