Microsoft Office 2010

1: Introduction (0:52)
2: Workbooks & Worksheets (8:38)
3: Adding & Changing Worksheets (6:39)
4: Basic Text & Number Entry (12:39)
5: The Excel Interface, Part 1 (6:36)
6: The Excel Interface, Part 2 (15:01)
7: Keyboard Shortcuts (10:02)
8: File Types (9:42)
9: Open, Save, and Autosave (14:37)
10: Templates (7:50)
11: Autocorrect (5:49)
12: Undo & Redo (4:40)
13: Text Formatting, Part 1 (9:01)
14: Text Formatting, Part 2 (9:25)
15: Adding Hyperlinks (4:32)
16: Scientific Equations (6:46)
17: The Windows Clipboard (12:17)
18: The Office Clipboard (6:32)
19: Find & Replace (8:10)
20: Spellcheck and References (9:12)
21: Shapes (11:19)
22: Shapes, Part 2 (8:42)
23: Pictures (11:13)
24: Pictures + Shapes (4:04)
25: Clipart & SmartArt (10:11)
26: Text Boxes (6:02)
27: Highlighting and Navigating in a Workbook (11:53)
28: Insert, Delete, Hide, Unhide (10:15)
29: Entering Data in Series (8:54)
30: Formulas and Order of Operations (13:04)
31: Intro to Functions (8:59)
32: Financial Functions (9:55)
33: Date & Time Functions (9:08)
34: Text Functions (7:49)
35: Logical, Math, & Statistical Functions (8:39)
36: vLookup & Misc Functions (8:35)
37: Formatting Cells & Ranges (8:10)
38: Number Formatting (10:42)

39: Tables (12:36)
40: Sorting & Filtering (11:54)
41: Sub Totals (6:36)
42: Pivot Tables (7:49)
43: Customizing Pivot Tables (14:35)
44: Importing Data (8:54)
45: Intro to Charts (4:27)
46: Choosing the Right Chart (5:36)
47: Chart Data (3:50)
48: Advanced Chart Formatting (11:37)
49: Pivot Charts (2:58)
50: Sparklines (5:26)
51: Customizing Your View, Part 1 (12:47)
52: Customizing Your View, Part 2 (3:51)
53: Advance Formatting (7:46)
54: Advance Data Copy Techniques (8:35)
55: Transforming Data with the Clipboard (2:53)
56: Manipulating Text with Functions (8:36)
57: Printing Worksheets (11:37)
58: Working with Print Area (5:29)
59: Print Titles, Headers, and Footers (9:27)
60: Using Data Validation (10:34)
61: Analyzing Data with Scenario Manager (7:26)
62: Analyzing Data with Data Tables (7:49)
63: Analyzing Data with Solver and Goal Seek (3:03)
64: Text to Columns (4:36)
65: Consolidating Data (3:38)
66: Creating Macros (8:11)
67: Advance Macros (5:56)
68: Custom Series (6:49)
69: Conditional Formatting, Part 1 (6:15)
70: Conditional Formatting, Part 2 (10:05)
71: External References (3:54)
72: Exporting and Sharing (5:33)
73: Comments (3:55)
74: Customizing the Ribbon & Quick Access Toolbar (9:31)
75: Conclusion (0:41)

01: Introduction (4:35)
02: Slide Layouts (6:57)
03: Changing Slide Designs (4:54)
04: Inserting Pictures and ClipArt (8:49)
05: Manipulating Photos (3:10)
06: Layers on a Slide (9:33)
07: Presentation Mode (10:44)
08: Presenter View (5:44)
09: Printing (8:31)
10: Selecting Slides (6:53)
11: Selecting Slides (1:54)
12: Adding Tables (5:32)
13: Modifying Table Styles (6:54)
14: Paragraph Formatting (14:38)
15: Adding Charts and Graphs (5:53)
16: Modifying Charts and Graphs (5:35)
17: Editing Chart Types (10:43)
18: Text Boxes and Shape Effects (11:11)
19: Text Effects (4:40)
20: Text Boxes and Columns (5:26)
21: Audio and Video (4:06)
22: Adding Effects to Audio and Video (2:11)
23: Inserting Shapes (9:04)
24: Adding Text to Shapes, Setting Defaults (4:21)
25: Transitions (4:47)
26: Transition Options (11:00)
27: Hiding and Deleting Slides (2:54)
28: Introduction to SmartArt (9:38)
29: SmartArt with Pictures (4:16)
30: Changing SmartArt (3:09)
31: Converting SmartArt (7:53)
32: Animations (8:31)
33: Animation Options (7:28)
34: Animation Pane (8:42)
35: Animation Painter (6:53)
36: Animation Triggers (7:28)

