If you're like most computer users, you utilize Excel regularly, whether you're determining your household bills and income or figuring out what each of your company's sales representatives sold for the month. But, if you're really like the majority of Excel users, the odds are also good that you are not using this program to its full capability. Excel can be a truly powerful software. You only need to find out how to make use of its full power. Here, then, are three tricks that can help you get more out of Excel.
Adding non-contiguous values
Excel's AutoSum option is an incredibly useful tool. It lets users rapidly add rows of numbers together to calculate a single sum. Too many users, though, are not familiar with how to use AutoSum to incorporate values which are not contiguous, or adjacent, to one another. Fortunately, this task isn't as complicated as users might think. The TechRebpublic blog recently illustrated how users are able to use AutoSum to add non-contiguous sums. The procedure involves selecting one column of numbers then holding the computer's "Control" key to select a second column. Users can then use AutoSum to compute the sums of both columns, even when they're not located next to one another.
Preventing bad data entry
Do your employees often enter bad data in the company spreadsheets? Your staff may very well be entering text into a spreadsheet intended just to accommodate numbers. This is often a frustrating situation when it's time to analyze your spreadsheet. The good news, though, as PC Magazine wrote in a recent story, is the fact that Excel features an option intended to prevent individuals from typing the wrong information inside a company spreadsheet. This phenomenal feature? It's name is Data Validation. Select the "Table Tools" tab on Excel. Next, click "Data Validation." Excel then allows you to enter precisely what type of data your employees ought to be entering into the spreadsheet. As an illustration, you could tell Excel just to allow numbers and not text within a spreadsheet's fields. Excel will then prevent employees from entering an incorrect type of data.
Don't let unsaved files ruin your day
We all get that sinking feeling when our computers shut down while we're working on an Excel file that we never saved. Fortunately, with newer versions of Excel, there is not any reason for that feeling. That is because Excel enables you to easily recover documents which you thought you lost. To recover these important files, click the "File" tab in Excel. Then click "Recover Unsaved Documents." After this, you simply click on the "lost" document once it appears on your screen. This technique works for Excel files that you never even gave a name.