Many companies and placement agencies require candidates to have knowledge about Excel as part of their recruitment process. Knowledge of Excel is useful in several fields in various industries, especially data analysis. Read the assigned chapter for the week. Come up with a use case for the concepts covered using real-world data for a business or organization.
In the discussion forum, post a brief explanation of your data, the business or organization, and the use case in the appropriate forum of the message board. You cannot use the same business or dataset as one of your peers. If you are uncertain of the data or organization to use for this assignment, use the discussion forum to brainstorm with your peers.
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.
Use this functions The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS