Excel-Training-Manual-BCG

《Excel-Training-Manual-BCG》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、BCGChicagoOfficeComputerTrainingMicrosoftExcel97TrainingManualSummer1998DevelopedbyBCGChicagoVersion1.0MicrosoftExcel97TrainingManualTABLEOFCONTENTSWorkbookExcelWorkbook2ShortcutsWithinaWorksheet3MovingWithinaWorkbook4RenamingSheetTabs5AutoFill5CopyingBetweenWorkshe

2、ets6SortingandFiltersSorting7AutomaticSubtotals7Filters8AdvancedFilters9FormulasCellReferences11EnteringaFormula11UsingRangesinFormulas12FormulasandFunctions12IncludingWorkbookReferencesinFormulas13FunctionWizard14AbsoluteandRelativeReferences15FormattingFormatting1

3、6TexttoColumns18ConditionalFormatting19DataValidation20PivotTableCreateaPivotTable22ModifyaPivotTable23GetPivotDataFunction24ChartsChartTypes26CreatingaChart27CreatingaScatterPlot28CreatingaConcentrationCurve29TwoSeriesDataChart30OtherUsefulTips32CustomizetheToolbar

4、321DevelopedbyBCGChicagoVersion1.0MicrosoftExcel97TrainingManualExcelWorkbookAworkbookisthestandardfiletypeinExcel.Thedefaultworkbookconsistsof3sheets,namedSheet1throughSheet3.Amaximumof255sheetscanbeallowedinanyfile.Themaximumnumberofcolumnsinasingleworksheetis256.

5、Themaximumnumberofrecordsinaworksheetis65,536.Eachcellcancontain32,000characters.ThefollowingpicturedescribescomponentsinabasicExcelworkbook.ScreenComponentsTitlebarMenubarToolbarMinimizeMaximizeCloseZoomVerticalscrollboxSheettabsscrollingbuttonsHorizontalStatusbarS

6、heettabsscrollbox2DevelopedbyBCGChicagoVersion1.0MicrosoftExcel97TrainingManualShortcutsWithinaWorksheetLocationMouseKeyboardCellA1DragthescrollboxtothePressCTRL+HOMEtop.ClickoncellA1LastcellofdatainDragthescrollboxtothePressCTRL+ENDworksheetbottom.Leftsideofactiver

7、owDragthescrollboxtothePressHOMEleftLastcolumnofdataintheDragthescrollboxtothePressENDENTERactivecellrightLast/FirstcellwithcontentsPressCtrl+Right/LeftinarowarrowLastBottom/TopcellwithPressCtrl+Down/UpcontentsinacolumnarrowDownonewindowClickunderthescrollboxPgDnUpo

8、newindowClickabovethescrollboxPgUpOnewindowrightClickontherightoftheALT+PgDnscrollboxOnewindowleftClicktotheleftoftheALT+PgUpscrollboxSele