Microsoft Office 2019
Mastering Access 2019
Lessons Include:
01: Introduction (2:09)
02: Navigating the Interface (8:34)
03: Selecting Data (8:47)
04: Using Commands (7:13)
05: Creating a New Workbook (8:03)
06: Entering Cell Data (5:59)
07: Using AutoFill (7:26)
08: Using Flash Fill (4:59)
09: Using Excel Help (2:04)
10: Creating Formulas (7:57)
11: Inserting Functions (8:13)
12: Copying Formulas and Functions (7:08)
13: Using Absolute References (9:51)
14: Inserting and Deleting Cells (8:50)
15: Searching and Replacing (7:54)
16: Using Proofing and Researching Tools (6:57)
17: Applying Text Formats (8:34)
18: Applying Number Formats (7:23)
19: Customizing Number Formats (7:46)
20: Aligning Cell Contents (7:16)
21: Applying Cell Styles (5:20)
22: Applying Themes (3:48)
23: Inserting Hyperlinks (6:30)
24: Applying Conditional Formatting to Numbers (6:44)
25: Applying Conditional Formatting to Text and Dates (7:55)
26: Applying Comparative Analysis Formatting (7:22)27: Using Templates (6:00)
28: Printing Workbooks (4:11)
29: Setting the Page Layout (6:34)
30: Inserting Page Breaks (8:38)
31: Configuring Headers and Footers, Part 1 (5:09)
32: Configuring Headers and Footers, Part 2 (4:04)
33: Managing Worksheets, Part 1 (5:02)
34: Managing Worksheets, Part 2 (7:39)
35: Creating a Custom View (3:47)
36: Managing Worksheet Views (6:00)
37: Managing Workbook Views (6:22)
38: Managing Workbook Properties (4:13)
39: Customizing General Options (4:35)
40: Customizing the Ribbon (7:02)
41:Customizing the Quick Access Toolbar (5:50)
Mastering Excel 2019 – Intermediate
Lessons Include:
Working with Functions
Introduction (1:47)
Using Named Ranges, Part 1 (5:16)
Using Named Ranges, Part 2 (5:32)
Using Named Ranges, Part 3 (5:10)
Working with Date Functions, Part 1 (9:15)
Working with Date Functions, Part 2 (4:38)
Working with Date Functions, Part 3 (3:41)
Working with Time Functions (5:50)
Working with Logical Functions (9:03)
Working with Conditional Functions (8:16)
Multiple Criteria Functions (5:23)
Using IFS and SWITCH Functions (5:57)
Using Nested Functions (6:21)
Working with Text Functions, Part 1 (4:22)
Working with Text Functions, Part 2 (4:55)
Working with Text Functions, Part 3 (3:49)
Working with Text Functions, Part 4 (8:56)
Working with Math Functions (7:55)
Working with Lists
Sorting Data, Part 1 (5:31)
Sorting Data, Part 2 (6:00)
Filtering Data, Part 1 (5:25)
Filtering Data, Part 2 (8:06)
Filtering Data, Part 3 (8:28)
Querying with Database Functions (7:16)
Using the Subtotal Function (4:43)
Using the Subtotal Feature (7:09)
Analyzing Data
Creating Tables (6:45)
Modifying Table Styles (7:10)
Summarizing Data in Tables (1:56)
Using the Quick Analysis Shortcut (4:35)
Customizing Conditional Formatting (6:07)
Using Formulas with Conditional Formatting (6:17)
Visualizing Data with Charts
Creating Charts (5:48)
Using Chart Types (2:30)
Changing Chart Data Source (6:46)
Adding Chart Elements (10:19)
Formatting a Chart (5:23)
Using Advanced Chart Features (4:44)
Applying Trendlines (4:36)
Creating a Chart Template (3:31)
Inserting Graphics
Inserting Graphics (9:15)
Modifying Graphics, Part 1 (12:38)
Modifying Graphics, Part 2
Using PivotTables and Pivot Charts
Creating a PivotTable (12:14)
Summarizing Data in a PivotTable (8:38)
Grouping Data in a PivotTable (6:33)
Formatting a PivotTable (7:42)
Selecting and Moving PivotTables (3:15)
Changing PivotTable Options (8:38)
Adding Calculated Fields (2:03)
Presenting Data with PivotCharts (4:29)
Using Slicers (7:45)
Using Timeline Slicers (1:51)
Mastering Outlook 2019
Lessons Include:
01: Introduction (2:56)
02: Navigating the Interface (7:15)
03: Working with Messages Part I (5:22)
04: Working with Messages Part II (5:04)
05: Accessing Help (5:17)
06: Adding Message Recipients (4:50)
07: Checking Spelling & Grammar (5:37)
08: Formatting Message Content (6:14)
09: Attaching Files & Items (6:11)
10: Receiving Attachments (2:10)
11: Adding Illustrations (6:48)
12: Managing Automatic Message Content (8:04)
13: Customizing Reading Options (7:03)
14: Tracking Messages (3:35)
15: Marking Messages: Categories (5:53)
16: Marking Messages: Flags (4:43)
17: Organizing with Folders (5:53)
18: Managing Contacts (4:38)
19: Managing Contact Groups (3:54)
20: Viewing Contacts (5:19)
21: Viewing the Calendar (4:21)
22: Creating Appointments (7:06)
23: Scheduling Meetings (9:26)
24: Creating Tasks (4:27)25: Creating Notes (2:18)
26: Modifying Message Properties (4:03)
27: Adding Email Accounts (2:03)
28: Customizing Options (8:05)
29: Sorting Messages (5:05)
30: Filtering Messages (4:23)
31: Searching and Search Folders (6:43)
32: Managing Junk Email (6:29)
33: Managing Mailbox Size (4:35)
34: Using Automatic Replies (6:54)
35: Using Message Rules (9:33)
36: Using Quick Steps (3:13)
37: Setting Calendar Options (5:56)
38: Managing Additional Calendars (5:34)
39: Managing Meeting Responses (4:00)
40: Importing and Exporting Contacts (6:56)
41: Using Electronic Business Cards (4:50)
42: Assigning Tasks (3:32)
43: Delegating Folder Access (4:57)
44: Sharing Your Calendar (4:42)
45: Sharing Your Contacts (2:49)
46: Using Auto-Archive (9:23)
47: Using Online Archive (8:59)
Mastering PowerPoint 2019 – Basic
- Getting Started
Introduction 7:11
The PowerPoint Interface 7:48
View and Navigate a Presentation 11:43
Slideshow Options 4:30
Create and Save 6:27
Developing a Presentation
Select a Presentation Type 5:01
Editing Text, Part 1 6:50
Editing Text, Part 2 8:52
Arranging Slides 6:49
Working with Themes 10:02
Advanced Text Editing
Formatting Characters 7:53
Lists 5:14
Alignment and Spacing 6:02
Text Options 9:24
Format Text Boxes 6:22
Graphical Elements
Insert Images 8:23
Creating Photo Albums 8:30
Insert and Edit Shapes 9:16
Modifying Objects
Edit Pictures, Part 1 7:19
Edit Pictures, Part 2 4:58
Picture Styles 5:48
Group Objects 4:26
Arrange Objects 9:06
Animate Objects, Part 1 6:04
Animate Objects, Part 2 8:06
Table and Charts
Add a Table 4:48
Table Layout 6:37
Table Design 6:40
Insert a Table from Other Applications 4:32
Creating a Chart 9:41
New Chart Types 2:33
Designing a Chart 4:12
Formatting a Chart 10:30
Inserting a Chart from Excel 3:16
Preparing to Deliver
Review Presentation, Part 1 8:58
Review Presentation, Part 2 2:58
Accessibility 4:02
Apply Transitions 5:54
Morph Transition 5:45
Printing Your Presentation 3:21
Delivering Your Presentation 7:30
Exporting Presentations 7:11
PowerPoint Online
PowerPoint Online 6:04
Viewing and Navigating Online 5:04
Editing in PowerPoint Online 5:10
Online Feature Review 4:13
Mastering PowerPoint 2019 – Advanced
- Modifying the Environment
Customizing the Interface 4:33
Customizing the Ribbon 7:25
Setting Windows Options 6:32
Setting PowerPoint Options 5:39
Customizing Design Templates
Modifying Slide Masters, Part 1 8:57
Modifying Slide Masters, Part 2 11:33
Inserting Headers and Footers 6:11
Modifying Notes and Handout Masters 4:22
Adding Advanced Graphics
Creating SmartArt 4:26
Modifying SmartArt 10:08
Inserting 3D Models 6:54
Inserting SVGs and Icons 5:56
Inking, Part 1 8:59
Inking, Part 2 4:37
Writing Math Equations 8:38
Working with Media
Adding Audio 6:39
Editing Audio 6:57
Adding Video, Part 1 7:26
Adding Video, Part 2 7:17
Customizing Animations 11:31
Animating with Bookmarks 3:43
Timing Slide Transitions 2:37
Collaborating on Presentations
Inserting Sections 4:07
Adding Comments 6:23
Using Compare and Merge 10:27
Inserting a Form 6:07
Viewing Form Responses 3:44
Sharing on the Web 11:15
Customizing a Slide Show
Annotating a Presentation 5:48
Using Presenter View 11:35
Using Set Up Slide Show 6:30
Creating a Custom Show 4:55
Adding Captions and Subtitles 9:06
Using Translation and Dictation 4:19
Adding Hyperlinks 4:19
Inserting Action Buttons 9:40
Using Zoom 8:16
Securing and Distributing Presentations 38
Recording a Presentation, Part 1 7:32
Recording a Presentation, Part 2 7:10
Securing a Presentation 11:57
Creating a Video of a Presentation 3:17
Creating a CD of a Presentation 3:48
Mastering Word 2019
- Getting Started
Introduction 1:42
Navigating in Word, Part 1 10:26
Navigating in Word, Part 2 4:06
Creating Documents 7:03
Saving Revised Documents 3:29
Managing Your Workspace 4:31
Selecting Text 3:45
Copying and Moving Text 7:01
Editing Paragraphs 4:20
Previewing and Printing 3:34
Customizing Word 5:38
Formatting Text
Applying Character Formatting 8:47
Controlling Paragraph Layout 4:26
Indenting Paragraphs 6:23
Controlling Spacing 4:39
Aligning Text with Tabs 7:24
Formatting Lists 3:35
Applying Borders and Shading 4:16
Working Efficiently
Using Find and Replace 5:21
Applying Repetitive Formatting 6:55
Using Styles 5:50
Creating a Style 2:07
Managing Lists
Sorting Lists 3:30
Formatting Lists 3:26
Resequencing Lists 1:31
Adding Tables
Inserting a Table 5:17
Modifying a Table 4:53
Formatting a Table 2:49
Converting Text to a Table 4:54
Inserting Graphics
Inserting Symbols 4:33
Adding Images 9:44
Controlling Page Appearance
Formatting Pages 2:28
Adding Headers and Footers 7:13
Controlling Page Layout 5:57
Adding a Watermark 2:37
Preparing to Publish
Checking Grammar and Readability 5:53
Using Research Tools 5:35
Checking Accessibility 7:48
Saving to Other Formats 3:53
What’s New in Outlook 2019
Lessons Include:
01: Integration with OneDrive (3:28)
02: Focused Inbox (3:32)
03: SVG Icons (3:20)
04: Accessibility Features (3:17)
05: New Calendar Features (5:54)
06: More Features (4:52)
07: Groups (1:25)
What’s New in Word 2019
Lessons Include:
01: SVG Images and Icons (6:29)
02: 3D models (5:54)
03: Online Images (5:18)
04: Sharing and Co-Authoring (7:09)
05: Dictate and Translate (3:09)
06: LinkedIN Integration (3:10)
07: Ink and Drawing (9:04)
08: Using SharePoint Properties (8:52)
09: Tap (4:32)
10: Accessibility Enhancements (5:25)
11: Editor (6:07)
12: Researcher and Smart Lookup (8:20)
13: Other Improvements (8:07)
What’s New in Excel 2019
Lessons Include:
01: Charts and Images (13:02)
02: Sharing (7:43)
03: TEXTJOIN and CONCAT (6:44)
04: IFS, MAXIFS, and MINIFS (7:17)
05: SWITCH (2:53)
06: Ink and Drawing (5:18)
07: New in Backstage View (5:37)
08: Extra Features (4:57)
What’s New in PowerPoint 2019
- Modules Include:
01: Morph Transition (5:55)
02: 3D Models (6:58)
03: Vector Graphics (5:06)
04: Updated Inking Part I (8:59)
05: Updated Inking Part II (4:37)
06: Several Small Updates (7:00)
07: Zoom (8:17)
08: Recording Part I (7:33)
09: Recording Part II (7:19)
10: Translation and Dictation (4:19)
11: Accessibility (4:02)
- 1
- 2