Lynda com Excel 2010 Charts in Depth 深入學習Excel 2010的圖表視頻教學 英文正式版



　


　
軟體簡介:
　
Lynda.com出品的時長3小時38分鐘的深入學習Excel2010的圖表視頻教學。
由DennisTaylor講解如何解析和傳達Excel的圖表資料。教學首先講述了圖
表的基礎知識，然後演示如何快速創建圖表，並深度輔導圖表格式和細化圖
表，使他們更清楚、準確的表達資料。本教學附帶練習文件。

目錄:

Introduction
Welcome01m03s
Usingtheexercisefiles00m47s
20m16s
1.UnderstandingExcelChartConcepts
Identifyingchartelementslikeplotarea,chartarea,gridlines,andlegends05m40s
Selectingtherightcharttype06m44s
Understandingchartterminology04m52s
UnderstandingtheRibbonandtheDesign,Layout,andFormattabs03m00s
16m03s
2.CreatingBasicChartsQuickly
Selectingdatatodisplayasachart04m15s
Creatingchartsinstantlywithshortcuts02m29s
Creatingchartswithstandardmenucommands01m17s
Creatingpresentation-readychartswithjustafewadjustments02m22s
Creatinggraphic-in-cellchartswithsparklines05m40s
24m26s
3.Fine-TuningChartswithDesignTabChoices
Switchingrowsandcolumnsforadifferentviewofthedata03m00s
Settingadefaultcharttypeandcreatingatemplate03m19s
Dealingwithemptyandhiddencells05m45s
Choosingachartlayout03m22s
Choosingachartstylefrom48colorfulvariations02m35s
Changingthelocationofachart02m19s
Movingandresizingachart04m06s
09m49s
4.LayoutTabOptions:InsertingPictures,Shapes,andTextBoxes
Usingpicturesaschartelements03m50s
Addingshapesandarrows02m58s
Addingfloatingtextandtextboxes03m01s
29m53s
5.LayoutTabOptions:AddingTitles,Labels,andLegends
Adding,editing,andremovingcharttitles02m45s
Addinghorizontalandverticaltitles03m25s
Linkingtitlestocontent01m52s
Showingnumbersofdifferentscales04m19s
Specifyingthepositionoftickmarksandaxislabels03m49s
Changingthenumericformatonlabels03m32s
Adding,editing,andremovinglegends02m17s
Addingandeditingdatalabels05m42s
Showingthesourceofachart'sdata02m12s
12m07s
6.LayoutTabOptions:UsingAxesandGridlines
Modifyingaxisscaling07m55s
Workingwithgridlines04m12s
13m57s
7.LayoutTabOptions:UsingtheAnalysisTools
Analyzingexistingandfuturedatawithtrendlines06m13s
Addingdroplines01m11s
Addinghigh-lowlinesandup-downbars01m59s
Addingerrorbars04m34s
12m03s
8.FormatTabOptions:AddingShapesandWordArtStyles
Selectingshapefillandoutline04m28s
Addingshapeeffects05m34s
ApplyingWordArtstyles02m01s
16m12s
9.UsingOtherFormattingTools
Formattinglinesandborders03m45s
Fillinganareawithacolorgradient03m37s
Specifyinglinestyle,color,andweight02m57s
Workingwithcharttext02m47s
Changingtherotationofcharttext03m06s
39m53s
10.AdjustingSpecificChartTypes
Usingcolumnandbarcharts09m12s
Usinglinecharts05m25s
Usingpiecharts06m30s
Usingarea,stock,andXYcharts08m57s
Usingdoughnut,bubble,andradarcharts09m49s
10m00s
11.ChangingaChart'sDataSource
Pastingnewdataintoachart02m34s
Creatingchartsfrommultipledatasources03m34s
Addingnewdatausingatable03m52s
11m29s
12.PrintingandSharingCharts
Printingcharts06m41s
CopyingandlinkingchartswithWordandPowerPoint04m48s
00m44s
Conclusion
Nextsteps00m44s