excle公式（Excle formula）.docVIP

excle公式（Excle formula） Excel experience sharing (1) : Deloitte Excel Functions for accounting work Deloitte Excel function reference manual (non-confidential internal information) source: ancient sharp journal I often see friends sharing Excel files on everyone, and the old ones are the ones that come and go. Although there are classic things, there are also many outdated methods or complicated formulas. Many of Office2003s features were enhanced and streamlined in office 2007 and office 2010. And the complicated formula is composed of the basic formula, and it is the only way to learn how to simplify. 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. A simple combination or unconventional use of it will spawn off some NB stuff. Writing your own formulas can be fun. I will also be able to share Tips that I have summarized at work on a regular basis, including a quick grasp of the practical skills of using a mouse to operate Excel and some other cults. Because time is limited, may be more fragmented, but actually this thing originally need to accumulate slowly. Have fun! Contents Chapter 1: Text Functions... 1 1.1 Concatenate. 1 1.2 Exact. 1 1.3 Upper. 1 The Lower 1.4. 1 1.5 Left. 1 1.6 Right. 1 1.7 Len... 1 1.8 the Trim.. 2 1.9 the Text. 2 1.10 Substitute. 2 Chapter 2: LOOKUP query function... 2 2.1 HLookup. 2 2.2 VLookup. 2 2.3 the Lookup. 3 Chapter 3: Date and Time and Time functions... 3 3.1 Today.. 3 3.2 Year. 3 3.3 the Month.. 3 3.4 Day.. 3 3.5 the Date. 4 3.6 Time. 4 3.7 Hour. 4 3.8 Minute. 4 3.9 the Second.. 4 Chapter 4: Math Math function... 4 4.1 ABS. 4 4.2 the INT... 5 4.3 the PRODUCT.. 5 4.4 the MOD... 5 4.5 Rand.. 5 4.6 ROUND.. 5 4.7 ROUNDUP. 5 4.8 ROUNDDOWN.. 5 4.9 SumIF. 5 4.10 SumProduct. 6 4.11 Trunc. 6 Chapter 5: Logical functions... 6 5.1 the And.. 6 5.2 Not. 6 5.3 the Or. 6 5.4 True. 6 5.5 False. 6 5.6 If. 7 Chapter 6: Financial functions... 7 6.1 PMT..