How To Make Your Excel Data Entry Work Better Than The Others

Have you ever had a spreadsheet that was used was hard to follow, and full of numbers? If you have, you will begin with the importance of good design and layout of spreadsheet formula and functions created by someone with a thorough knowledge were. But ... At first glance it was not clear what to do. I click on the button? I need some data entry? Where do I enter the data?

It showed on screen was very dense in terms of the number of cells. The boundaries of the cells formatted in five different colors. What does it all? Help that was limited to the brief explanation in some cells, and these were some of the hidden columns. Data entry and share the results of the classes were not clearly separated. Macro buttons were in the classroom.

The end result was that I did not want these particular spreadsheet calculations, despite its useful. So what can be done to improve it? Here are seven steps to help you create spreadsheets that are more users friendly.

The first step is that end-user views: - Who is going to use a spreadsheet? Informed about Excel? Informed about the upload? The answers to these questions, layout, security, the amount of aid, and will probably formatting.

The first step is that layouts get well: - often put pen to paper and one of the first spreadsheet that helps to sketch a rough layout. It's easier than when the worksheet is going well at this stage to change things.

The third thing is that ensure adequate: - There are many ways to help. It is a title or headline, describing what the spreadsheet or a comment in a cell, the data validation information, the information in a text box, a separate worksheet, or even be associated with various documentation is available.

The fourth thing is that other results of the data entry: - The areas of the spreadsheet for data entry fields should be excluded from the calculation results. If not, it can be confusing for the end user, and the spreadsheet is difficult to maintain. Such separation can include using different worksheets, or just on a worksheet for a clear distinction between the two areas to insure.

The fifth thing is that kiss: - Too much information in a spreadsheet, heavier, and generally, the simpler the better. The article mentioned at the beginning of the spreadsheet is to disseminate information on other worksheets can be improved. There are other ways to achieve a simple look:

Using tables to convey information rather than data tables, Raise the ride height, so the worksheet with the data is not closed, where there are many songs with a light color shade every other row on a worksheet.

The sixth step is that on the general state of document: - Your spreadsheet should follow the conference. Information users need to search for the first time or first response should be in the top left or top center.

The seventh step is that details of the format: - Format for details, forms of a colors can be confusing, and then, usually the simpler the better. If you created a database in a table or Excel, the data from these different titles are in bold.