收藏 分销(赏)

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

上传人:a199****6536 文档编号:2404382 上传时间:2024-05-29 格式:PPTX 页数:20 大小:1.08MB 下载积分:10 金币
下载 相关 举报
英文版Excel表格制作管理.pptx_第1页
第1页 / 共20页
英文版Excel表格制作管理.pptx_第2页
第2页 / 共20页


点击查看更多>>
资源描述
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
展开阅读全文

开通  VIP会员、SVIP会员  优惠大
下载10份以上建议开通VIP会员
下载20份以上建议开通SVIP会员


开通VIP      成为共赢上传

当前位置:首页 > 包罗万象 > 大杂烩

移动网页_全站_页脚广告1

关于我们      便捷服务       自信AI       AI导航        抽奖活动

©2010-2026 宁波自信网络信息技术有限公司  版权所有

客服电话:0574-28810668  投诉电话:18658249818

gongan.png浙公网安备33021202000488号   

icp.png浙ICP备2021020529号-1  |  浙B2-20240490  

关注我们 :微信公众号    抖音    微博    LOFTER 

客服