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 2007 Essential Skills With The Smart Method

Session 3: Taking Your Skills To The Next Level (Excel 2007)

Session 3 Introduction 0m 36s
Lesson 3-1: Insert and delete rows and columns 5m 11s
Lesson 3-2: Use AutoComplete and fill data from adjacent cells 4m 10s
Lesson 3-3: Cut, copy and paste 3m 46s
Lesson 3-4: Cut, copy and paste using drag and drop 5m 10s
Lesson 3-5: Use Paste Values and increase decrease decimal places displayed 6m 44s
Lesson 3-6: Transpose a range 2m 23s
Lesson 3-7: Use the Multiple Item Clipboard 3m 46s
Lesson 3-8: Use Undo and Redo 2m 49s
Lesson 3-9: Insert cell comments 5m 20s
Lesson 3-10: View cell comments 2m 36s
Lesson 3-11: Print cell comments 3m 11s
Lesson 3-12: Understand absolute and relative cell references 6m 59s
Lesson 3-13: Understand mixed cell references 7m 35s
Lesson 3-14: Create a template 3m 12s
Lesson 3-15: Use a template 4m 35s
Lesson 3-16: Freeze columns and rows 4m 24s
Lesson 3-17: Split the window into multiple panes 4m 2s
Lesson 3-18: Check spelling 6m 36s

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