英文版Excel表格制作管理

DEVELOPANDUSECOMPLEXSPREADSHEETS19thOct.2012ByJunWang•1.Preparetodevelopspreadsheet•2.Developalinkedspreadsheetsolution•3.Annotateandstandardisespreadsheets•4.Usespreadsheets•5.RepresentnumericaldataingraphicformUNITPURPOSE1.1Organisepersonalworkenvironmentinaccordancewithergonomicrequirementsavoidingradiationfromcomputerscreenschairheight,seatandbackadjustmentdocumentholder;footrest;keyboardandmousepositionlighting;noiseminimisation;posture;screenpositionworkstationheightandlayout1.2AnalysetaskanddeterminespecificationsforspreadsheetsParticipantswillberequiredtodemonstratethattheyhavetheknowledge,skillsandattitudesrequiredtodesign,createandusecomplexspreadsheetsandcharts.Participantswillbeaskedtocompileaportfolioofspreadsheetsasevidenceofcompetence.Participantsresultsinthisunitwillberecordedandreportedasagrade.1.3Applyworkorganisationstrategiesandenergyandresourceconservationtechniquestoplanworkactivitiesexercisebreaksmixofrepetitiveandotheractivitiesrestperiodsdouble-sidedpaperuse;recyclingusedandshreddedpaperre-usingpaperforroughdrafts(observingconfidentialityrequirements)usingpower-saveoptionsforequipment1.4IntroductionExceltablesprovideawaytokeepyourdatainacoherentlistformatonanExcelspreadsheet.Thislistformatisreallysomewhatlikeadatabasetable,forthosefamiliarwithdatabaseterminology.Itorganizesthedataintolabeledcolumnswithdrop-downdata-filteringcontrolsthatallowyoureducethedatabeingdisplayedandtosortitinorganizedways.IntroductionExcelDataAnalyzeIntroductionCultivationofinterest,ChallengeyourselfEmphasisonpressure,PrepareforcompetitionThereasonforlearningExcelwidespreadnormativecompatibilityDataInformationDataentryComputing&AnalysisDataArrangementPresentation&ExpressionIntroductionSpreadsheet–ComputerizedequivalentofaledgerExcel–acomputerizedspreadsheetapplicationusedtobuildandmanipulateworksheetsandworkbooksWorksheet–aspreadsheetthatmaycontaindata,values,formulas,and/orchartsWorkbook–acollectionofrelatedworksheetswithinonefileCell–anintersectionofacolumnandarowIntroductionSheetTabsStatusBarNameBoxFormulaBarMenuBarHomeClipboardFontAlignmentNumberStylesCellsEditingInsertTablesIllustrationsChartsLinksTextPageLayoutThemesPagesSetupScaletoFitSheetOptionsArrangeFormulasFunctionLibraryDefinedNamesFormulaAuditingCalculationDataGetExternalDataConnectionsSort&FilterDataToolsOutlinedReviewProofingCommentsChangesViewWorkbookViewsShow/HideZoomWindowMacrosExerciseDosomecomprehensionsabouttheExcelmenubar.