select an organization or publicly-traded company and locate a relevant dataset (sales, revenue, etc.). Apply the concepts covered during the week( left, right, clean, mid functions etc ) 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. ( you can get data from https://www.kaggle.com/)
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.
0 comments