Select an organization or publicly-traded company and locate a relevant data set (sales, revenue, etc.). Apply the concepts covered during the week( SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS)to a use case with real-world data for a business or organization.
Provide a brief explanation of your data, the business or organization, and the use case. If you are uncertain of the data or organization to use for this assignment, please contact me.
Once you have chosen a data set and organization, create an Excel file in which you apply functions to demonstrate the use case. On a separate sheet in the Excel file, write a brief overview and summary in which you: