英文版Excel表格制作管理.pptx

DEVELOP AND USE COMPLEX SPREADSHEETS 19th Oct.2012 By Jun Wang2024/5/22 周三1 1 1.Prepare to develop spreadsheet2.Developalinkedspreadsheetsolution3.Annotateandstandardisespreadsheets4.Usespreadsheets5.RepresentnumericaldataingraphicformUNITPURPOSE2024/5/22 周三2 22024/5/22 周三3 3l1.1Organisepersonalworkenvironmentinaccordancewithergonomicrequirementsavoidingradiationfromcomputerscreenschairheight,seatandbackadjustmentdocumentholder;footrest;keyboardandmousepositionlighting;noiseminimisation;posture;screenpositionworkstationheightandlayout2024/5/22 周三4 4l1.2AnalysetaskanddeterminespecificationsforspreadsheetsParticipantswillberequiredtodemonstratethattheyhavetheknowledge,skillsandattitudesrequiredtodesign,createandusecomplexspreadsheetsandcharts.Participantswillbeaskedtocompileaportfolioofspreadsheetsasevidenceofcompetence.Participantsresultsinthisunitwillberecordedandreportedasagrade.2024/5/22 周三5 5l1.3Applyworkorganisationstrategiesandenergyandresourceconservationtechniquestoplanworkactivitiesexercisebreaksmixofrepetitiveandotheractivitiesrestperiodsdouble-sidedpaperuse;recyclingusedandshreddedpaperre-usingpaperforroughdrafts(observingconfidentialityrequirements)usingpower-saveoptionsforequipment2024/5/22 周三6 6l1.4IntroductionExceltablesprovideawaytokeepyourdatainacoherentlistformatonanExcelspreadsheet.Thislistformatisreallysomewhatlikeadatabasetable,forthosefamiliarwithdatabaseterminology.Itorganizesthedataintolabeledcolumnswithdrop-downdata-filteringcontrolsthatallowyoureducethedatabeingdisplayedandtosortitinorganizedways.2024/5/22 周三7 7IntroductionExcelInput&EditChart&DiagramFormula&FunctionDataAnalyzeMarco&VBA2024/5/22 周三8 8IntroductionCultivationofinterest,ChallengeyourselfEmphasisonpressure,PrepareforcompetitionThereasonforlearningExcelwidespreadnormativecompatibility2024/5/22 周三9 9DataInformationDataentryComputing&AnalysisDataArrangementPresentation&Expression2024/5/22 周三1010IntroductionSpreadsheetComputerizedequivalentofaledgerExcelacomputerizedspreadsheetapplicationusedtobuildandmanipulateworksheetsandworkbooksWorksheetaspreadsheetthatmaycontaindata,values,formulas,and/orchartsWorkbookacollectionofrelatedworksheetswithinonefileCellanintersectionofacolumnandarow2024/5/22 周三1111IntroductionSheetTabsStatusBarNameBoxFormulaBarMenuBar2024/5/22 周三1212lHomeClipboardFontAlignmentNumberStylesCellsEditing2024/5/22 周三1313lInsertTablesIllustrationsChartsLinksText2024/5/22 周三1414lPageLayoutThemesPagesSetupScaletoFitSheetOptionsArrange2024/5/22 周三1515lFormulasFunctionLibraryDefinedNamesFormulaAuditingCalculation2024/5/22 周三1616lDataGetExternalDataConnectionsSort&FilterDataToolsOutlined2024/5/22 周三1717lReviewProofingCommentsChanges2024/5/22 周三1818lViewWorkbookViewsShow/HideZoomWindowMacros2024/5/22 周三1919lExerciseDosomecomprehensionsabouttheExcelmenubar.2024/5/22 周三2020