资源描述
Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,*,*,01,单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Excel Basic Application,Trainer:,XXXXXX,Date:XXXXX,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,强制换行,ALTA+ENTRY,多个单元同时输入或拷贝数据,CTRL+ENTRY,分数输入,0 1/3,显示,1/3,列表中选择,只适合文本输入,右击选,”pick from dropdown list”,或,ALT+,快速操作,输入和编辑数据,文本类型转化为数值,比如,PRMS,导出的数据,Paste Special,查找,CRTL+F,*,可以代替任意数目的字符,可以是一个也可以是多个字符,?,代替一个字符,比如,EL*Y,代表查找以,EL,开头以,Y,结尾的任意长度的单词,如果是,EL?Y,代表查找以,EL,开头以,Y,结尾的,5,个字母的单词,隐藏锁定单元格,标题连续打印,斜线表示的制作方法,数据整理,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,绝对引用,;,相对引用,D5;$D5;$D$5;D$5,NAME,Lower;Upper;Proper;Left;Right;Mid;&,小技巧:公式,&“”,消除,0,结果,文本处理,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,IF,语句,Isnumber,;,Iserror,;,Isblank,;,Iseven,;,Istext,;,Isodd,;,And;Or;True;False;,信息和逻辑,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Round(,单元格,数字,),Rounddown,;Roundup,Rand(),5*rand();,Randbetween,(),ABS(),Power(,单元格,数字,),Subtotal(,数字,区间,),Sum,Sumif,数学计算公式,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Today(),Now(),Month(,单元格,),Weeknumber(12,单元格,),Date(,),Networkdays,(,),两个日期间的工作天数,时间和日期,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Vlookup(cell,ref,number,logical,),Is,If,Match(lookup-value,array,matchtype,),Countif(range,criteria),Sumif(range,criteria,range,),Lookup,Index,查找和引用,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Top10,Customer,Blank,Nonblank,通配符,高级筛选,不重复数据,分类汇总,同时显示求和和求平均值,过滤,FILTER,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,组合数据,数据透视表,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,公式的应用,有效性,客户自定义,只输入文本,Conditional format,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,-,少用合并格,不要把,EXCEL,当,WORD,用,;,-,不要迷信宏,-,只用一个公式不能解决问题时,可以用变通的办法,Suggestion,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,;,著者,:EXCEL HOME;,价格,RMB88,推荐,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,Thank You!,2009-2010 TRICO Products.All rights reserved.Proprietary and Confidential Do Not Distribute.,
展开阅读全文