资源描述：
《excel、wexcel、word和ppt在管理中的实战运用（practical application of excel, wexcel, word and ppt in management）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、EXCEL、WEXCEL、WORD和PPT在管理中的实战运用（PracticalapplicationofEXCEL,WEXCEL,WORDandPPTinmanagement）[trainingnumber]:[trainingprogram]:CurriculumbackgroundAccordingtoauthoritativeorganizationstatistics,ordinaryusersonlyaverage20%oftheapplicationsoftwarefunctions,onceeffectiveSoftwaresk
2、illstrainingincreasesproductivityby25%,equivalentto2000%oftrainingroi.EffectivetrainingwillbelargeItimprovestheefficiencyofthetrainedstaffandsavesalotofworktime(whichprobablypreventsalotofovertimework).Excel,WORDandPPTarepowerfultools,theyusethemforvariousdatamanagementandan
3、alysis,documentTemplate,process,andtheestablishmentofaneye-catching,extraordinarypresentationofthereporthasbecomeourdailyworkRongyi.ThiscourseisdesignedtoenablestudentstomasterExcelinthefinancial,personnel,salesandothermanagementworkApplicationandadvancedtechnology,inthefutu
4、rework,lessdetours,withhalftheeffort.RichexamplesandclassroomexercisesmakelearningThestaffwillrapidlyincreasetheiruseofExcel,WORDandPPTwithintwodaysandwillbeconvincingintheirdailyworkEfficiency.Thoughtofthought,thoughtofthought-thoughtofthoughtCurriculumcontentObjective:tous
5、etheadvancedfunctionsandskillsofEXCEL,tomanageandoptimizedatastructures,andtoperformefficientdataanalysis,ReportstatisticsFirst,buildtableskillsMakesurethedataisvalid(accurate)DatavaliditysettingsWhyaretheresomeunnecessarylinesprintedout?Two,datasecuritychapterSpecifiesthepr
6、otectionofthespecifiedcellWorksheetprotectionWorkbookprotectionOverallprotectionofdocumentsAutomaticsavesettingsThree,advancedapplicationofthechartChartmakingofspecialeffectsWhatchartwouldbebettertouseinsituations?ThemakingofcompositedrawingThemanufactureofbiaxialdrawingsFou
7、r,functionexamplesexplainRelativereferences,absolutereferences,andmixedreferencesinformulasandfunctionsFunctionnestingexampletoexplainEachinstanceofthefunctionclassexplainsseveraltypicalfunctionssuchasIF,SumifCountif,Rank,andquerylettersFive,datamanagementandanalysisDatabrea
8、kdownandconsolidation,ANNAutomaticsortingandcustomsortingAutomaticfiltering
