|
You’ll occasionally find that seemingly simple entries cause problems because Excel tries to interpret numeric values as a date. For instance, say that you have a column of product codes with values like 9-12, 10-22, and 8-2099, or you have data labels that describe the age ranges 1-3, 4-6, 7-9, and 10-12. Excel automatically converts [...] (Excel 2000/2001/2002/2003/2007) When you’re working fast, you’re bound to make mistakes. You’ll often catch your errors right away, but it’s easy to make accidental changes to a workbook’s existing data and not notice until it’s too late. If you’ve ever felt the nausea that accompanies the realization that you’ve just saved workbook changes that unintentionally destroy [...] When you work with a large Excel worksheet, it’s often difficult to remember exactly what kind of data columns or rows contain once you begin scrolling around the sheet and lose sight of the column and row labels. Fortunately, you can freeze rows and columns that contain headings so you always know what data you’re [...] When you insert a worksheet using the Insert | Worksheet menu command, Excel automatically bases the new sheet on the default template. However, you may not want to insert just a blank worksheet. For instance, say your company uses a special Project Tracking template. A workbook is dedicated to each client and there could be [...] Many Excel users are familiar with the shortcut key that allows you to undo an action. By pressing [Ctrl]Z ([command]Z in v. X) it’s easy to eliminate the last action you made. However, what if you realize that you should have kept the action, or the undo was accidental in the first place? Fortunately, you [...] Never type a decimal point again (Excel 2000/2002/2003) If you consistently use the same number of decimal places in your Excel values but typing the decimal point slows down your data entry, there’s an easier way. You can permanently set all of the numbers you enter in your Excel workbooks to include the same number of [...] Far too many times, I have been making a bulleted list in Word or PowerPoint and want to hit enter just to wrap a line, but I don’t want a bullet to show and I can’t do it…until now. All you have to do to start a new line without a bullet is hold down Shift [...] Display a cheat sheet for your function right in the formula bar (Excel 2000/2002/2003/2004) You’ve probably seen the ToolTip that appears when you begin to type a formula. Once you enter the opening parenthesis, the arguments for that function appear below the Formula bar or active cell. But, many power users find these ToolTips more annoying [...] Customize chart axis labels even if they aren’t in your source data When you use the Chart Wizard to create a chart from a data table, there are often missing elements. After all, you probably weren’t intending to create a chart when you entered the data. If you’re missing the convenient category (x-axis) labels [...] |
|
|
Copyright © 2010 Get Schooled at New Horizons - All Rights Reserved |
|