热度 3||
1. I’m surprised to find that many experienced Excel users don’t take advantage of the AutoFill feature, which can save a lot of time.
我很惊奇很多Excel老用户都不会利用自动填充功能,其实它可以节省很多时间
2. Potential problems that may crop up when you use names.
当你使用名称时就可以出现各种潜在的问题。
3. By using a naming convention, your names will tell you more about themselves. For instance, you could prefix all your workbook-level names with wb and your worksheet-level names with ws. With this method, you’ll never confuse wbTotal with wsTotal.
对于名称的命名而言,你的名字应该更加容易辨别,例如你可以再工作薄级名称前加上wb以及在工作表级名称前加上ws,这样你就不会混淆wbTotal和wsTotal这两个名称了。
4. Here’s the secret to understanding names: When you create a name, you’re actually creating a named formula. Unlike a normal formula, a named formula doesn’t exist in a cell. Rather, it exists in Excel’s memory.
这是对名称理解的即一个秘密,当你创建一个名称的时候,实际上你是创建了一个命名的公式,不同于常见的公式,命名的公式在单元格中不存在,事实上,他存在于Excel的内存中。
5. After you select the desired function, press Tab to insert the function
and its opening parenthesis into the cell.
当你选择想要的函数后,按Tab键就可以输入函数并且自动帮你是输入了左括号。
6. If you omit the closing parenthesis for a function, Excel adds it for you automatically. For example, if you type =SUM(A1:C12 and press Enter, Excel corrects the formula by adding the right parenthesis.
如果你忘记输入函数的右括号,Excel会自动帮你添加上右括号,例如,如果你输入=SUM(A1:C12 然后按回车键,Excel会自动为公式添加上右括号。
7. You may hear the term string used instead of text. You can use these terms interchangeably. Sometimes, they even appear together, as in text string.
你或许听到的是字符串而不是文本,这两个其实可以互换的,通常他们出现在一起,比如字符串文本。
8. I certainly don’t recommend using a cell in lieu of a word processor, but you really don’t have to lose much sleep worrying about filling up a cell with text.
当然我不推荐用单元格代替文字处理器,实际上你也不必为此失眠去担如何在单元格中填充文本。
9 Excel also has a CONCATENATE function, which takes up to 255 arguments. This function simply combines the arguments into a single string. You can use this function if you like, but using the & operator is usually simpler.
Excel中有Concatenate函数,这个函数可以有255个参数,它的作用就是将单个字符串连在一起,你可以使用这个函数,但是直接用 & 会更加简单。
10. If you want to find an actual question mark or asterisk character, type a tilde (~) before the question mark or asterisk.
查找函数search如果查找的是问号或者星号,在问号或星号前加上~