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

preview_player
Показать описание

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

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Рекомендации по теме
Комментарии
Автор


🔥Check out our FREE 300+ hour training course playlist here ➡️

🚀 Boost your Excel skills with these free Excel playlists 👉🏼


SimonSezIT
Автор

Been paying 60/year for Office 365. I'm happy with this as I can put it on multiple devices and it stays up to date.

NIKONGUY
Автор

This is by far the best MS office tutorial I have seen. Very well explained and easy to understand. Thank you.

mfjdz
Автор

I just got a job that I’m sure will require me to use excel so I’ve started with this tutorial. This tutor is speaking so clearly and I understand everything! I will definitely pass this on to all my friends and family 😊

_wethinkthatway
Автор

Thank you for taking your time to make this great video. Very helpful especially at my job.

tomjun
Автор

In my version of Excel save is now part of the quick access toolbar.

StaticBlaster
Автор

This tutorial is so helpful. God bless you for taking out so much time & giving it free to us.

raanighai
Автор

Wow mam you and your company has done very great work for the world

saadassiddiq
Автор

Wow! This is awesome. I love this very much.

chimarokenwaji
Автор

Amazing tutorial...made excel simple to understand

julietakpan
Автор

To those following along I suggest your have half of your screen the tutorial and the other half your production apps, that way you can make things less tedious for yourself.
You can do this by simply grabbing your page's border and dragging one page to far edge of the screen until it auto forms to half of your screen, then you can follow the same instruction for the other half.

MasudaOfKorriban
Автор

Amazing lesson. Just finished an hour on excel =)

roohijaved
Автор

Hi thank you for this Video, I've one question earlier version we see Data Type (Stocks, Currencies) feature in Data menu on MS Excel how to get it into MS Office 2021

pradeep
Автор

A subscription notice appears when I open a Microsoft 365 application
????

names
Автор

This is really a good 9hours plus worth of value. Thanks a lot.

ayoolaokediran
Автор

how do you input proper fractions in excell and also sqm symbol

johnrafimbi
Автор

Thank you so much for all the hard work you put on me

getfanmedia
Автор

Are these only basic of excel, PowerPoint and word? If yes then where can i learn the intermediate and advance of Excel, PowerPoint and Word?

KhushiKumari-ypib
Автор

and my second question is if don't purchase Microsoft 365 latest can't I use it freely

kakembojohn
Автор

suppose I don't use excel daily basis do I need to pin?

kakembojohn