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

1、D DEVELOPEVELOP ANDAND USEUSE COMPLEXCOMPLEX SPREADSHEETSSPREADSHEETS 19 19thth Oct.2012 By Jun Wang Oct.2012 By Jun Wang2023-5-221 1 1.Prepare to develop spreadsheet 1.Prepare to develop spreadsheet 2.Develop a linked spreadsheet solution 3.Annotate and standardise spreadsheets 4.Use spreadsheets 5

2、.Represent numerical data in graphic formUNIT PURPOSE2023-5-222 22023-5-223 3l1.1 Organise personal work environment in accordance with ergonomic requirementsavoiding radiation from computer screenschair height,seat and back adjustmentdocument holder;footrest;keyboard and mouse positionlighting;nois

3、e minimisation;posture;screen positionworkstation height and layout2023-5-224 4l1.2 Analyse task and determine specifications for spreadsheets Participants will be required to demonstrate that they have the knowledge,skills and attitudes required to design,create and use complex spreadsheets and cha

4、rts.Participants will be asked to compile a portfolio of spreadsheets as evidence of competence.Participants results in this unit will be recorded and reported as a grade.2023-5-225 5l1.3 Apply work organisation strategies and energy and resource conservation techniques to plan work activitiesexerci

5、se breaksmix of repetitive and other activitiesrest periodsdouble-sided paper use;recycling used and shredded paperre-using paper for rough drafts(observing confidentiality requirements)using power-save options for equipment2023-5-226 6l1.4 Introduction Excel tables provide a way to keep your data i

6、n a coherent list format on an Excel spreadsheet.This list format is really somewhat like a database table,for those familiar with database terminology.It organizes the data into labeled columns with drop-down data-filtering controls that allow you reduce the data being displayed and to sort it in o

7、rganized ways.2023-5-227 7IntroductionExcelExcelInput&EditChart&DiagramFormula&FunctionData AnalyzeMarco&VBA2023-5-228 8IntroductionCultivation of interest,Challenge yourselfEmphasis on pressure,Prepare for competitionThe reason for learning Excelwidespreadnormativecompatibility2023-5-229 9DataInfor

8、mationData entryComputing&AnalysisData ArrangementPresentation&Expression2023-5-221010 IntroductionSpreadsheet Computerized equivalent of a ledgerExcel a computerized spreadsheet application used to build and manipulate worksheets and workbooks Worksheet a spreadsheet that may contain data,values,fo

9、rmulas,and/or chartsWorkbook a collection of related worksheets within one fileCell an intersection of a column and a row2023-5-221111IntroductionSheet TabsStatus BarName BoxFormula BarMenu Bar2023-5-221212l Home Clipboard Font Alignment Number Styles Cells Editing2023-5-221313lInsertTablesIllustrat

10、ionsChartsLinksText2023-5-221414lPage LayoutThemesPages SetupScale to FitSheet OptionsArrange2023-5-221515lFormulasFunction LibraryDefined NamesFormula AuditingCalculation2023-5-221616lDataGet External DataConnectionsSort&FilterData ToolsOutlined2023-5-221717lReviewProofingCommentsChanges2023-5-221818lViewWorkbook ViewsShow/HideZoomWindowMacros2023-5-221919lExercise Do some comprehensions about the Excel menu bar.2023-5-222020