excel公司管理典型实例（typical examples of management of excel company）

《excel公司管理典型实例（typical examples of management of excel company）》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、excel公司管理典型实例（TypicalexamplesofmanagementofExcelcompany）Catalog：Thefirstchapter,Excelfoundation21.1Excel2003interfaceintroduction21.1.1titlebar21.1.2menubar31.1.3toolbar31.1.4formattoolbar31.1.5editcolumn41.1.6celladdress41.1.7indexandstandard51.1.8worksheettab5

2、1.1.9statusbar61.1.10partitionbox61.2Excelbasicoperation71.2.1startstheExcelworksheet81.2.2opentheworksheet81.2.3newworkbook91.2.4savetheworksheet101.2.5printworksheet111.3edittheworksheet11Operationof1.3.1cells111.3.2inputdata121.3.3findandreplace131.3.4mergece

3、lls141.3.5setsthecelldigitalformat151.3.6setsthecellalignedformat161.3.7setsthecellfontformat171.3.8setsthecellborderformat181.3.9insertrowsorcolumns191.3.10settherowandcolumnwidth191.3.11hidesrowsorcolumns211.3.12freezesrowsorcolumns211.3.13shareworkbook221.3.1

4、4views23sidebyside1.4theapplicationofExcelincompanymanagement24Thesecondchapterfunctionanddataanalysis262.1basicknowledgeoffunction262.1.1inputfunction262.1.2replicationfunction272.1.3hidefunction282.1.4operatorandpriority292.2commonlyusedfunction302.2.1SUMfunct

5、ion302.2.2IFfunction302.2.3MAXfunction312.2.4AVERAGEfunction312.2.5TODAYfunction312.2.6PPMTfunction312.2.7ROUNDfunction312.2.8INDEXfunction322.3basicdataanalysis322.3.1datasorting322.3.2automaticallyfiltersdata342.3.3advancedfilteringdata362.3.4classifiesandsumm

6、arizesthedata.372.4usechartstoanalyzedata402.4.1useschartstoanalyzedata402.4.2analyzesdatausingaPivotTablereport43SecondexamplesofofficemanagementThethirdchapterofficemanagement463.1officemanagementoverview463.2organizationchartofproductioncompany483.2.1producti

7、onprocess483.2.2insertpicture493.2.3editpicture503.2.4setsuptheartword513.2.5editartword523.2.6createorganizationalchart543.2.7addorganizationcharttext553.2.8editorganizationchart563.2.9insertcompanylogo573.2.10combinationlayer583.2.11saveasfile593.2.12notice603

8、.3makecorrespondencereceivingandrecordingform603.3.1productionprocess613.3.2buildtableframework613.3.3maketabletopics633.3.4settingsheaderpictures653.3.5settableforma