Home Sample Files Register Books and e-books Forums Support Contact Search
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007
Learn Excel 2010 Essential Skills With The Smart Method

Session 5: Charts and Graphics (Excel 2010)

Session 5 Introduction 0m 52s
Lesson 5-1: Create a simple chart with two clicks 5m 28s
Lesson 5-2: Move, re-size, copy and delete a chart 8m 7s
Lesson 5-3: Change the chart layout and add a data table 4m 29s
Lesson 5-4: Format chart element fills and borders 5m 53s
Lesson 5-5: Format 3-D elements and align text 6m 58s
Lesson 5-6: Move, re-size and delete chart elements 4m 15s
Lesson 5-7: Change a chart's source data 3m 51s
Lesson 5-8: Assign non-contiguous source data by click and drag 3m 8s
Lesson 5-9: Change source data using the Select Data Source dialog tools 3m 8s
Lesson 5-10: Chart non-contiguous source data by hiding rows and columns 5m 11s
Lesson 5-11: Create a chart with numerical axis 3m 44s
Lesson 5-12: Deal with empty data points 2m 15s
Lesson 5-13: Add data labels to a chart 5m 58s
Lesson 5-14: Highlight specific data points with color and annotations 5m 33s
Lesson 5-15: Add gridlines and scale axes 5m 47s
Lesson 5-16: Emphasize data by manipulating pie charts 4m 4s
Lesson 5-17: Create a chart with two vertical axis 5m 18s
Lesson 5-18: Create a combination chart containing different chart types 4m 15s
Lesson 5-19: Add a trend line 3m 51s
Lesson 5-20: Switch chart rows columns and add a gradient fill 4m 11s
Lesson 5-21: Create your own chart templates 4m 56s

Session 5 Exercise
Session 5 Exercise Answers
Register to view ALL of the lessons in this session