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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!