Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Office Course Bundle: Word, Excel and PowerPoint All in One
Course 1: Microsolf Word A to Z - Part 1 - Introduction
Lesson 1: Word Introduction (1:18)
Lesson 2: Backstage (8:33)
Lesson 3: Ribbon (3:00)
Lesson 4: Quick Acess Toolbar (1:32)
Part 2 - Creating text
Lesson 1: Import text (1:11)
Lesson 2: Save word documents (3:08)
Lesson 3: Zoom Options (2:10)
Part 3 - Content Editing
Lesson 1: Actions to select content (2:26)
Lesson 2: Undo va Redo (0:45)
Part 4 - Text Formatting
Lesson 2: Text Effects (1:45)
Lesson 1: Font Format (9:15)
Lesson 3: Format Painter (2:32)
Lesson 4: Character Spacing (2:23)
Lesson 5: Mini Toolbar (0:43)
Lesson 6: Create Drop Cap (1:48)
Part 5 - Paragraph Format
Lesson 1: Alignment (1:58)
Lesson 2: Indent and Line Spacing (6:31)
Lesson 3: Bullets and Numbering (2:41)
Part 6 - Document Format
Lesson 1: Page Setup (2:54)
Lesson 2: Page numbering (2:08)
Lesson 3: Watermark (1:54)
Part 7 - Style
Lesson 1: Using Style (0:51)
Lesson 2: Creating New Style (1:17)
Part 8 - Table of Contents and Index
Lesson 1 Create index (2:06)
Lesson 2: Creating citation (3:07)
Part 9 - Inserting Table
Lesson 1: Create table (0:52)
Lesson 2: Add Less Columns and Lines (0:57)
Lesson 3: Adjust Column and Line sizes (0:51)
Lesson 4: Create a frame and background for the Table (2:33)
Lesson 5: Table format (1:16)
Lesson 6: Change the Table position (1:23)
Lesson 7 Calculations in Table (1:59)
Part 10 - Inserting Charts
Lesson 1: Shape (1:20)
Lesson 2: Smartart (5:00)
Lesson 3: Chart (3:01)
Lesson 4: Screenshot (1:15)
Part 11 - Inserting Other Objects
Lesson 1: Bookmark (1:28)
Lesson 4: Object (1:38)
Lesson 2: Quick Parts (2:06)
Lesson 3: Signature Line (1:19)
Part 12 - Mailings
Lesson 1: Mail Merge (3:53)
Lesson 2: Evelopes and Labels (3:33)
Part 13 - Proofing
Lesson 1: Track Changes (3:33)
Part 14 - Printing
Lesson 1: Print text (4:14)
Part 15 - Macro
Lesson 1: Quan ly Macro (3:11)
Part 16 - Template
Lesson 1: Use and create Templates (1:49)
Part 17 - Protection
Lesson 1: Hide content (1:58)
Lesson 2: Limit text editing (2:20)
Lesson 3: Text protection (3:53)
Part 18 - Other functions
Lesson 1: Word options (3:37)
Course 2: Create Stunning Slides with PowerPoint
P1 Getting to know PowerPoint - Lesson 1: Display modes (4:03)
P1 - Lesson 2: Add Slide (3:08)
P1 - Lesson 3: Enter content (3:51)
P1 - Lesson 4: Change the layout (2:58)
P2 Format - Lesson 1: Use Theme (7:33)
P3 Table - Lesson 1: Resize column row (2:56)
P4 Diagram - Lesson 1: Change chart data (1:40)
P4 - Lesson 2: Change chart layout (10:52)
P4 - lesson 3: Resize move chart (2:45)
P4 - Lesson 4: Delete chart (0:38)
P5 Clip Art - Lesson 1: Operation clipart (4:40)
P6 Photo - Lesson 1: Image Editing (5:08)
P6 - Lesson 2: Delete pictures (0:26)
P7 Smartart - Lesson 1: SmartArt format (2:58)
P7 - Lesson 2: SmartArt manipulation (1:47)
P8 Shape - Lesson 1: Add Shape (6:18)
P8 - Lesson 2: Change Shape (2:29)
P8 - Lesson 3: Delete the Shape (0:36)
P9 Video - Lesson 1: Video Editing (3:09)
P9 - Lesson 2: Create link to video (2:21)
P9 - Lesson 3: Delete videos (0:35)
P10 Audio - Lesson 1: Editing audio (3:26)
P10 - Lesson 2: Adding audio (4:54)
P10 - Lesson 3: Set audio play parameters (4:41)
P10 - Lesson 4: Create background music for the slide (2:54)
P10 - Lesson 5: Delete audio (0:31)
P11 Wordart - Lesson 1: WordArt format (3:06)
P12 Hyperlink - Lesson 1: Create Hyperlink (8:43)
P12 - Lesson 2: Change Hyperlink (1:18)
P12 - Lesson 3: Delete Hyperlink (1:14)
P13 Action - Lesson 1: Create action (7:52)
P13 Action - Lesson 2: Change the action (2:30)
P13 Action - Lesson 3: Delete the action (1:18)
P13 Action - Lesson 4: Action button (5:32)
P14 Note - Lesson 1: Note Page Format (2:57)
P15 Transition Animation - Lesson 1: Change Animation (0:53)
P15 - Lesson 2: Change Animation order (2:43)
P15 - Lesson 3: Copy Animation (4:24)
P16 Managing slides - Lesson 1: Copy Slide (4:48)
P16 - Lesson 2: Slide order (1:09)
P17 Section - Lesson 1: Creating Section (2:38)
P17 - Lesson 2: Change the Section name (1:25)
P17 - Lesson 3: Delete Section (1:31)
P18 Slide Master Mode - Lesson 1: Slide Master Introduction (1:55)
P18 - Lesson 2: Change create Layout (6:49)
P18 - Lesson 3: Slide Master mode (11:21)
P18 - Lesson 4: Change background color (8:10)
P18 - Lesson 5: Set wallpaper (5:49)
P18 - Lesson 6: Adding Header Footer (6:03)
P18 - Lesson 7: Animation in Slide Master mode (8:25)
P18 - Lesson 8: Create a theme (18:28)
P19 - Lesson 2: Laser Pointer (1:25)
P19 Slideshow - Lesson 1: Pen Highlighter (6:02)
P19 - Lesson 3: Set slideshow parameters (6:46)
P19 - Lesson 4: Broadcast Slide Show (4:25)
P20 Printing - Lesson 1: In Slide (5:40)
P20 - Lesson 2: In Handouts (3:01)
P20 - Lesson 3: In Note (1:25)
P20 - Lesson 4: In Outline (1:42)
P21 PowerPoint Templates - Lesson 1: Using Templates (9:06)
P21 - Lesson 2: Create Templates (27:36)
P22 Protect File Export to other formats - Lesson 1: Creating handouts (2:48)
P22 - Lesson 2: Create pdf files (2:11)
P22 - Lesson 3: Package for CD (8:37)
P23 Recover PowerPoint files - Lesson 1: Restore unsaved files (4:40)
P24 Online PowerPoint File Management - Lesson 1: Onedrive introduction (1:21)
P24 - Lesson 2: Save your PPT to Onedrive (4:01)
P24 - Lesson 3: Share PPT files (5:30)
Course 3: Excel Fundamentals
P1 Getting to know Excel - Lesson 1: Create a new workbook (1:02)
P1 - Lesson 2: Save the workbook (1:47)
P1 - Lesson 3: The structure of the workbook (1:34)
P2 Basic data manipulation in Excel - Lesson 1: Enter numeric data (0:41)
P2 - Lesson 2: Line break in 1 cell (2:05)
P2 - Lesson 3: Insert cells columns and rows (2:30)
P3 How to manipulate Excel Worksheet - Lesson 1: Hide and show the worksheet (1:15)
P4 Formatting in Excel - Lesson 1: Merge cells wrap text (3:05)
P4 - Lesson 2: Align content (1:47)
P4 - Lesson 3: Set the data display direction (1:09)
P4 - Lesson 4: Quick Format (2:39)
P4 - Lesson 5: Display as crossed out (1:16)
P5 Printing Excel - Lesson 1: Print Content Check (2:05)
P5 - Lesson 2: Print setting parameters (2:46)
P5 - Lesson 3: Print an area of data (2:06)
P6 Basic Excel functions - Lesson 1: Statistical functions - SUM (0:53)
P6 - Lesson 2: String handler function - RIGHT (1:00)
P6 - Lesson 3: String handler function - CONCATENATE (2:03)
P6 - Lesson 4: Function to handle date and time - WEEKDAY (0:57)
P6 - Lesson 5: Theoretical functions - OR (1:39)
P8 General Excel exercises - Lesson 1: exercise (0:42)
P8 - Lesson 2: Solution (4:13)
P9 Excel Chart - Lesson 1: Format chart (4:44)
P9 - Lesson 2: Create a chart as a worksheet (1:29)
P10 Database in Excel - Lesson 1: Freezepane (4:10)
P10 - Lesson 2: Filtering and extracting data (16:45)
P10 - Lesson 3: Data Validation (12:42)
P11 Advanced Excel functions - Lesson 1: Statistical functions - SUMIF (3:09)
P11 - Lesson 2: Statistical functions - COUNTA (1:02)
P11 - Lesson 3: Statistical functions - COUNTBLANK (1:11)
P11 - Lesson 4: The string handler function - REPLACE (2:05)
P11 - Lesson 5: Database Function - DCOUNT (4:07)
P12 Conditional Formatting - Lesson 1: Highlight the leading or lowest values (2:48)
P13 Image objects and shapes - Lesson 1: Insert smartart (5:00)
P13 - Lesson 2: Group of picture objects (3:04)
P14 Confidentiality - Lesson 1: Hide calculation formulas (2:21)
P15 Pivot Table - Lesson 1: See detailed data (1:34)
P15 - Lesson 2: Changing statistical formula (3:15)
P15 - Lesson 3: Display statistical value as (2:19)
P15 - Lesson 4: Filter data column row (5:01)
P15 - Lesson 5: Format the Pivot Table (1:20)
P15 - Lesson 6: updated Pivot Table (4:23)
P16 Pivot Chart - Lesson 1: Filtering data (2:50)
P16 - Lesson 2: Move Pivot chart (2:00)
P16 - Lesson 3: Clear the Pivot chart (1:53)
P17 General Excel exercises - Lesson 1: exercise 2 (9:52)
Course 4: 22 Advanced Excel Techniques
Lesson 1: Instruction showing formula detect number of hand fill (1:07)
Lesson 2: Find duplicate data (2:14)
Lesson 3: To guide the industrialization of the Ctrl Y manipulation (2:13)
Lesson 4: Quick navigation guide in Excel (2:20)
Lesson 5: Quick guide with 7 shortcuts (3:24)
Lesson 6: Guide to automatically fill blank information (1:20)
Lesson 7: Instructions on how to learn the recipe (2:42)
Lesson 8: Instructions on how to learn the formula (2:42)
Lesson 9: Instructions for creating custom lists (2:04)
Lesson 10: Some copy and paste operations (2:16)
Lesson 11: How to create links in Excel files (2:35)
Lesson 12: Quick guide to select data with hot keys (1:22)
Lesson 13: Custom format instructions (3:03)
Lesson 14: Instructions for separating first and last names DO NOT use formulas (1:50)
Lesson 15: How to automatically format lines in Excel (2:18)
Lesson 16: Detect data is not a formula (1:39)
Lesson 17: Automate test data (2:54)
Lesson 18: Finds the last value in a table (2:48)
Lesson 19: Find the last row and column number of a table (1:55)
Lesson 20: Find values by row and column (1:55)
Lesson 21: Work with dates for personnel (3:52)
Lesson 22: Line breaks do not use the Enter key (2:02)
P15 - Lesson 4: Filter data column row
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock