Question: This assignment may be completed in groups of four or five. You will prepare an Excel Workbook for an existing or fictional organization of your
This assignment may be completed in groups of four or five. You will prepare an Excel Workbook for an existing or fictional organization of your choice, presenting company information and statistics such as inventory, human resources, sales and revenue, budgets, and financial analysis and forecasting. Use the following website to get your data:
Yahoo Finance - Stock Market Live, Quotes, Business & Finance News
Statistics Canada: Canada's national statistical agency (statcan.gc.ca)
Find Open Datasets and Machine Learning Projects | Kaggle
Free Public Data Sets For Analysis | Tableau
Create and submit an Excel Workbook with four Excel Worksheets. The list below explains what should be in each worksheet of your Excel workbook: Include at least three worksheets with distinct/different data sets, properly formatted, labeled, and titled. At least five columns and 20 rows of data are in each worksheet. Include three different types of charts, properly formatted, labeled, and titled. Include a documentation worksheet (List team members, select company overview and data source, and describe the analysis. Use conditional formatting on at least three worksheets Use at least five functions such as AVERAGE, MAX, MIN, COUNT, SUM, PMT, CUMPRINC, Complex formula, etc. use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
