《Ecel基础与技巧1》由会员分享，可在线阅读，更多相关《Ecel基础与技巧1（16页珍藏版）》请在金锄头文库上搜索。
1、Excel培训February29,201908年培训计划会计（财务会计及管理会计）-每两周一次-每次30-40分钟Excel-每两周一次-每次30-40分钟每周五下午1点使用公式和函数：举例Vlookup查找函数Excel能帮我们做什么图表制作：举例双坐标图标口回区|；丿丿山山丄竽4口MLI一Q1L2C14AE3MicrosoftFxgcIInterviewfilesType*quesbonforhdpdPXWUJl：Arial冋1EleEdtW*Ins&tFermM:toolsQata也dowtielp5678 V1041V21314 IT161718192CT21222324252627
2、20T2930313233MonthTotal31esTransactionsAvgTransactionJan452.9406896S7W9Feb5603074374112Mar4963605648COD5May6765007459C6C6Apr736.83078394103Jun7365607561.04042900.000800.000700.000seessol600.000500.000400.000300.000200.000100.000FebMarMayAprJunuogoei匚6av-Jan!=TotalSates452.940550.65096.350676.500736.
3、830786.560Avq3974112880.05908.05941.031.04041.2001.000Readysummary数据分析：举例数据透视表1曰期1销售金额16/1/20011,3446/4/20011,1896/5/20011,0236/6/20019986/7/20011,3846/8/20011,1566/11/20011,1856/12/20011,2566/13/20011,0306/14/20016416/15/20011,4756/18/20017926/19/20011,2006/20/20011,1876/21/20015326/22/20017876/25/
4、20011,1936/26/20011,2336/27/20016756/28/20016916/29/20011,4487/2/20019597/3/20011,3017/4/20015557/5/20011,027高级功能：举例数值缩放自定义格式单元髓入显示General*-;General*-;General*-;General*-45.345.3General*-;General*-;General*-;General*-45.4345.43General*-;General*-;General*-;General*-ExcelExcel*-General;*-General;*-Ge
5、neral;*-General45.345.3*-General;*-General;*-General;*-General-45.4345.43*-General;*-General;*-General;*-GeneralExcelExcel$#,#0.00*-1434.55$1,434.55$#,#0.00*1545.98$545Q0*509.54*+ExcelExcel*4-545.98卄+卄+卄+*$General12.83#,#,100,000.00100r,ooon100100,000现实-商学院的重要选修课(PurdueUniversity)ExcelSAP-本身即是工作技能华尔
6、街银行-百分之五十以上的Excel使用者只使用了其中不到20%的功能。(中国更低)已经进行过的Excel培训数据透视表基础（PivoTable）如果（if）函数基础：逻辑练习条件求和基础（surrvif）查找函数（Vlookup）绝对和相对引用工作表的分级显示连接和分列单元格Excel学习资源Excel帮助！图书：-Excel2019宝典-Excel2019公式与函数应用宝典Excel图表宝典网站-office.microsoft/zhcn/excel（微软中文官方网站）-j-walk/ss/（图书作者，英文）Excel最常用的功能（商务）DataValidation（数据有效性）PivotT
7、ables（数据透视表）ExternalDataRanges（外部数据范围）Subtotals（分类加总）AutoFilter（自动过滤）NamedRanges（范围命名）KeyboardEfficiency（键盘功能）Hyperlinks（超级链接）Vlookups（查找函数）ConditionalFormatting（条件格式化）今天的主题1数据有效性DataValidationAcceptonlytextentriestextContentsFunctionIntroductionANDANDORNOTIFNestedIFsOliveOilLoqic1OliveOilLoqic2Oliv
8、eOilLoqic3IFBudqetIFANDSUMIFCOUNTIFSUMPRODUCT今天的主题2超级链接ExcelLogicalFunctionsGuidetotopics:Foraresultthat.isalogicalvalue(trueorfalse)useAND,OR,NOT.isanothercalculationoranothervalueuseIF,AND,OR.filtersandcalculatesuseCOUNTIF,SUMIF.isacalculationthatmultipliesandaddsuseSUMPRODUCT面试文件LoanAmount:$10,00
9、0.00AnnualInterestRate:7.25%Pmt.Period(months):1NumberofPeriods:36PaymentAmount:$309.92TotalPayments:$11,156.95TotalInterest:$1,156.95InterestRate7.00%7.25%7.50%7.75%8.00%8.25%8.50%$9,000.00$9,500.00$10,000.00$10,500.00$11,000.00$11,500.00C3OEL/BO71FormoreontheoliveoillogicexercisesseetheProficiencyExercises&Solutions1document&workbook.
