Select an organization or publicly-traded company and locate a relevant data set (sales, revenue, etc.). Apply the concepts covered during the week (COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions) 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.
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:
- Provide an overview of your data, business/organization, and use case
- Analyze the data and give reasoning of why you think it is useful to the business or organization.
- Articulate what Excel functions you have used and apply it to the dataset to demonstrate it.