《英文版Excel表格制作管理课件.pptx》由会员分享，可在线阅读，更多相关《英文版Excel表格制作管理课件.pptx（20页珍藏版）》请在三一办公上搜索。
1、Develop and use complex spreadsheets,19th Oct. 2012 By Jun Wang,2022/12/2,1,Unit Purpose,2022/12/2,2,1. Prepare to develop spreadsheet,2022/12/2,3,1.1 Organise personal work environment in accordance with ergonomic requirementsavoiding radiation from computer screenschair height, seat and back adjus
2、tmentdocument holder; footrest; keyboard and mouse positionlighting; noise minimisation; posture; screen positionworkstation height and layout,2022/12/2,4,1.2 Analyse task and determine specifications for spreadsheets Participants will be required to demonstrate that they have the knowledge, skills
3、and attitudes required to design, create and use complex spreadsheets and charts. 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.,2022/12/2,5,1.3 Apply work organisation strategie
4、s and energy and resource conservation techniques to plan work activitiesexercise 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 equi
5、pment,2022/12/2,6,1.4 Introduction Excel tables provide a way to keep your data in 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-f
6、iltering controls that allow you reduce the data being displayed and to sort it in organized ways.,2022/12/2,7,Introduction,Excel,Input & Edit,Chart & Diagram,Formula & Function,Data Analyze,Marco &VBA,2022/12/2,8,IntroductionCultivation of interest, Challenge yourselfEmphasis on pressure, Prepare f
7、or competitionThe reason for learning Excel,widespread,normative,compatibility,2022/12/2,9,Data,Information,Data entry,Computing & Analysis,Data Arrangement,Presentation & Expression,2022/12/2,10,IntroductionSpreadsheet Computerized equivalent of a ledgerExcel a computerized spreadsheet application
8、used to build and manipulate worksheets and workbooks Worksheet a spreadsheet that may contain data, values, formulas, and/or chartsWorkbook a collection of related worksheets within one fileCell an intersection of a column and a row,2022/12/2,11,Introduction,Sheet Tabs,Status Bar,Name Box,Formula B
9、ar,Menu Bar,2022/12/2,12,Home Clipboard Font Alignment Number Styles Cells Editing,2022/12/2,13,InsertTablesIllustrationsChartsLinksText,2022/12/2,14,Page LayoutThemesPages SetupScale to FitSheet OptionsArrange,2022/12/2,15,FormulasFunction LibraryDefined NamesFormula AuditingCalculation,2022/12/2,16,DataGet External DataConnectionsSort & FilterData ToolsOutlined,2022/12/2,17,ReviewProofingCommentsChanges,2022/12/2,18,ViewWorkbook ViewsShow/HideZoomWindowMacros,2022/12/2,19,Exercise Do some comprehensions about the Excel menu bar.,2022/12/2,20,
