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

Session 2: Doing Useful Work with Excel (Excel 2010)

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

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