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

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

Session 3 Introduction 6m 14s
Lesson 3-1: Insert and delete rows and columns 6m 25s
Lesson 3-2: Use AutoComplete and fill data from adjacent cells 3m 31s
Lesson 3-3: Cut, copy and paste 5m 26s
Lesson 3-4: Cut, copy and paste using drag and drop 8m 5s
Lesson 3-5: Use Paste Values and increase or decrease decimal places displayed 8m 54s
Lesson 3-6: Transpose a range 4m 10s
Lesson 3-7: Use the Multiple Item Clipboard 5m 51s
Lesson 3-8: Use Undo and Redo 6m 57s
Lesson 3-9: Insert cell comments 6m 32s
Lesson 3-10: View cell comments 3m 53s
Lesson 3-11: Print cell comments 4m 51s
Lesson 3-12: Understand absolute and relative cell references 9m 33s
Lesson 3-13: Understand mixed cell references 11m 22s
Lesson 3-14: Understand templates and set the default custom template folder 7m 23s
Lesson 3-15: Create a template 2m 46s
Lesson 3-16: Use a template 4m 19s
Lesson 3-17: Add an App to a workbook 8m 38s
Lesson 3-18: Freeze columns and rows 5m 6s
Lesson 3-19: Split the window into multiple panes 5m 20s
Lesson 3-20: Check spelling 7m 44s

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