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 2: Doing Useful Work with Excel (Excel 2007)

Session 2 Introduction 0m 55s
Lesson 2-1: Enter text and numbers into a worksheet 7m 9s
Lesson 2-2: Create a new workbook and view two workbooks at the same time 3m 22s
Lesson 2-3: Use AutoSum to quickly calculate totals 3m 14s
Lesson 2-4: Select a range of cells and understand Smart Tags 3m 55s
Lesson 2-5: Enter data into a range and copy data across a range 3m 58s
Lesson 2-6: Select adjacent and non-adjacent rows and columns 2m 26s
Lesson 2-7: Select non-contiguous cell ranges and view summary information 3m 22s
Lesson 2-8: AutoSelect a range of cells 3m 19s
Lesson 2-9: Re-size rows and columns 4m 9s
Lesson 2-10: Use AutoSum to sum a non-contiguous range 3m 1s
Lesson 2-11: Use AutoSum to quickly calculate averages 4m 31s
Lesson 2-12: Create your own formulas 5m 8s
Lesson 2-13: Create functions using Formula AutoComplete 5m 9s
Lesson 2-14: Use AutoFill for text and numeric series 3m 21s
Lesson 2-15: Use AutoFill to adjust formulas 5m 19s
Lesson 2-16: Use AutoFill Options 5m 38s
Lesson 2-17: Speed up your Auto Fills and create a custom fill series 3m 15s
Lesson 2-18: Use the zoom control 2m 41s
Lesson 2-19: Print out a worksheet 3m 6s

Session 2 Exercise
Session 2 Exercise Answers
Log Me In - I'm a registered user