You can get more out of Excel

If you’re like most computer users, you utilize Excel on a daily basis, whether you’re computing your household expenditures and revenues or figuring out what each of your company’s sales reps sold for the month. But, if you are like the majority of Excel users, the possibilities are also good that you are not making use of this program to its full capacity. Excel can be a truly powerful application. You just need to learn how to tap into its full power. Here, then, are three tricks that can help you get more from Excel.

Adding non-contiguous values

Excel’s AutoSum option is an incredibly useful tool. It lets users swiftly add rows of numbers together to calculate a single sum. A lot of users, though, don’t know the way you use AutoSum to add values that aren’t contiguous, or adjacent, to one another. Fortunately, this task isn’t as complicated as users may believe. The TechRebpublic blog recently explained how users are able to use AutoSum to include non-contiguous sums. The procedure involves picking one column of numbers and holding the computer’s “Control” key to select a second column. Users are able to use AutoSum to calculate the sums of both columns, even if they’re not located next to the other.

Preventing bad data entry

Do your employees often enter bad data in your company spreadsheets? Your staff might be entering text in a spreadsheet developed only to accommodate numbers. This is often a frustrating situation when it’s time to review your spreadsheet. The good thing, though, as PC Magazine wrote in a recent story, is the fact that Excel features a method intended to protect against personnel from typing the wrong information within a company spreadsheet. This amazing feature? It’s known as Data Validation. Click on the “Table Tools” tab on Excel. Next, click “Data Validation.” Excel then permits you to enter just what type of data your employees need to be entering into the spreadsheet. For instance, you could tell Excel to only allow numbers and never text in a spreadsheet’s fields. Excel will prevent employees from entering an incorrect kind of data.

Don’t let unsaved files ruin your day

What’s worse than watching your computer shut down while you’re working on Excel file that you hadn’t yet bothered saving? Actually, there are tons of things a whole lot worse than that. That’s because Excel enables you to easily recover “lost” documents. Here’s how to accomplish this: First, select the “File” tab in Excel. Next, click “Recover Unsaved Documents.” Finally, click on the document once it appears on your screen. In addition? This works for Excel files which you never even gave a name.