37: Animation Triggers from Video Bookmarks (8:04)
38: Animation Text (3:00)
39: Editing Video, Part 1 (5:31)
40: Editing Video, Part 2, Poster Frames (4:47)
41: Editing Video, Part 3, Fade in and Out (2:03)
42: Editing Video, Part 4, Looping and Cropping (3:54)
43: Pinning Recent Files (1:35)
44: Embedding Fonts for Compatibility (3:04)
45: The Quick Access Toolbar (3:40)
46: Converting Videos to WMV Format (3:30)
47: Changing Slide Background (3:00)
48: Customizing PowerPoint Options (5:33)
49: Changing Auto Recovery Options (2:14)
50: Zoom (2:33)
51: Removing Backgrounds (7:31)
52: Headers and Footers (5:11)
53: Formatting Sections (3:05)
54: Screenshot (4:12)
55: Spellcheck and Thesaurus (11:05)
56: Format Painter (2:18)
57: Orientation and Custom Size (2:50)
58: Editing Pictures (14:18)
59: Picture Effects (3:53)
60: PowerPoint Show and Save As Options (5:57)
61: Action Buttons and Action Settings (10:43)
62: Compare, Markup, and the Review Pane (12:25)
63: Rehearse and Record a Slide Show, Part 1 (14:41)
64: Rehearse and Record a Slide Show (2:25)
65: Setup a Slide Show (4:14)
66: Saving and Sending (5:47)
67: Reusing Slides (6:40)
68: Custom Slide Shows (3:03)
69: Review Comments and Markup (7:44)
70: Picture Albums (7:42)
71: Conclusion (0:51)

01: Introduction (0:57)
02: The Ribbon (8:07)
03: The Vertical Scrollbar (8:17)
04: The Status Bar and View Options (8:13)
05: Adding Text (4:42)
06: Navigation Pane (13:16)
07: Selecting Text (6:50)
08: Cut, Copy, and Paste (14:38)
09: Undo and Redo (3:05)
10: The Backstage View (15:45)
11: Document Types (6:54)
12: Templates (4:36)
13: Finding Files (5:42)
14: Saving (7:01)
15: Printing (4:22)
16: Advanced Printing (8:36)
17: Fonts (9:30)
18: Choosing Fonts (8:30)
19: Basic Formatting (4:15)
20: Case (3:22)
21: Text Effects (6:28)
22: Justifying and Aligning (3:15)
23: Indents (7:15)
24: Tabs (9:16)
25: Line Spacing (5:35)
26: Bullets (12:31)
27: Widows and Orphans (4:22)
28: Shades (5:34)
29: Styles (7:27)

30: Themes and Overriding Styles (8:47)
31: Navigating in Style (2:37)
32: Applying Styles and Clearing Formatting (5:43)
33: Creating a Quick Style Set (3:43)
34: Table of Contents (8:56)
35: Hyperlinks and Bookmarks (6:09)
36: Footnotes, Citations, and Bibliography (7:08)
37: Index and Table of Figures (5:20)
38: Introduction to Tables (8:31)
39: Text to Tables (4:26)
40: Formatting Tables (4:35)
41: Adding and Removing Columns (7:05)
42: Sorting Table Data (6:56)
43: Merging and Splitting Table Cells (6:47)
44: Converting a Table to Text (2:25)
45: Inserting an Excel Spreadsheet (7:24)
46: Quick Tables (2:39)
47: Pictures, Shapes, and ClipArt (10:58)
48: Positioning, Sizing, and Cropping (5:23)
49: Wrapping Text Around Graphics (12:54)
50: Graphic Layout with Tables (6:26)
51: Adjusting Photos (2:49)
52: Special Effects for Graphics (5:54)
53: Applying Styles to Graphics (5:31)
54: Using Excel Charts in Word (5:55)
55: SmartArt (3:59)
56: Screenshot (2:07)
57: WordArt (3:57)
58: Headers and Footers (4:24)

59: Cover Page (4:11)
60: Text Boxes (4:53)
61: Equations, Symbols, and Objects (5:55)
62: Margins, Orientation, and Paper Size (4:29)
63: Sections (7:21)
64: Columns (6:56)
65: Watermarks, Page Borders, and Page Colors (4:40)
66: Spelling and Grammar (3:05)
67: Proofing and AutoCorrect (7:52)
68: Thesaurus and Research Tools
69: Tracking Changes and Showing Markup (6:31)
70: Accepting or Rejecting Changes (6:19)
71: Comparing and Combining Documents (6:27)
72: Emailing Documents (3:34)
73: Restricting Editing (8:01)
74: Digital Signatures (5:03)
75: Customizing the Quick Access Toolbar (2:52)
76: Word Options (10:08)
77: Customizing the Ribbon (5:14)
78: Creating and Playing Macros (9:27)
79: Adding a Macro to the Ribbon (3:38)
80: Keyboard Shortcuts (6:15)
81: Mail merge (11:41)
82: Using Forms and Fields (3:42)
83: Switching Windows (1:02)
84: Mail Merge (10:15)
85: Fields and Forms (6:57)
86: Conclusion (0:46)