Completed
- Exercise 03
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Microsoft Office 365 for Beginners - Excel, Word, and PowerPoint Training
Automatically move to the next video in the Classroom when playback concludes
- 1 - Course Introduction
- 2 - Excel 365 Online Portal
- 3 - Exercise 01
- 4 - Launch Excel
- 5 - Explore the Interface
- 6 - Contextual Menus and Ribbons
- 7 - The Quick Access Toolbar
- 8 - Keyboard Shortcuts
- 9 - Exercise 02
- 10 - Excel Templates
- 11 - Work with Workbooks and Worksheets
- 12 - Save Workbooks to OneDrive
- 13 - Enter Text, Numbers, and Dates
- 14 - Custom Lists
- 15 - Exercise 03
- 16 - Order of Operations
- 17 - A Simple Formula
- 18 - The 'Big 6' Functions
- 19 - Absolute vs Relative Referencing
- 20 - Quick Calculations with Autosum
- 21 - Autofill and Flash Fill
- 22 - Exercise 04
- 23 - What are Names Ranges?
- 24 - Create Named Ranges
- 25 - Use Named Ranges in Formulas
- 26 - Exercise 05
- 27 - Apply Number Formats
- 28 - Format Cells, Rows and Columns
- 29 - AutoFormat
- 30 - Find and Replace Formatting
- 31 - Format Painter
- 32 - Clear Cells
- 33 - Exercise 06
- 34 - Tables Explained
- 35 - Format as Table
- 36 - Table Reference in Formulas
- 37 - Exercise 07
- 38 - Work with Columns and Rows
- 39 - Align Text and Numbers
- 40 - Merge Cells vs Center Across Selection
- 41 - Apply Themes and Styles
- 42 - Exercise 08
- 43 - Excel 365 Course Close
- 44 - Powerpoint 365 Course Introduction
- 45 - PowerPoint Online vs Powerpoint Desktop
- 46 - Exercise 01
- 47 - The Golden Rules of Good Presentation Design
- 48 - FREE Resources and Inspiration
- 49 - Exercise 02
- 50 - Start Quickly with Themes and Templates
- 51 - Quick Starter Outline Slides
- 52 - Save Presentations to the Cloud OneDrive
- 53 - Exercise 03
- 54 - Understand the Interface
- 55 - Add Commands to the Quick Access Toolbar
- 56 - Keyboard Shortcuts and KeyTips + Copilot for Bing
- 57 - Exercise 04
- 58 - Slide Layouts
- 59 - Organize Slides
- 60 - Change the Slide Background
- 61 - Add a Transparent Shape Overlay
- 62 - AI in PowerPoint: Designer
- 63 - Change Multiple Slides: Slide Master
- 64 - Work with Text Boxes
- 65 - Add Sections
- 66 - Find and Replace Fonts
- 67 - Copy Slides Between Presentations
- 68 - Exercise 05
- 69 - Add Images to a Presentation
- 70 - Work with Shapes
- 71 - Align and Group Objects
- 72 - Z-Order and Selection Pane
- 73 - Fill Shapes with Images
- 74 - Format and Add Effects to Objects
- 75 - Copy Formatting: Format Painter and Eyedropper
- 76 - Remove the Background from Pictures
- 77 - Insert and Customize Icons and Other Graphics
- 78 - Exercise 06
- 79 - Fill Text with an Image
- 80 - Text Effect with Layers
- 81 - Create Gradient Filled Text
- 82 - Exercise 07
- 83 - Create & Format Charts
- 84 - Use SmartArt to Create Diagrams
- 85 - Insert Screenshots and Clippings
- 86 - Exercise 08
- 87 - PowerPoint 365 Course Close
- 88 - Word 365 Course Introduction
- 89 - Word Online vs Word Desktop
- 90 - Exercise 01
- 91 - Launch Word and the Start Screen
- 92 - Word Interface
- 93 - Ribbons, Tabs and Menus
- 94 - Quick Access Toolbar
- 95 - Useful Keyboard Shortcuts
- 96 - Check Spelling and Grammar as You Type
- 97 - Exercise 02
- 98 - Word Templates
- 99 - Create and Save a Document
- 100 - Save Documents to OneDrive
- 101 - Recover Unsaved Documents
- 102 - Navigate Around a Document
- 103 - Find Tools in Word
- 104 - Exercise 03
- 105 - Switch Document Views
- 106 - Immersive Reader and Focus
- 107 - Arrange Documents and Zoom
- 108 - Exercise 04
- 109 - Enter and Format Text
- 110 - Copy, Cut and Paste
- 111 - Work with the Clipboard
- 112 - Format Painter
- 113 - Paste Options
- 114 - Find and Replace
- 115 - Dictate and Transcribe
- 116 - Exercise 05
- 117 - Format Paragraphs and Alignment
- 118 - Line and Paragraph Spacing
- 119 - Show/Hide Markers
- 120 - Bullets and Numbered Lists
- 121 - Indent Paragraphs
- 122 - Align Text with Tabs
- 123 - Exercise 06
- 124 - Word Themes Explained
- 125 - Custom Theme
- 126 - Exercise 07
- 127 - Word Styles Explained
- 128 - Modify Styles
- 129 - Reset to Default Styles
- 130 - Custom Style
- 131 - Exercise 08
- 132 - Word 365 Course Close
