Struggling to master Excel? Follow these three tips

If you’re like most computer users, you employ Excel regularly, whether you’re computing your household expenditures and revenues or determining what each of your company’s sales consultants sold for the month. But, if you are really like most Excel users, the odds are also good that you are not employing this program to its full potential. Excel can be a truly powerful program. You just need to realize 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 a tremendously useful tool. It lets users swiftly 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 that are not contiguous, or adjacent, to one another. Fortunately, this job isn’t as complicated as users might think. The TechRebpublic blog recently illustrated how users are able to use AutoSum to include non-contiguous sums. The procedure involves selecting one column of numbers and then holding the computer’s “Control” key to pick a second column. Users can then use AutoSum to compute the sums of both columns, even if they may not be located next to each other.

Preventing bad data entry

Too many Excel users attempt to enter bad data in their spreadsheets. For instance, maybe staff are supposed to enter only whole numbers inside your company’s quarterly sales spreadsheet. This, unfortunately, does not mean that some employees might try and enter numbers containing decimals. Fortunately, as PC Magazine wrote in a recent story, Excel has a nifty feature that will prevent workers from entering the incorrect form of information within a company spreadsheet. It’s called Data Validation. To access this feature, select the “Table Tools” tab. Next, click “Data Validation.” After that you can enter precisely what type of data the workers are allowed to enter. For instance, you can tell Excel to permit only numbers rather than text in a spreadsheet.

Don’t let unsaved files ruin your day

We all get that sinking feeling when our pcs 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 allows you to easily recover documents which you thought you lost. To recover these important files, select 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 procedure works for Excel files that you never even gave a name.


Posted on: 01.04.13