Microsoft Office 2013
Mastering Access 2013
- 01: Getting Started (10:47)
02: Database Objects (10:49)
03: Creating a Database (7:26)
04: Creating Tables (8:31)
05: Importing External Data (7:56)
06: Creating Linked Tables (5:02)
07: Creating Tables from Templates (2:53)
08: Working with Records in a Table (5:49)
09: Tables and Forms (7:38)
10: Planning Tables and Forms (8:03)
11: Creating a Table in Design View (7:50)
12: Managing Table Relationships, Part 1 (5:49)
13: Managing Table Relationships, Part 2 (5:24)
14: Controlling Data Entry, Part 1 (10:12)
15: Controlling Data Entry, Part 2 (6:59)
16: Controlling Data Entry, Part 3 (13:30)
17: Working with Tables (3:58)
18: Importing Data from Other Sources (9:28)
19: Import and Link Data from Other Sources (8:47)
20: Import and Link Data from Excel (3:44)
21: Creating a Select Query (10:10)
22: Working with Criteria (7:12)
23: Doing More with Queries (4:43)
24: Group and Summarize Data in a Query (8:00)
25: Creating Flexible Queries (9:01)
26: Creating Action Queries, Part 1 (6:37)
27: Creating Action Queries, Part 2 (6:55)
28: Creating and Modifying Forms (6:29)
29: Modify Forms in Design View, Part 1 (10:27)
30: Modify Forms in Design View, Part 2 (5:36)
31: Add Controls to Forms (7:18)
32: Tab Pages and Form Control Properties (6:05)
33: Create and Modify Reports Wizard (5:17)
34: Modify Reports in Design View (7:27)
35: Formatting Reports (4:22)
36: Adding Calculations to a Report (12:42)
37: Putting Finishing Touches on a Report (5:11)
38: Modify Startup Options (6:20)
39: Maintaining a Database, Part 1 (7:33)
40: Maintaining a Database,Part 2 (9:35)
41: Merging Databases (7:15)
42: Exporting to External Locations (7:26)
43: Saving Databases (3:37)
44: Creating a Web App from a Template (9:18)
45: Creating a Custom Web App (5:13)
5h 5m
0
0
Mastering Excel 2013
Mastering Excel 2013 – Basics
01: Looking at Excel 2013 (8:59)
02: Worksheet Navigation, Part 1 (6:50)
03: Worksheet Navigation, Part 2 (8:15)
04: Sheet Tab Options (6:41)
05: The Excel Interface (9:36)
06: The Status Bar (9:54)
07: Keyboard Shortcuts (10:10)
08: File Types (9:49)
09: Open, Save, & AutoSave (14:45)
10: Templates (7:51)
11: AutoCorrect (5:48)
12: Undo and Redo (4:44)
13: Text Formatting, Part 1 (9:02)
14: Text Formatting, Part 2 (9:27)
15: The Windows Clipboard (12:17)
16: Microsoft Office Clipboard (6:32)
17: Highlighting and Navigating in a Workbook (11:52)
18: Entering Data in Series (8:54)
19: Flash Fill (6:43)
20: Formulas (13:04)
21: Intro to Functions (8:59)Mastering Excel 2013 – Intermediate
1: Adding Hyperlinks (4:31)
2: Scientific Equations (6:46)
3: Find and Replace (8:10)
4: Spellcheck and References (9:12)
5: Shapes, Part 1 (11:19)
6: Shapes, Part 2 (8:42)
7: Pictures (11:13)
8: Pictures + Shapes = Awesome (4:04)
9: ClipArt & SmartArt (10:11)
10: Text Boxes (6:02)
11: Financial Functions (9:55)
12: Data and Time Functions (9:09)
13: Text Functions (7:48)
14: Logical, Math, and Statistical Functions (8:31)
15: vLookup & Misc Functions (8:36)
16: New Functions in 2013 (6:35)
17: Formatting Cells & Ranges, Part 1 (8:10)
18: Formatting Cells & Ranges, Part 2 (10:43)
19: Tables (12:36)
20: Sorting and Filtering (11:51)
21: Importing Data (8:53)
22: Intro to Charts (4:27)
23: Choosing the Right Chart (5:36)
24: Chart Data (3:49)
25: Optimizing Charts (10:57)
26: New Chart Formatting Options (12:17)27: Sparklines (5:26)
28: Manipulating Text with Functions (8:36)
29: Printing Worksheets (11:37)
30: Working with Print Area (5:29)Mastering Excel 2013 – Advanced
1: Quick Analysis & Slicers (9:19)
2: Subtotals (6:36)
3: Creating Pivot Tables (7:48)
4: Recommended Pivot Tables (3:55)
5: Customizing Pivot Tables (14:38)
6: Pivot Charts (5:18)
7: Customizing Your View, Part 1 (12:47)
8: Customizing Your View, Part 2 (3:51)
9: Advanced Formatting (7:46)
10: Advanced Data Copy Techniques (8:35)
11: Transforming Data with the Clipboard (2:52)
12: Using Data Validation (10:33)
13: Analyzing Data: Scenario Manager (7:26)
14: Analyzing Data: Data Tables (7:48)
15: Analyzing Data: Goal Seek (2:59)
16: Text to Columns (4:36)
17: Consolidating Data (3:38)
18: Creating Macros (8:18)
19: Advanced Macros (5:53)
20: Creating Random Numbers and Custom Series (6:48)
21: External References (3:55)
22: Customizing the Ribbon and Toolbar (9:31)
23: Power View (7:52)
19h
0
0
Mastering OneNote 2013
- 01: Introduction to OneNote (3:27)
02: Pages, Sections, and Groups (3:54)
03: Navigating OneNote (4:51)
04: Managing Page Layout (11:13)
05: Organizing Notebooks (5:33)
06: Renaming Notebooks (3:43)
07: Saving and Sharing (12:48)
08: Collapsing and Expanding (3:41)
09: Creating Pages (7:50)
10: Restoring Pages (6:47)
11: Formatting Notes (10:54)
12: Handwritten Notes (8:47)
13: Math Equations (14:43)
14: Audio and Video (4:13)
15: Putting a Table in a Note (4:44)
16: Creating and Excel Spreadsheet (4:31)
17: Linking Notes (6:34)
18: Advanced Quick Notes and Links (15:13)
19: Changing Views (8:33)
20: Moving or Copying Notes (3:34)
21: Tagging (5:27)
22: Searching (3:31)
23: Deleting and the Recycle Bin (7:45)
24: Print, Email, and Blog (7:52)
25: Co-Authoring (7:32)
26: Quick Filing (10:51)
27: Personalizing (11:29)
3h 25m
0
0
Mastering Outlook 2013
- 01: The Interface (12:39)
02: Sending Email (12:51)
03: Email Formatting (8:21)
04: Email Attachments (9:09)
05: Email Signatures (5:57)
06: Email Options (12:45)
07: Tracking Sent Messages (9:42)
08: Managing Incoming Messages (10:14)
09: Search, View, & Print (9:24)
10: Search Folders
11: Intro to Calendar (5:47)
12: Appointments & Reminders (13:41)
13: Meetings (13:03)
14: Multiple Calendars (8:41)
15: Calendar Groups
16: People (Contacts) (8:06)
17: Contact Groups & Views (7:58)
18: Managing Contacts (4:48)
19: Social Media Connector
20: Tasks (8:47)
21: Recurring Tasks & Delegation (8:09)
22: Notes (5:32)
23: Journal
24: Quick Tips (13:48)
25: Categories (7:57)
26: Rules (12:37)
27: Multiple Accounts and Data Files
28: Privacy and IRM
29: Using the Outlook Web App, Part 1
30: Using the Outlook Web App, Part 2
31: Clean Up Options (14:11)
5h
0
0
Mastering PowerPoint 2013
- 01: Introduction to PowerPoint (8:18)
02: Adding Content to Slides (7:21)
03: Importing Text Files and Outlines (4:22)
04: Basic Text Editing (10:41)
05: Editing Slide Design (12:05)
06: Copying Slides (2:46)
07: Adding Notes and Pictures (11:29)
08: Basic Picture Manipulation (3:12)
09: Adjusting Objects on a Slide (10:41)
10: Slide Show Mode (16:42)
11: Presenter View (10:00)
12: Tips for Using Projectors and Monitors (3:16)
13: Printing Slides and Handouts (7:40)
14: Sorting Slides (6:55)
15: Using Other Views (4:42)
16: Adding Tables (5:38)
17: Modifying Table Cells and Styles (7:08)
18: Formatting Paragraphs and Pasting Options (14:51)
19: Adding and Modifying Charts and Graphs (12:54)
20: Importing Tables and Charts (4:48)
21: Inserting and Manipulating Text Boxes (14:28)
22: Applying Text Effects (4:47)
23: Working with Text Boxes (5:30)
24: Basic Audio and Video (15:12)
25: Adding Effects to Audio and Video Objects (2:07)26: Shapes (12:36)
27: Creating Custom Shapes (14:00)
28: Aligning and Grouping Shapes (4:16)
29: Gridlines and Guidelines (4:23)
30: Transitions (11:15)
31: Hiding and Deleting Slides (2:54)
32: Inserting and Modifying SmartArt Graphics (7:04)
33: Inserting SmartArt with Pictures (4:01)
34: Working with SmartArt (3:18)
35: Converting SmartArt (8:09)
36: Animations (9:40)
37: Animation Options (7:02)
38: Animation Effects (3:32)
39: Animation Pane (8:54)
40: Animation Painter (6:49)
41: Animation Triggers (7:35)
42: Animation Triggers from Video Bookmark (7:43)
43: Video Options and Editing (5:44)
44: Setting a Poster Frame for a Video (4:54)
45: Creating Fades in a Video (2:10)
46: Looping and Cropping a Video (4:01)
47: Embedding Fonts (2:06)
48: Zoom (2:38)
49: Editing Pictures (14:11)
50: Applying Picture Effects (4:06)
51: Action Buttons and Hyperlinks (10:50)52: Reusing Slides (7:12)
53: Custom Slide Shows (3:06)
54: Quick Access Toolbar (3:43)
55: Customizing PowerPoint Options (6:12)
56: Changing Auto Recovery Options (2:20)
57: Headers and Footers (4:34)
58: Sections (2:14)
59: Screenshots (4:29)
60: Spell Check and Thesaurus (10:14)
61: Format Painter (2:26)
62: Save As Options (7:58)
63: Compare, Merge, Markup, and Review (11:26)
64: Compressing Media (6:31)
65: Rehearsing Timings and Record a Slide Show (12:22)
66: Narrations, Timings, and Media Control (4:05)
67: Set Up a Slide Show (5:23)
68: Sharing a Slide Show (5:29)
69: Exporting a Presentation (3:42)
70: Finalizing a Presentation (10:57)
71: Picture Albums (7:21)
72: Editing a Slide Master (10:45)
73: Opening an Existing Presentation (1:38)
74: PowerPoint Online Web App (8:53)
75: Sharing and Co-Authoring in PowerPoint Online (4:39)
9h 15m
0
0
Mastering Word 2013
- 01: The Ribbon (4:42)
02: Status Bar (9:24)
03: Adding Text (4:48)
04: Navigation Pane (13:25)
05: Selecting Text (6:59)
06: Cut, Copy, and Paste (8:27)
07: Undo and Redo (5:16)
08: The Backstage View (8:37)
09: Document Types (8:38)
10: Templates (9:27)
11: Finding Files (6:19)
12: Saving (6:52)
13: Printing (4:31)
14: Advanced Printing (8:07)
15: Fonts (9:29)
16: Choosing Fonts (8:10)
17: Basic Formatting (7:24)
18: Changing Case (3:21)
19: Text Effects (9:59)
20: Aligning and Justifying (3:25)
21: Indents (5:12)
22: Tabs (9:25)
23: Line and Paragraph Spacing (5:43)
24: Bullets and Numbering (11:58)
25: Widow and Orphan Controls (4:21)
26: Shading and Borders (5:46)
27: Intro to Styles (11:52)
28: Themes and Overriding Styles (8:47)
29: Managing Style Sets (7:50)
30: Using the Style Organizer (5:15)31: Navigating in Style (2:43)
32: Applying Styles and Clearing Formatting (7:09)
33: Create Quick Style (4:20)
34: Table of Contents (9:04)
35: Hyperlinks and Bookmarks (5:50)
36: Footnotes, Citations, Bibliography (13:13)
37: Index (14:01)
38: Table of Authorities, Table of Figures (6:41)
39: Introduction to Tables (8:41)
40: Text to Tables (4:26)
41: Formatting Tables (4:47)
42: Rows and Columns (7:17)
43: Sorting Table Data (7:04)
44: Merging and Splitting Cells (6:35)
45: Convert a Table to Text (2:32)
46: Insert Excel Spreadsheet for Calculations and Charts (8:23)
47: Using Formulas in a Table (7:50)
48: Pictures and Shapes (11:42)
49: Position, Sizing, and Cropping Graphics (8:07)
50: Layout with Tables (6:32)
51: Adjusting Photos (2:54)
52: Special Effects for Graphics (6:06)
53: Applying Styles to Graphics (5:36)
54: Using Excel Charts (11:27)
55: SmartArt (6:18)
56: Screenshot (4:25)
57: WordArt (4:08)
58: Headers and Footers (6:28)59: Cover Pages (4:16)
60: Text Boxes (8:49)
61: Equations, Symbols, and Objects (9:47)
62: Margins, Orientation, and Paper Size (4:37)
63: Sections (7:26)
64: Master and Sub Documents (5:43)
65: Columns (4:47)
66: Watermarks, Page Color, and Page Borders (4:50)
67: Building Blocks (9:53)
68: Spelling and Grammar (5:30)
69: AutoCorrect Options (8:02)
70: Thesaurus and Research Tools (4:14)
71: Tracking Changes, Showing Marks (8:05)
72: Accepting or Rejecting Changes (6:29)
73: Comparing and Combining Documents (6:00)
74: Restricting Editing (10:23)
75: Digital Signatures (5:13)
76: Customizing Your Quick Access Toolbar (3:00)
77: Changing Word Options (11:44)
78: Customizing the Ribbon (5:14)
79: Creating and Playing Macros (9:38)
80: Adding Macros to the Ribbon (3:43)
81: Keyboard Shortcuts (7:45)
82: Mailmerge (10:07)
83: Forms and Fields (7:19)
84: Using the World Web App (5:01)
85: Saving and Editing Word Documents in the Cloud (6:33)
86: Customizing Your View (3:59)
18h
0
0
Migrating from Office 2003 to 2013
- 01: The Ribbon (5:54)
02: Other Interface Changes (7:46)
03: File Type Changes (5:49)
04: The Backstage View (5:24)
05: Formatting Enhancements (5:21)
06: Excel Changes (6:28)
07: Word Changes (3:59)
08: PowerPoint Changes (7:47)
09: Microsoft OneNote (5:50)
10: Outlook Changes (5:54)
1h
0
0
What’s New in Excel 2013
- 01: New Functions (6:33)
02: Flash Fill (6:43)
03: Quick Analysis & Slicers (9:17)
04: Optimizing Charts (10:56)
05: New Chart Formatting Options (12:14)
06: Pivot Charts (5:14)
07: Recommended Pivot Tables (3:53)
08: Power View (7:50)
60h
0
0
What’s New In Word 2013
- 01: Intro & Status Bar (9:30)
02: Backstage View (9:52)
03: Styles (5:28)
04: Positioning, Sizing, & Cropping Graphics (7:34)
05: Wrapping Text Around Graphics (8:00)
06: Tracking Changes & Showing Markup (7:54)
50m
0
0
What’s New In PowerPoint 2013
- 01: Changes (9:46)
02: Working with Sizes (10:42)
03: Backgrounds & Notes (2:43)
04: Misc Format Changes in PowerPoint 2013 (5:01)
05: New Transitions (2:03)
06: Presenter View (8:05)
07: Eye Dropper (4:01)
08: Animations (1:34)
09: Insert Pictures (6:04)
10: Merge (3:51)
11: Guides (3:50)
12: Movie & Music Clips (9:53)
13: Comments (1:46)
14: Presenting Online (6:53)
1h 25m
0
0