excle公式（国外英文资料）.doc

excle公式（国外英文资料） Excel experience sharing (1) : Deloitte Excel Functions for accounting work Deloitte Excel function reference manual (non-confidential internal data) source: ancient journal Its a common sight to see friends sharing Excel data on everyone and moving around with the old ones. There are also classic things, but there are also a number of outdated methods or formulas that are not commonly used. Many of the features of Office2003 have been enhanced and streamlined in office 2007 and Office2010. The complex formula is composed of basic formulas, and the learning of complexity is the king. The following formula, selected from a large number of basic formulas, is used by anyone who deals with Excel, not just in the financial sector. Simple combinations or unconventional USES will spawn something NB. Writing your own formula can also be fun. In the future, I will also regularly share Tips that I have summarized at work, including a quick grasp of Excel and some of the practical tricks of the cult. Because time is limited, it may be more fragmented, but this is something that needs to be built slowly. Have fun! Contents Chapter 1: the Text Functions Text function... 1 1.1 Concatenate 1.2. 1 1 1.4 1.5 Left. 1 1.6 Right. 1 1.7 Len.. 1 1.8trim.. 2 1.9 text.2 1.10 Substitute Chapter 2: LOOKUP query function... 2 2.1 HLookup. 2 2.2 VLookup. 2 2.2.3 Chapter 3: Date and Time and Time functions... 3 3.1 Today. 3 3 3.3 Month... 3 3.4 Day. 3 4 3.6 Time 3.7hour.4 3.8 Minute. 4 3.9 Second.. 4 Chapter 4: Math Math function... 4 4.1 ABS. A: 4.2 INT.. 5 4.3 PRODUCT... 5 4.4 MOD.. 5 4.5 Rand. 5 ROUND... 5 4.7 ROUNDUP. 4.8 ROUNDDOWN... 5 4.9 SumIF. 5 4.10 SumProduct. 6 4.11 trunc.6 Chapter 5: Logical Logical functions... 6 5.1 And... 6 5.2 5.3 5.4 False.6 5.6 If. 7 Chapter 6: Financial functions... 7 6.1 PMT. 7 6.2 IPMT. 7 6.3 PPMT.. 7 6.4 FV. 7 6.5 PV.. 8 Chapter 7: Information Information function... 8 7.1 COUNTBLANK.. 8 7.2 ISBLANK. 8 7.3 ISERR.. 8 7.4 ISERROR.. 8 7.5 ISLO