Analysis of Organization - Excel Project

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, Excel

See more: website design worksheet, web application user guide, use of data structure, type of data structure, resources need as a manager, project manager available, process data structure, organization at work, name brainstorm, link list in data structure, interesting websites design, how to design an interesting website, government websites design, government entry, different type of website design, different type of data structure, develop of websites steps, data structure type, data structure problems, data structure link list, data link manager, application of list in data structure, application of data structure, agencies available

About the Employer:
( 1 review ) Toronto, Canada

Project ID: #4742069

2 freelancers are bidding on average $23 for this job


Hi, I am willing and ready to take this interesting project and can start immediately. I can give my best quality and accurate output. Thanks.

$20 CAD in 3 days
(0 Reviews)

If you interest PM me

$25 CAD in 3 days
(0 Reviews)