You can find many useful example of excel files wich would help you having a better life.

This excel file is a sort of game. Although it is in flash format, but it is nice to experience a driving race in Excel. It is compatible with excel 2000 and newer release.

Autobahn.xls

Again from Nucleus Research, This excel-based calculator would help you to analyze financial aspects of a Microsoft Enterprise Project Management (EPM) solution implementation. This is very similar to the previous ROI calculator provided for an ERP system. Let’s see how the provider describes the file:

“INTRODUCTION This workbook has been developed specifically to evaluate the value of the Microsoft Office Enterprise Project Management Solution. It is designed to be used with the associated Nucleus Research report to help you build a business case and support your technology decision by evaluating the real impact to your corporation’s bottom line. Using the navigation buttons above or tabs at the bottom of the workbook, you’ll go to areas of the workbook where you can enter cost and benefit information. You may then print a detailed report showing the financial results. Calculations such as return on investment (ROI), total cost of ownership (TCO), payback period, and net present value (NPV) are calculated and may be used to select a solution or negotiate better terms on one that may have the wrong cost structure. It is recommended that users first review the tutorial on the Nucleus Web site that describes the process of gathering cost and benefit data.”

Nucleus EPM Solution ROI Tool.xls

Two more Excel files on FMEA. One is suitable for Risk Analysis, and the other is a form template.

FMEA-Forms.xls

Basic-Sumatra-FMEA-Quality-Risks-Analysis.xls

Wikipedia describes FMEA as: “A failure modes and effects analysis (FMEA), is a procedure in product development and operations management for analysis of potential failure modes within a system for classification by the severity and likelihood of the failures. A successful FMEA activity helps a team to identify potential failure modes based on past experience with similar products or processes, enabling the team to design those failures out of the system with the minimum of effort and resource expenditure, thereby reducing development time and costs. It is widely used in manufacturing industries in various phases of the product life cycle and is now increasingly finding use in the service industry. Failure modes are any errors or defects in a process, design, or item, especially those that affect the customer, and can be potential or actual. Effects analysis refers to studying the consequences of those failures.”

The excel file included in this post, provides you tables which are supporting the FMEA process. In addition to the tables you can find descriptions on how to run an FMEA process.

FMEA-Process-Template.xls

Those companies are seeking for an Integrated Information System (particularly an ERP), are deeply keen to know what does an ERP do for their enterprise Economy. That is to find how can they harvest from such an investment.

ERP or Enterprise Resource Planning Softwares are IT, and Process based tools for managers while they would take money, time, and effort from the organizations, so it is crucial to understand how would they help to improve final goal which is PROFIT!

This Excel file helps you find areas in which income and expenditures occur regarding to such an implementation, and guides you to fill the data to have an estimate on the project economic factors such as Return On Investment(ROI), Internal Rate of Return(IRR), and Net Present Value(NPV).

The file is produced by Nucleus Research

ERP-ROI-Calculation-tool.xls

This is a Flash-game in an Excel file in which you can try driving a car and improve your ability to navigate! a car.

I found it very amazing as I tried it first time.

It has levels which would get harder as you pass each.

Parking-Test.xls

If you have been in a Project manager shoes, you have probably worked a lot with Microsoft Project Manager, or Primavera solutions.

But have you ever try displaying Gantt-Charts using a spread-sheet softwares like MS Excel? the file attached to this post is a good one to have the experience.

Features:

• Define multiple projects in a combined view
• Create New Tasks and modify them with attributes such as Start Date, Due Date, Percent Completed, Owner, Setting Priority, assigning Notes, and to set a Reminder for the tasks
• Draw a real Gantt-Chart
• Put filters for tasks

Excel-Based-Project-Management.xls

This site aims to provide visitors solutions for life, entertainment, business, and fun in Excel Format. You might find answers to questions such as:

• How can I estimate my fuel consumption in excel