Microsoft Office 2021/365 for Beginners: 9+ Hours of Excel, Word, and PowerPoint Training

Download the course files to follow along and practice what you learn https://www.simonsezit.com/office-2021-course-files-excel-ppt-word/
In this huge 9-hour Microsoft Office 2021/365 training course, we give you a solid grounding in Microsoft Excel, Microsoft Word, and Microsoft PowerPoint.
Are you new to Microsoft Office and want to get started with the basics? Then this is the video for you.
This course is taught using Office 2021 and applies to Office 365 users. We cover MS Excel 2021 basic formulas and functions, MS Word 2021 tips and tricks, PowerPoint 2021 best practices, and so much more!
We've even included downloadable instructor and exercise files from our paid-for courses so you can follow along and complete the exercises in this course.
Use the timestamps below to navigate to different sections of the course.
00:00:00 - Simon Sez IT Intro
00:00:20 - Excel 2021 Course Introduction
00:02:40 - Excel 2021 vs. Excel 365
00:08:20 - Launching Excel
00:11:58 - The Start Screen
00:22:16 - Exploring the Interface
00:33:54 - Ribbons, Tabs, and Menus
00:42:23 - The Backstage Area
00:47:04 - Quick Access Toolbar
00:56:48 - Useful Keyboard Shortcuts
01:06:29 - Getting Help
01:13:11 - Exercise 01
01:15:50 - Working with Templates
01:24:51 - Workbooks and Worksheets
01:34:27 - Saving Workbooks
01:41:11 - Entering and Editing Data
01:51:04 - Cells, Rows, and Columns
01:58:25 - Exercise 02
02:03:45 - Formulas and Functions Explained
02:15:26 - SUM Function
02:23:05 - Counting Values and Blanks
02:30:31 - AVERAGE Function
02:34:49 - MIN and MAX Functions
02:37:15 - Handling Errors in Calculations
02:45:57 - Absolute vs Relative Referencing
02:52:52 - Autosum and AutoFill
03:02:34 - Flash Fill
03:07:41 - Word 2021 Course Introduction
03:17:14 - Exercise 01
03:19:31 - The Start Screeen
03:29:53 - Exploring the Word Interface
03:38:58 - Rulers and Zoom
03:44:54 - Check Spelling and Grammar
03:49:51 - Quick Access Toolbar
03:57:26 - Keyboard Shortcuts
04:04:26 - Screentips, Contextual Menus, and Ribbons
04:12:41 - Get Help
04:19:50 - Exercise 02
04:24:12 - Create and Save a Document
04:31:44 - Open Existing Documents
04:38:05 - Create a Document from a Template
04:45:04 - Navigate Around a Document
04:50:51 - Find Tools in Word
04:53:32 - Exercise 03
04:59:51 - Switch Document Views
05:07:03 - Immersive Reader and Focus
05:12:47 - Dark Mode
05:18:25 - Exercise 04
05:22:38 - Enter Text and Apply Basic Formatting
05:32:19 - Making Selections
05:36:36 - Advanced Text Formatting
05:43:32 - Move Text with Cut, Copy, and Paste
05:51:37 - Format Painter
05:55:16 - Paste Options
06:01:14 - Find and Replace
06:11:21 - Intro to PowerPoint 2021
06:18:23 - Creating Visually Stunning Presentations
06:23:57 - Presentation Tips and Best Practice
06:36:24 - Free Resources and Inspiration
06:45:54 - Exercise 01
06:47:06 - PowerPoint Interface
06:58:47 - Quick Access Toolbar
07:06:37 - Opening, Closing, and Saving Presentations
07:12:55 - Using Templates
07:19:32 - PowerPoint Options
07:27:09 - Exercise 02
07:31:00 - Slide Layouts
07:37:04 - Adding and Duplicating Slides
07:43:10 - Reusing Slides from Other Presentations
07:47:40 - Creating Sldes from an Outline
07:51:05 - Slide Themes and Backgrounds
08:01:21 - Exercise 01
08:05:54 - Resizing Background Image: Crop and Fill
08:11:47 - Transparent and Shape Overlays
08:18:30 - Drawing and Formatting Shapes
08:25:06 - Locking Shapes and Setting a Default Shape
08:28:37 - Merging Shapes
08:37:47 - Inserting a Logo: Filling Shapes with Images
08:42:03 - Adding Title and Subtitle
08:51:19 - Eyedropper Tool
08:56:33 - Exercise 04
09:03:02 - Selecting Objects
09:09:20 - Renaming and Changing the Z-Order
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/
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here
https://www.youtube.com/playlist?listPLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Microsoft Office 2021 and Office 365 https://www.youtube.com/playlist?listPLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
Microsoft Office Beginners Tutorials here https://www.youtube.com/playlist?listPLzj7TwUeMQ3iAGb43_i5LnZ_F98_137gI
Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?listPLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation1
If you enjoyed the video, please give a thumbs up ;-)