Instructor | ToIT
SharePoint Online Basics
- 01: Introduction (3:02)
02: Site Creation – Communication Sites (7:25)
03: Site Creation – Team Sites (12:06)
04: Working with Documents (12:13)
05: Co-Authoring and Check Out (7:11)
06: Major Versions (3:19)
07: Minor Versions and Content Approval (7:30)
08: Document Metadata (9:05)
09: Classic Experience and Changing Views (8:04)
10: Navigation (9:43)
11: Basic Lists (11:20)
12: List Apps and Calendars (5:40)
13: Search (9:57)
14: Customization (12:55)
2h
0
0
SharePoint Online Essentials 2018
- 01: Intro to SharePoint Online (9:08)
02: SharePoint – Creating Team Sites (14:04)
03: SharePoint – Communication Sites (14:29)
04: SharePoint – Adding Pages (4:25)
30m
0
0
Microsoft 365 Office Essentials (2020)
- Introduction 6:01
Office 365 Home Page 11:29
Office 365 Navigation Bar 12:41
Microsoft Search 14:03
Accessing Help 9:35
Outlook Email
Outlook Email Basics, Part 1 7:50
Outlook Email Basics, Part 2 9:55
Email Search and Filters 11:45
Email Folders 12:39
To Do
To Do and Flagged Emails 9:55
To Do and My Day 5:05
Outlook Calendar
Outlook Calendar Basics 5:31
Adding Calendar Events, Part 1 8:37
Adding Calendar Events, Part 2 9:26
OneDrive
Introduction to OneDrive 8:13
Using OneDrive Online, Part 1 10:07
Using OneDrive Online, Part 2 7:33
Using OneDrive Online, Part 3 6:18
Office and Mobile Apps
Office Apps, Part 1 10:44
Office Apps, Part 2 5:12
Mobile Apps 7:39
3h 10m
0
0
Microsoft 365 Admin Tips and Tricks
- Administration
Introduction 1:04
Navigating the Admin Center 2:13
Managing Users 7:22
Managing Groups 10:27
Managing Shared Mailboxes 6:29
Viewing Usage Reports 5:57
Using Services and Add-Ins 5:12
Configuring Multi-Factor Authentication 7:34
Configuring Email DNS Records 6:17
Service Management
Managing Azure AD, Part 1 6:15
Managing Azure AD, Part 2 7:48
Managing Microsoft Teams 4:20
Managing SharePoint and OneDrive 4:16
Managing Devices, Part 1 7:33
Managing Devices, Part 2 4:13
Managing Exchange, Part 1 5:43
Managing Exchange, Part 2 10:16
Managing Exchange, Part 3 8:54
Configuring Alerts 5:20
1h 57m
0
0
Mastering Excel 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)
10h
0
0
Mastering PowerPoint 2010
- 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)
7h 25m
0
0
Mastering Word 2010
- 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)
9h
0
0
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