Analyze Organization - Excel Project

Avg Bid (CAD)
Project Budget (CAD)
$30 - $250

Project Description:
---BUDGET MAX: $30--------

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)


Skills required:
Data Entry, Data Processing, Excel
Hire aliahmed92
Project posted by:
aliahmed92 Canada
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 34
in 3 days
$ 34
in 3 days
$ 149
in 3 days
Hire LanceWorks
$ 111
in 5 days
Hire swaminathan2507
$ 155
in 3 days
Hire urban86
$ 155
in 3 days
$ 30
in 7 days
Hire WilliamLevin12
$ 155
in 5 days
Hire abhijeet0287
$ 155
in 3 days
$ 105
in 10 days