Download the free course exercise files to follow along
️ https://www.simonsezit.com/office-2019-exercise-files/

This is the longest tutorial we have ever posted! In this mega 9-hour Microsoft Office class, we give you a solid grounding in Microsoft Excel, Microsoft PowerPoint, and Microsoft Word.

Are you new to Microsoft Office? Do you need the basics for your job or for school? Then this is the video for you. We've even included downloadable exercises from our paid-for course that mean you can complete the MS Excel, MS Word, and MS PowerPoint exercises in this Microsoft Office Tutorial and put what you are learning into practice.

This mega tutorial is made up of extracts from our full courses. View them here:
️ MS Word: https://bit.ly/3iMM370
️ MS Excel: https://bit.ly/3iUhX1o
️ MS PowerPoint: https://bit.ly/2UJIC9j

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

Excel Timestamps
0:00:00 - Intro to Excel
0:01:19 - What's New in Excel
0:09:12 - Course Overview
0:10:29 - Overview of the Excel Window
0:18:55 - Mouse Features
0:22:08 - BackStage View in Excel
0:24:46 - Text and Numbers
0:29:18 - Creating Basic Formulas
0:36:06 - Relative References
0:39:08 - Order of Operations
0:43:56 - Working with Ranges
0:48:29 - Practice Exercise
0:50:05 - Working with Save and Save As Commands
0:54:38 - File Extensions, Share, Exports & Publish Files
0:58:24 - Practice Exercise
0:59:21 - Opening a File
1:04:54 - Working with Larger Files
1:10:28 - Freeze Panes
1:13:44 - Split Screen
1:17:07 - Practice Exercise
1:19:57 - Headers & Footers
1:27:20 - Print Titles
1:30:13 - Comments in Excel
1:35:36 - Page Setup Options
1:43:06 - Fit to Print on One Page
1:47:05 - Printing Workbooks
1:51:03 - Practice Exercise
1:52:54 - Adding and Deleting Cells
1:59:06 - Chaing Column and Row Widths
2:02:54 - Practice Exercise
2:04:04 - Cut, Copy and Paste
2:11:11 - Copying Formulas
2:16:22 - Practice Exercise
2:17:42 - Overview of Formulas
2:20:29 - Create Formulas Using Functions Part 1
2:30:33 - Create Formulas Using Functions Part 2
2:35:58 - Absolute Values
2:41:16 - Practice Exercise
2:42:35 - Adding, Deleting, and Remaining Sheets
2:46:44 - Additional Sheet Tab Options
2:52:03 - Dimensional Functions
2:57:19 - Practice Exercise

PowerPoint Timestamps
2:58:52 - PowerPoint Welcome and Overview
3:02:11 - Navigating a PowerPoint Presentation
3:13:57 - Overview of the Screen and the Views
3:26:14 - PowerPoint Exercise 01
3:27:27 - Presentation Tips and Guidelines
3:35:37 - Creating New Presentation
3:40:24 - Working with Slides
3:47:25 - Saving Presentation
3:53:54 - PowerPoint Exercise 02
3:55:59 - Formatting Text
4:06:56 - Working with Bullets and Numbered Lists
4:17:47 - PowerPoint Exercise 03
4:19:14 - Inserting Shapes
4:31:27 - Inserting Graphics
4:37:23 - Inserting Icons and 3D Models
4:43:47 - Inserting Pictures
4:50:29 - PowerPoint Exercise 04
4:51:44 - Selecting Objects
4:55:22 - Editing Objects
4:59:59 - Formatting Objects - Part 1
5:12:50 - Formatting Objects - Part 2
5:21:53 - Arranging Objects
5:31:35 - Grouping Objects
5:38:02 - PowerPoint Exercise 05
5:30:29 - Picture Options
5:45:32 - Cropping Pictures
5:52:23 - Formatting Pictures
5:59:43 - Things You Can Do with Pictures
6:09:13 - PowerPoint Exercise 06
6:10:22 - Creating SmartArt
6:18:37 - Modifying SmartArt
6:24:43 - Creating a Flow Chart

Word Timestamps
6:29:58 - Word Course Overview
6:32:36 - Word Screen
6:40:13 - Backstage View
6:48:46 - Creating a New Document
6:57:42 - Non-printing Characters and Line Spacing
7:06:11 - Saving a Document
7:12:50 - Opening a Document
7:19:44 - Navigating a Document
7:23:42 - GoTo, Find and Replace
7:31:12 - Editing a Document
7:34:35 - Section 2 Practice Exercise
7:35:35 - AutoCorrect Options
7:44:07 - Selecting Text
7:49:27 - Cut, Copy and Paste
7:57:39 - Character Formatting Options
8:05:43 - Format Painter
8:09:11 - Working with Numbers
8:17:14 - Working with Bullets
8:24:15 - Creating an Outline
8:29:52 - Section 3 Practice Exercise
8:31:55 - Alignment Options
8:35:15 - Line Spacing Options
8:39:59 - Working with Indents
8:45:17 - Working with Tabs
8:57:33 - Section 4 Practice Exercise
8:58:41 - Sorting a List

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

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

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 ;-)