✅ Download and complete the exercises ➡️ https://www.simonsezit.com/office-365-course-and-exercise-files
In this huge 12-hour Office 365 beginner course, we give you a solid background in using Microsoft Excel, Microsoft PowerPoint, and Microsoft Word.
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-free/
📝Timestamp
00:00:00 - Course Introduction
00:03:12 - Excel 365 Online Portal
00:09:23 - Exercise 01
00:10:23 - Launch Excel
00:14:15 - Explore the Interface
00:24:07 - Contextual Menus
00:28:47 - The Quick Access Toolbar
00:35:58 - Keyboard Shortcuts
00:42:56 - Exercise 02
00:47:57 - Excel Templates
00:54:36 - Work with Workbooks
01:01:17 - Save Workbooks to OneDrive
01:06:05 - Enter Text, Numbers, and Dates
01:13:13 - Custom Lists
01:19:43 - Exercise 03
01:23:45 - Order of Operations
01:28:48 - A Simple Formula
01:37:15 - The 'Big 6' Functions
01:43:44 - Absolute vs Relative Referencing
01:51:11 - Quick Calculations
01:58:32 - Autofill and Flash Fill
02:09:12 - Exercise 04
02:14:00 - What are Names Ranges?
02:17:25 - Create Named Ranges
02:21:42 - Use Named Ranges in Formulas
02:25:10 - Exercise 05
02:27:40 - Apply Number Formats
02:38:17 - Format Cells, Rows and Columns
02:51:26 - AutoFormat
02:55:06 - Find and Replace Formatting
03:01:38 - Format Painter
03:06:14 - Clear Cells
03:11:33 - Exercise 06
03:15:35 - Tables Explained
03:23:26 - Format as Table
03:33:54 - Table Reference in Formulas
03:40:46 - Exercise 07
03:43:29 - Work with Columns and Rows
03:52:49 - Align Text and Numbers
04:01:48 - Merge Cells vs Center Across Selection
04:08:44 - Apply Themes and Styles
04:17:07 - Exercise 08
04:20:03 - Excel 365 Course Close
04:23:29 - Powerpoint 365 Course Introduction
04:26:25 - PowerPoint Online vs Powerpoint Desktop
04:30:50 - Exercise 01
04:32:14 - The Golden Rules of Good Presentation
04:44:48 - FREE Resources and Inspiration
04:51:37 - Exercise 02
04:52:49 - Start Quickly with Themes and Templates
04:57:17 - Quick Starter Outline Slides
05:02:05 - Save Presentations to the Cloud
05:07:57 - Exercise 03
05:11:04 - Understand the Interface
05:20:06 - Add Commands to the Quick Access Toolbar
05:26:01 - Keyboard Shortcuts and KeyTips
05:31:49 - Exercise 04
05:35:21 - Slide Layouts
05:39:50 - Organize Slides
05:44:34 - Change the Slide Background
05:51:43 - Add a Transparent Shape Overlay
05:57:28 - AI in PowerPoint: Designer
06:00:17 - Change Multiple Slides: Slide Master
06:07:08 - Work with Text Boxes
06:11:55 - Add Sections
06:16:46 - Find and Replace Fonts
06:19:36 - Copy Slides Between Presentations
06:24:43 - Exercise 05
06:29:10 - Add Images to a Presentation
06:36:31 - Work with Shapes
06:43:34 - Align and Group Objects
06:49:37 - Z-Order and Selection Pane
06:55:43 - Fill Shapes with Images
07:01:00 - Format and Add Effects to Objects
07:05:52 - Copy Formatting: Format Painter and Eyedropper
07:11:25 - Remove the Background from Pictures
07:16:00 - Insert and Customize Icons and Other Graphics
07:24:13 - Exercise 06
07:32:09 - Fill Text with an Image
07:37:36 - Text Effect with Layers
07:42:17 - Create Gradient Filled Text
07:45:05 - Exercise 07
07:49:14 - Create & Format Charts
08:00:26 - Use SmartArt to Create Diagrams
08:08:24 - Insert Screenshots and Clippings
08:12:39 - Exercise 08
08:17:55 - PowerPoint 365 Course Close
08:20:22 - Word 365 Course Introduction
08:22:58 - Word Online vs Word Desktop
08:25:58 - Exercise 01
08:28:30 - Launch Word and the Start Screen
08:31:54 - Word Interface
08:39:50 - Ribbons, Tabs and Menus
08:46:43 - Quick Access Toolbar
08:53:44 - Useful Keyboard Shortcuts
09:00:21 - Check Spelling and Grammar as You Type
09:03:19 - Exercise 02
09:06:52 - Word Templates
09:13:06 - Create and Save a Document
09:17:12 - Save Documents to OneDrive
09:19:37 - Recover Unsaved Documents
09:22:54 - Navigate Around a Document
09:28:40 - Find Tools in Word
09:32:35 - Exercise 03
09:37:25 - Switch Document Views
09:45:15 - Immersive Reader and Focus
09:50:11 - Arrange Documents and Zoom
09:57:15 - Exercise 04
09:59:30 - Enter and Format Text
10:08:27 - Copy, Cut and Paste
10:11:57 - Work with the Clipboard
10:16:28 - Format Painter
10:21:13 - Paste Options
10:26:10 - Find and Replace
10:34:13 - Dictate and Transcribe
10:42:18 - Exercise 05
10:46:45 - Format Paragraphs and Alignment
10:53:26 - Line and Paragraph Spacing
10:59:46 - Show/Hide Markers
11:04:56 - Bullets and Numbered Lists
11:13:28 - Indent Paragraphs
11:20:00 - Align Text with Tabs
11:30:00 - Exercise 06
11:34:17 - Word Themes Explained
11:42:02 - Custom Theme
11:50:02 - Exercise 07
11:53:35 - Word Styles Explained
12:01:01 - Modify Styles
12:08:13 - Reset to Default Styles
12:12:28 - Custom Style
12:18:03 - Exercise 08
12:21:44 - Word 365 Course Close