FMEA Product Example

Download this editable sample templates for excel. You can even print them, some of them contains MACRO and examples to understand how they work.For Product : This worksheet helps user to identify the potential failure and their effects on product reliability. The product with high RPN requires most attention as it has more chances to fail. Probability of the failure along with detect-ability and severity are examined and tracked.

Read More

Interview Rating Template Free

HR management is not a easy task. They have to do a lot of stuff including interviewing a perfect employee for their company. We are proving some templates or checklists that can save your time and mange information easily as they can be organized in spreadsheet form. You can even print them and use them. You should download one or every template to have a look and use them after editing.The key points in a interview templates are already covered…

Read More

3 Nifty Ways to Change date Formats In Excel

Change date format mm/dd/yyyy to dd/mm/yyyy in excel This problem is faced by many Indian users as the U.S system of mm/dd/yyyy is quite strange to them and for them it creates problem each time they look at it. So here i am sharing some tips to fix it.   Without using any code or Macro First i am taking here an example of date 9/23/2015 now to convert it into dd/mm/yyyy use this. Right click that particular cell in…

Read More

Send Email Vba Code Excel Examples

Here are examples of  VBA MACRO  codes that allows to send emails within Ms Excel. It is not a rocket science to understand how to send the email using MS outlook via VBA code. Basically I use Excel to list the e-mail addresses and the name of the attachments.   Here is MACRO to send mail via CDO   Whenever macro sends out an e-mail,via MS outlook you have to authorize it Select  “yes” to authorize it . Below is code for sending…

Read More

Excel Drag Not Working 2007 and 2010

Following are the tips that can be used to make drag function work properly in MS excel. In 2007 or 2008 version You have to open excel and click on options > it is beneath the file menu. You can see in this image. Now click on Advanced category, under Editing options. Now you have to clear the Enable fill handle ( Follow the images to understand it better) and change the cell drag-and-drop check box to turn on or…

Read More

Best Software To Recover Severely Corrupted Ms Excel File ?

There are plenty of Excel spreadsheet recovery software’s out there which one is your favorite ? I am including some of them here,their features along with their prices. It is not a review exactly for these tools but you can help me here by posting your comments and tell us which one is best? and why i should pay or not for that software. 1. Cimaware’s Excel fix : It comes with a price tag of €79. Developers say that…

Read More

Manage Mysql using Ms Access

Create edit and manage MYSQL database from MS Access This simple tool can help you to manage MYSQL dbase from MS Access without any knowledge of My SQL. User can easily modify /create/open tables within Access. It connects both the databases where you can edit,add and delete just like the normal ACCESS tables and then export the tables to the MYsql server.   Here is the tool download page    This tool was previously a paid software but now they are giving…

Read More

Quiz Template Download Without Any Hassle !!!

This spreadsheet template allows user to fill in quiz data. It is easier to understand first of all you have to type in the quiz name.After it you can fill in questions and the answers. Nice and easy template. You can even print this template after filling.     Here is a Power point template User has to fill in the questions and place the answers in text box as they are labelled where to put right and where to…

Read More

Macro To copy the worksheet column to another sheets row.

Why use VBA when we can use transpose : This macro is made for those who work on large and complicated data files. To debug the MACRO you have to press F8 in Microsoft Visual Basic. Suppose if you have a larger spreadsheet where you have to backup and view,sort around 30 columns rom one part of the sheet to another part of the worksheet and on a daily basis. Then how will you do it. Yeah we know transpose..but…

Read More

Convert Excel sheet to Google Spreadsheet and Make It Editable

It is very simple to make your spreadsheet editable for many other users via Google docs.  Users will be able to edit and update the worksheet from any place. Following are the steps :   Open Google Docs spreadsheet homepage click here . In the page click the folder icon (See image) Create and choose Files…>> upload After uploading file click it and open it. Now how to make it shareable and editable for any other person Now to share this…

Read More