EXCEL应用技能提升-中级课程课件.ppt

《EXCEL应用技能提升-中级课程课件.ppt》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、EXCEL应用技能提升中级课程纲要目录前言：EXCEL2007的新特性第一部分：快捷操作与表单设计第三部分：常用函数第三部分：查找与对比第四部分：统计与汇总第五部分：做图EXCEL2007的新特性原有限制的突破65536行->100万行，256列->16384列与以前版本的兼容界面菜单和功能区快速访问工具栏Office按钮-EXCEL选项功能增强图形图表条件格式，颜色筛选数据透视表等等快捷操作与表单设计快捷操作复制方式填充序列方式填充非数字填充自定义序列双击按左列填充传统方式填充快速选中（CTRL+SHIFT+下箭头）行列互换（选择性粘贴

2、—转置）附：EXCEL快捷键一览表KeyAloneShiftCtrlAltShiftCtrlF1HelpWhat'sThisHelpInsertChartSheetF2EditModeEditCommentSaveAsF3PasteNameFormulaPasteFunctionDefineNameNamesFromLabelsF4RepeatActionFindAgainCloseWindowQuitExcelF5GotoFindRestoreWindowSizeF6NextWorkbookPrevWorkbookF7SpellChec

3、kMoveWindowF8ExtendSelectionAddToSelectionResizeWindowMacroListF9CalculateAllCalculateWorksheetMinimizeWorkbookF10ActivateMenuContextMenuRestoreWorkbookF11NewChartNewWorksheetNewMacroSheetVBEditorF12SaveAsSaveOpenPrintASelectAllFormulaArgumentsBBoldCCopyDFillDownDataMenuE

4、EditMenuFFindFileMenuFontNameGGotoHReplaceHelpMenuIItalicsInsertMenuJKInsertHyperlinkLMNNewWorkbookOOpenWorkbookFormatMenuSelectCommentsPPrintFontSizeQRFillRightSSaveTToolsMenuUUnderlineVPasteWCloseWorkbookWindowMenuXCutYRepeatActiveZUndo`(~)ToggleFormulaViewGeneralFormat

5、1(!)CellFormatNumberFormat2(@)ToggleBoldTimeFormat3(#)ToggleItalicsDateFormat4($)ToggleUnderlineCurrencyFormat5(%)ToggleStrikethruPercentFormat6(^)aExponentFormat7(&)aApplyBorder8(*)OutlineSelectRegion9(()HideRowsUnhideRows0())HideColumnsUnhideColumns-DeleteSelectionContr

6、olMenuNoBorder=(+)FormulaAutoSumInsertdialog[DirectDependentsDirectPrecedents]AllDependentsAllPrecedents;(semicolon)InsertDateSelectVisibleCellsInsertTime'(apostrophe)StyleCopyCellValueAbove:(colon)InsertTime/SelectArraySelectArraySelectDifferencesSelectUnequalCellsInser

7、tInsertModeCopyDeleteClearDeleteToEndOfLineHomeBeginRowStartOfWorksheetEndEndRowEndOfWorksheetPageUpPageUpPreviousWorksheetLeft1screenPageDownPageDownNextWorksheetRight1screenLeftArrowMoveLeftSelectLeftMoveLeftAreaRightArrowMoveRightSelectRightMoveRightAreaUpArrowMoveUpSe

8、lectUpMoveUpAreaDownArrowMoveDownSelectDownMoveDownAreaDropdownlistSpaceBarSpaceSelectRowSelectC