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

资源描述

1、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.1Organisepersonalwork

2、environmentinaccordancewithergonomicrequirementsavoidingradiationfromcomputerscreenschairheight,seatandbackadjustmentdocumentholder;footrest;keyboardandmousepositionlighting;noiseminimisation;posture;screenpositionworkstationheightandlayout2024/5/22 周三4 4l1.2Analysetaskanddeterminespecificationsfors

3、preadsheetsParticipantswillberequiredtodemonstratethattheyhavetheknowledge,skillsandattitudesrequiredtodesign,createandusecomplexspreadsheetsandcharts.Participantswillbeaskedtocompileaportfolioofspreadsheetsasevidenceofcompetence.Participantsresultsinthisunitwillberecordedandreportedasagrade.2024/5/

4、22 周三5 5l1.3Applyworkorganisationstrategiesandenergyandresourceconservationtechniquestoplanworkactivitiesexercisebreaksmixofrepetitiveandotheractivitiesrestperiodsdouble-sidedpaperuse;recyclingusedandshreddedpaperre-usingpaperforroughdrafts(observingconfidentialityrequirements)usingpower-saveoptions

5、forequipment2024/5/22 周三6 6l1.4IntroductionExceltablesprovideawaytokeepyourdatainacoherentlistformatonanExcelspreadsheet.Thislistformatisreallysomewhatlikeadatabasetable,forthosefamiliarwithdatabaseterminology.Itorganizesthedataintolabeledcolumnswithdrop-downdata-filteringcontrolsthatallowyoureducet

6、hedatabeingdisplayedandtosortitinorganizedways.2024/5/22 周三7 7IntroductionExcelInput&EditChart&DiagramFormula&FunctionDataAnalyzeMarco&VBA2024/5/22 周三8 8IntroductionCultivationofinterest,ChallengeyourselfEmphasisonpressure,PrepareforcompetitionThereasonforlearningExcelwidespreadnormativecompatibilit

7、y2024/5/22 周三9 9DataInformationDataentryComputing&AnalysisDataArrangementPresentation&Expression2024/5/22 周三1010IntroductionSpreadsheetComputerizedequivalentofaledgerExcelacomputerizedspreadsheetapplicationusedtobuildandmanipulateworksheetsandworkbooksWorksheetaspreadsheetthatmaycontaindata,values,f

8、ormulas,and/orchartsWorkbookacollectionofrelatedworksheetswithinonefileCellanintersectionofacolumnandarow2024/5/22 周三1111IntroductionSheetTabsStatusBarNameBoxFormulaBarMenuBar2024/5/22 周三1212lHomeClipboardFontAlignmentNumberStylesCellsEditing2024/5/22 周三1313lInsertTablesIllustrationsChartsLinksText2

9、024/5/22 周三1414lPageLayoutThemesPagesSetupScaletoFitSheetOptionsArrange2024/5/22 周三1515lFormulasFunctionLibraryDefinedNamesFormulaAuditingCalculation2024/5/22 周三1616lDataGetExternalDataConnectionsSort&FilterDataToolsOutlined2024/5/22 周三1717lReviewProofingCommentsChanges2024/5/22 周三1818lViewWorkbookViewsShow/HideZoomWindowMacros2024/5/22 周三1919lExerciseDosomecomprehensionsabouttheExcelmenubar.2024/5/22 周三2020

展开阅读全文