Excel 2010 - Smart Method Video Course
The Smart Method - Free Online Video Course with 302 video tutorials
http://www.youtube.com/user/TheSmartMethod?feature=watch- 1-2 Maximize, minimize, re-size, move & close the Excel window 3:39
- 1-3 Application and Workbook windows 3:56
- 1-4 Open and navigate a workbook 8:00
- 1-5 Save a workbook 2:54
- 1-6 Understand common file formats 5:43
- 1-7 Pin a workbook & understand file organization 6:34
- 1-8 View, move, add, rename, delete & navigate worksheet tabs 5:41
- 1-9 Use Versions feature to recover an unsaved draft file 8:44
- 1-10 Use Versions feature to recover a workbook 4:34
- 1-11 Use the Ribbon 11:27
- 1-12 Understand Ribbon components 9:40
- 1-13 Customize the Quick Access Toolbar & preview the printout 9:38
- 1-14 Use the Mini Toolbar, Key Tips & keyboard shortcuts 6:29
- 1-15 Understand Views 3:13
- 1-16 Use full screen view 2:34
- 1-17 Use the help system 8:42
- 2-1 Enter text & numbers into a worksheet 9:27
- 2-2 Create a new workbook; view two workbooks at the same time 6:11
- 2-3 Use AutoSum to quickly calculate totals 4:31
- 2-4 Select a range of cells & understand Smart Tags 6:00
- 2-5 Enter data into a range and copy data across a range 5:31
- 2-6 Select adjacent and non-adjacent rows and columns 3:07
- 2-7 Select non-contiguous cell ranges and view summary information 5:44
- 2-8 AutoSelect a range of cells 5:28
- 2-9 Re-size rows and columns 6:13
- 2-10 Use AutoSum to sum a non-contiguous range 3:37
- 2-11 Use AutoSum to quickly calculate averages 5:58
- 2-12 Create your own formulas 7:03
- 2-13 Create functions using Formula AutoComplete 6:40
- 2-14 Use AutoFill for text and numeric series 5:38
- 2-15 Use AutoFill to adjust formulas 6:04
- 2-16 AutoFill Options 6:11
- 2-17 Speed up your Auto Fills and create a custom fill series 5:05
- 2-18 The zoom control 3:20
- 2-19 Print out a worksheet 8:44
- 3 12: Understand absolute and relative cell references 8:53
- 4-18: Create a formula driven conditional format 8:12
- 4-19: Insert a Sparkline into a range of cells 6:13
- 5 18 Create a combination chart containing different chart types 4:37
- 6 7 Understand worksheet groups 8:23
- 7 8 Add custom headers and footers 7:55
- Exp1-8 Convert a range into a table with a total row 6:30
- Exp1-13 Sort a range or table by custom list 3:41
- Exp2-7 Validate numerical data 6:45
- Exp3-5 Use the IF logic function 8:51
- Exp3-21 Extract text using the FIND and LEN functions 9:53
- Exp3-22 Use a VLOOKUP function for an exact lookup 7:14
- Exp4-1 Automatically create single-cell range names 4:48
- Exp4-16 Use Speak Cells to eliminate data entry errors 8:02
- Exp5-1 Create a one dimensional pivot table report from a table 10:52
- Exp5-7 Filter a pivot table visually using slicers 7:05
- Exp6-1 Create a single-input data table 9:06
- Exp6-11 Restrict the cells users are allowed to change 8:38
- Exp7-3 Hyperlink to worksheets and ranges 6:17
- Exp7-10 Three different ways to share a document 3:22