Lynda.com Excel 2010 Charts in Depth Lynda.com出品深入學習Excel 2010的圖表視頻教程 英文版
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
軟體名稱:Lynda.comExcel2010ChartsinDepth
語系版本:英文版
光碟片數:單片裝
保護種類:無
破解說明:無
系統支援:WindowsXP/Vista/7
硬體需求:PC
軟體類型:教學
更新日期:2011.06.21
軟體發行:Lynda.com
官方網站:http://www.lynda.com/Excel-2010-tutorials/Charts-in-Depth/81263-2.html
中文網站:無
軟體簡介:(以官方網站為準)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
主講人:DennisTaylor
Lynda.com出品的時長3小時38分鐘的深入學習Excel2010的圖表視頻教程。由Dennis
Taylor講解如何解析和傳達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
Showingthesourceofachartsdata02m12s
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.ChangingaChartsDataSource
Pastingnewdataintoachart02m34s
Creatingchartsfrommultipledatasources03m34s
Addingnewdatausingatable03m52s
11m29s
12.PrintingandSharingCharts
Printingcharts06m41s
CopyingandlinkingchartswithWordandPowerPoint04m48s
00m44s
Conclusion
Nextsteps00m44s

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=