[原创] 学Excel，会English-20110113

1. To enter a date stamp into a cell, press Ctrl+; (semicolon). This enters the date directly into the cell and does not use a formula. Therefore, the date does not change.

用Ctrl+；和Ctrl+shift+；产生的日期和时间没有采用公式，这样的日期不随表格的日期而改变

2. The new AGGREGATE function, which works only in Excel 2010, provides another way to sum a range that contains one or more error values. Here’s an example：=AGGREGATE(9,2,C4:C10)，The first argument, 9, is the code for SUM. The second argument, 2, is the code for

“ignore error values.”

AGGREGATE函数是Excel2010版中新添加的函数，它能够计算一个或者多个错误值，这个函数的参数9代表sum函数，2代表忽略错误值。

3. When the Enable Iterative Calculation setting is in effect, Excel will never display the Circular References warning dialog box and will not display the Circular References message in the status bar. Therefore, you may create an unintentional circular reference and not even know about it.

当自动迭代设置有效时，Excel将不会显示循环引用的警告对话框，并且不会再状态栏里显示循环引用的消息框，因而，你可能引起来意想不到的循环引用而没有发觉。

4. To create a chart with a single keystroke, select the data that you want to chart and press Alt+F1. The result is an embedded chart of the default chart type. To create the chart on a chart sheet, press F11 instead of Alt+F1.

一键创建一个图标的方法是，选择数据然后按Alt+F1，这样就会生成一个默认类型的嵌入型图标，要创建一个图表工作表，按F11键而不是Alt+F1.

5. Sometimes, using a mouse to select a particular chart element is tricky. You may find it easier to use the keyboard to select a chart element.

有时候，利用鼠标选择特定的图标元素比较棘手时，你会发现利用键盘选取图标元素更加容易些。

6. Doing so can streamline your worksheet, reduce the size of your workbook files, and may even result in slightly faster recalculations

这样做能够使你的工作表更加顺畅，还能够减小工作薄的大小，甚至能够加快重新计算的速度。

7. Microsoft has never promoted Excel as a product that creates applications with secure source code.

微软从来就不鼓励将Excel作为一个具有加密源代码的一应用程序产品。

8. The password feature provided in Excel is sufficient to prevent casual users from accessing parts of your application that you want to keep hidden. However, the truth is that several password-cracking utilities are available.

Excel的密码功能足够防止一般用户进入你想隐藏的部分，然而，事实上很多密码破解工具都能够破解它。

9. The security features in Excel 2002 and later are much better than those in previous versions, but it’s possible that these can also be cracked. If you must be absolutely sure that no one ever sees your code or formulas, Excel is not your best choice as a development platform

Excel2002以及以后版本在加密方面进行了改进，但是仍然能够被破解，如果你必须希望别人不能够看到你的代码和公式，Excel不是最好的开发平台。

10. It’s a good idea to use comments liberally to describe what you do because the purpose of a particular VBA instruction is not always obvious.

对VBA代码进行注解是一个很好的习惯，因为一段特定的VBA代码的功能不一定是很明了。