INFOCHINA全国office培训中心(46家)

加盟电话:400 600 1998

金融/保险专区

客户:中行  建行 法兴 三菱东京 PICC...

汽车/制造专区

客户:宝马 丰田 卡特彼勒 三一重工...

通信/电子专区
客户:移动、联通、澳电、 VERIZON 
石化/能源专区
客户:中石油 中石化 康菲 斯伦贝谢...
医疗/生物专区
客户:辉瑞、强生、合生元、诺和诺德...

 敬 告

诸多培训机构复制INFOCHINA培训大纲、培训客户、培训方案甚至公司简介,却没有专业讲师授课,让客户蒙受损失!INFOCHINA是宝马、华夏银行、卡特彼勒...全国唯一指定高端Office培训与服务提供商,如有雷同,绝非巧合。

Excel training in English:Excel Formulas and Functions Training

用户评价:  / 344
好 
课程简介

Microsoft Excel has a range of smart functions that can be used to calculate a variety of outcomes. This course will cover many common and useful functions in Excel and explore how to develop custom formulas with functions to produce the results which financial professionals may need.
培训对象

At Course Completion
After completing this course, students will be able to:
Use date and time functions to handle time-related information
Use database functions, information functions, lookup functions, logical functions to handle large amount of data stored in Excel
Use logical, math and trigonometry functions to process data
Use financial functions to handle Accounting Issue.
培训大纲

Key topics
1. Naming Cells and Ranges
1) Creating a Name
2) Making a name list
3) Using the name for calculation
2. Address Notation
1) Relative address
2) Absolute Address
3. Database functions(Used to analyze data stored in lists or databases)
1) DAVERAGE
2) DCOUNT
3) DCOUNTA
4) DMAX
5) DMIN
6) DPRODUCT
7) DSUM
4. Date and Time Functions(Used to convert a serial number to different date and time format)
1) TODAY
2) YEAR,MONTH,DAY
3) DATE
4) TIME
5) HOUT,MINUTE,SECOND
5. Financial Functions(Used to calculate the Payment for a loan or investment)
1) PMT
2) IPMT
3) PPMT
4) PV
5) FV
6. Information Functions(Used to checks the type of value an d returns TRUE or FALSE depending on the outcome)
1) COUNTBLANK
2) ISBLANK
3) ISERR
4) ISERROR
5) ISLOGICAL
6) ISNONTEXT
7) ISNUMBER
8) ISTEXT
7. Logical Functions(Used to perform a logical test or comparison for a value)
1) AND
2) IF
3) OR
4) TEUE
5) FALSE
8. Lookup Functions(Used to look for a value in a reference table and return the desired result from the table 
1) HLOOKUP
2) VLOOKUP
3) LOOKUP
9. Math and Trigonometry Functions(Used to perform some Math’s calculations)
1) ABS
2) CONUTIF
3) INT
4) MOD
5) PRODUCT
6) RAND
7) ROUND
8) ROUNDUP
9) ROUNDDOWN
10) SUMIF
11) SUMPROCUCT
12) TRUNC
10. Statistical Functions (Used to perform the statistical analysis)
1) AVERAGEA
2) COUNTA
3) MAXA
4) MINA
11. Text Functions(Used to apply the text format to the data in Excel )
1) CONCATENATE
2) DOLLAR
3) EXACT
4) LEFT
5) RIGHT
6) LEN
7) SUBSTITUTE
8) TEXT
9) TRIM 
10) UPPER
11) LOWER
12) VALUE
 
 Darian Stewart Womens Jersey

客户展示 - 涵盖56.4%的世界500强企业


电话: 0311-80892551 4006001998
咨询QQ 邵老师: 点击这里给我发消息
咨询QQ 李老师: 点击这里给我发消息

战略合作伙伴

   
   
   
   
   
   
   
   @2004 北京助力东方(INFOCHINA)科技有限公司版权所有 京ICP备06024442全国业务咨询热线:400-600-1998   

十大经典课程 + 十大金牌讲师 + 独创5S教学法 + 一年完美技术服务 = INFOCHINA|中国Office培训专家