英文版Excel表格制作管理课件.ppt

《英文版Excel表格制作管理课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Developandusecomplexspreadsheets19thOct.2012ByJunWangUnitPurpose1.Preparetodevelopspreadsheet1.1Organisepersonalworkenvironmentinaccordancewithergonomicrequirementsavoidingradiationfromcomputerscreenschairheight,seatandbackadjustmentdocumentholder;footrest;keyboardandmousepositionlighting

2、;noiseminimisation;posture;screenpositionworkstationheightandlayout1.2AnalysetaskanddeterminespecificationsforspreadsheetsParticipantswillberequiredtodemonstratethattheyhavetheknowledge,skillsandattitudesrequiredtodesign,createandusecomplexspreadsheetsandcharts.Participantswillbeaskedtocom

3、pileaportfolioofspreadsheetsasevidenceofcompetence. Participantsresultsinthisunitwillberecordedandreportedasagrade.1.3Applyworkorganisationstrategiesandenergyandresourceconservationtechniquestoplanworkactivitiesexercisebreaksmixofrepetitiveandotheractivitiesrestperiodsdouble-sidedpaperuse;

4、recyclingusedandshreddedpaperre-usingpaperforroughdrafts(observingconfidentialityrequirements)usingpower-saveoptionsforequipment1.4IntroductionExceltablesprovideawaytokeepyourdatainacoherentlistformatonanExcelspreadsheet.Thislistformatisreallysomewhatlikeadatabasetable,forthosefamiliarwith

5、databaseterminology.Itorganizesthedataintolabeledcolumnswithdrop-downdata-filteringcontrolsthatallowyoureducethedatabeingdisplayedandtosortitinorganizedways.IntroductionExcelInput&EditChart&DiagramFormula&FunctionDataAnalyzeMarco&VBAIntroductionCultivationofinterest,ChallengeyourselfEmphas

6、isonpressure,PrepareforcompetitionThereasonforlearningExcelwidespreadnormativecompatibilityDataInformationDataentryComputing&AnalysisDataArrangementPresentation&ExpressionIntroductionSpreadsheet–ComputerizedequivalentofaledgerExcel–acomputerizedspreadsheetapplicationusedtobuildandmanipulat

7、eworksheetsandworkbooksWorksheet–aspreadsheetthatmaycontaindata,values,formulas,and/orchartsWorkbook–acollectionofrelatedworksheetswithinonefileCell–anintersectionofacolumnandarowIntroductionSheetTabsStatusBarNameBoxFormulaBarMenuBarHomeClipboardFontAlignmentN