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 150+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-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?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for Microsoft Office 2021 and Office 365 https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Microsoft Office Beginners Tutorials here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iAGb43_i5LnZ_F98_137gI

Microsoft Excel Tips and Tricks https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

Office 365 Hacks and Tips here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iYkOPsV0q-xU1hmUMN8Jfe

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_confirmation=1

If you enjoyed the video, please give a thumbs up ;-)