Excel Project - Analyze Organization

What is the project about?

You need to select an existing North American organization for the project. The organization could be a for-profit or not for profit organization, including government agencies. Search the Web and find an organization that would be interesting to study and that has available data for your analyses. Examine the data available; use the skills you have learnt in Excel to present the data, identifying problems areas of the organization and highlighting for example areas of growth, profitability etc.

How do I do the project?

The following steps will guide you through the process of doing your project.

• Brainstorm the organization’s general information such as its name, structure and function

• Collect relevant data and examine the data

• Design the user interface (the worksheets)

• Develop the worksheets

• Test and debug the worksheets

• Add automation (e.g., macros) as necessary

• Test and debug the completed application

• Submit worksheets plus all other supporting documents. The work should be properly referenced.

• The spreadsheet should not be simple recreation of tables/charts found on websites of your subject organization.

Specifications about your workbooks/worksheets

Your workbooks/worksheets will meet the following requirements and your marks will be based primarily on these criteria.

• Include at least 15 worksheets

• Include a documentation/reference worksheet

• Link to a website related to your organization

• Include 3 different type of charts

• Include relative, mixed and absolute references

• Use AVERAGE, MAX, MIN and COUNT functions

• Use a FINANCIAL FUNCTION, i.e., PV, FV or PMT etc.

• Develop a spreadsheet model for a financial forecast


• Include a list and apply DATABASE FUNCTIONS to the list

Resources for financial data (Optional)

1. [url removed, login to view]

Skills: Data Entry, Data Processing, Excel, Web Scraping, Web Search

See more: website design worksheet, web application user guide, resources need manager, project manager available, organization work, name brainstorm, link list data structure, interesting websites design, design interesting website, government websites design, different type data structure, develop websites steps, data structure problems, data structure link list, application list data structure, agencies available, excel scenario, steps develop website, develop simple websites, study select, pv, find project manager, find project manager design, excel model, excel function

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #4742174

0 freelancers are bidding on average $ for this job


Hired by the Employer

$27 CAD in 4 days
(108 Reviews)