![]()
![]()
軟體簡介:
Lynda.com 出品的時長3小時38分鐘的深入學習Excel 2010的圖表視頻教學。
由Dennis Taylor講解如何解析和傳達Excel的圖表資料。教學首先講述了圖
表的基礎知識，然後演示如何快速創建圖表，並深度輔導圖表格式和細化圖
表，使他們更清楚、準確的表達資料。本教學附帶練習文件。
目錄:
Introduction
Welcome 01m 03s
Using the exercise files 00m 47s
20m 16s
1. Understanding Excel Chart Concepts
Identifying chart elements like plot area, chart area, gridlines, and legends 05m 40s
Selecting the right chart type 06m 44s
Understanding chart terminology 04m 52s
Understanding the Ribbon and the Design, Layout, and Format tabs 03m 00s
16m 03s
2. Creating Basic Charts Quickly
Selecting data to display as a chart 04m 15s
Creating charts instantly with shortcuts 02m 29s
Creating charts with standard menu commands 01m 17s
Creating presentation-ready charts with just a few adjustments 02m 22s
Creating graphic-in-cell charts with sparklines 05m 40s
24m 26s
3. Fine-Tuning Charts with Design Tab Choices
Switching rows and columns for a different view of the data 03m 00s
Setting a default chart type and creating a template 03m 19s
Dealing with empty and hidden cells 05m 45s
Choosing a chart layout 03m 22s
Choosing a chart style from 48 colorful variations 02m 35s
Changing the location of a chart 02m 19s
Moving and resizing a chart 04m 06s
09m 49s
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
Using pictures as chart elements 03m 50s
Adding shapes and arrows 02m 58s
Adding floating text and text boxes 03m 01s
29m 53s
5. Layout Tab Options: Adding Titles, Labels, and Legends
Adding, editing, and removing chart titles 02m 45s
Adding horizontal and vertical titles 03m 25s
Linking titles to content 01m 52s
Showing numbers of different scales 04m 19s
Specifying the position of tick marks and axis labels 03m 49s
Changing the numeric format on labels 03m 32s
Adding, editing, and removing legends 02m 17s
Adding and editing data labels 05m 42s
Showing the source of a chart's data 02m 12s
12m 07s
6. Layout Tab Options: Using Axes and Gridlines
Modifying axis scaling 07m 55s
Working with gridlines 04m 12s
13m 57s
7. Layout Tab Options: Using the Analysis Tools
Analyzing existing and future data with trendlines 06m 13s
Adding drop lines 01m 11s
Adding high-low lines and up-down bars 01m 59s
Adding error bars 04m 34s
12m 03s
8. Format Tab Options: Adding Shapes and WordArt Styles
Selecting shape fill and outline 04m 28s
Adding shape effects 05m 34s
Applying WordArt styles 02m 01s
16m 12s
9. Using Other Formatting Tools
Formatting lines and borders 03m 45s
Filling an area with a color gradient 03m 37s
Specifying line style, color, and weight 02m 57s
Working with chart text 02m 47s
Changing the rotation of chart text 03m 06s
39m 53s
10. Adjusting Specific Chart Types
Using column and bar charts 09m 12s
Using line charts 05m 25s
Using pie charts 06m 30s
Using area, stock, and XY charts 08m 57s
Using doughnut, bubble, and radar charts 09m 49s
10m 00s
11. Changing a Chart's Data Source
Pasting new data into a chart 02m 34s
Creating charts from multiple data sources 03m 34s
Adding new data using a table 03m 52s
11m 29s
12. Printing and Sharing Charts
Printing charts 06m 41s
Copying and linking charts with Word and PowerPoint 04m 48s
00m 44s
Conclusion
Next steps 00m 44s
