Using Microsoft Excel, you can store and analyze financial information, statistical data, mathematical formulas and more. Yet without accurate data, your sophisticated spreadsheet calculations are useless. Data accuracy can be particularly problematic if multiple people enter data into the same spreadsheet. There are ways to control Excel data entry and improve accuracy. This six-page document gives you five powerful tips to help you control how data is entered into an Excel spreadsheet.
Download and review the tips:
http://techrepublic.com.com/5138-10877-5965387.html
Then, Join this ongoing discussion and let us know if this presentation provides helpful information and if there's anything we can do to improve the document's format or content.
Discussion on:
DOWNLOAD: Control Excel data entry with these five powerful tips
Tags: networking, tips, excel, data entry, mary ann richardson
View:
Show:
Those are pretty good tips. I keep forgetting how to create a drop-down list. I also wasn't aware of the keyboard shortcuts for hiding and unhiding columns. I especially liked the additional resources down at the bottom of the page. We keep a library of TR PDF files so that we can refer back to them quickly. I'll put this article in our library.
Oops - I'm trying to post a comment to "Get the most from your Excel charts with these five tips", but the TR discussions link there cross-connects me to Bill Detwiler's "Control Excel data entry with these five powerful tips" article instead.
- Keyboard Shortcuts:
- Prev
- Next
- Toggle

































