Microsoft Office Tutorial: Learn Excel, PowerPoint and Word - 9 HOUR MS Office Course

✅ Download the free course exercise files to follow along

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:

📝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

🔥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 👍🏽 ;-)

[lassicguy]

I did the Excel part of it in one sitting, went to a job interview and passed the skill test being the top candidate. Now I have returned to do the Power point and Word part of it. This is really helpful words are not enough to describe how grateful I am to you guys.

[cyrusmulei]

Not all heroes wear capes, you're my hero Cindy!

[Golightly_Eleven]

I always advice friends/clients who can't afford that much time/money for classes to educate themselves by watching yt tutorials, and here you are: A BIG THANK YOU for your great work

[catherineshaw]

This is incredible! As a longtime admin who's rusty and needs a good refresh, I cannot believe you are offering this for free. It's a lifesaver at a really tough time so you have my deepest heartfelt gratitude! Bless you and Cindy!

[nathanaelsegura]

1:22:30
1:23:08
1:27:40
1:32:40
1:33:25 print comments
1:36:10 margins
1:37:35 Orientation
1:37:50 size
1:38:05 print area
1:38:40 page breaks
1:39:52 background
1:40:48 width height and scale to shrink the width of your printout to fit two pages.
1:41:35 portrait landscape
1:41:55 change paper size here
1:42:40
1:44:30
1:45:08 scale...page preview
1:47:50
1:48:22 page setup
1:49:05 change the paper from portrait to landscape
1:49:10 collated
1:49:30 if you have a printer that you can print on both sides
1:49:50 print a specific page
1:54:15
1:55:10 insert sheet rows
1:57:50 insert
2:34:10 function library

[imahbukusto]

Sapa yang tengok ni aq memang respect kat korang. Bukan senang nak tahan diri dari keluar dri video ni. Good luck 👍

[saritaraghuvanshi]

This is the most detailed and well presented tutorial available online for anybody. Thank you for making this. I have recommended this video to very many students who are at the verge of kick starting their corporate careers. This video has been massively useful to each one them. THANK YOU!

[sandrasatterfield]

I am 55 years old and in the process of switching careers. I was alittle (alot🙄) fearful about learning Microsoft Word and excel. Thank you for providing this wonderful source of information!!!!

[ksenyat]

I absolutely love the instructor, her voice is very soothing, she is not rushing the material and the way she explains everything is very comprehensive!

[starbutterfly]

I have seen a lot of MS Office training videos on youtube and this is by far the most effective one for me. Some of them are too fast and too slow but this course is perfect, straight to the point with clear explanation. Thanks a lot Cindy.

[nikiruffle]

Thank you. Its just what ive been looking for! Easy to learn! Perfect tuition! 🙏♥️😊

[SimonSezIT]

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

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

[omokesideajiboye]

I've not watched the video yet but i just want to Express my awe. For someone to post this free, it takes alot. I've subscribed. Thank you

[francinegolden]

This is a great video. I now understand when to use the () and the :. I never knew why, I just always thought it was a rule. Thank you.

[BlissfulStage]

Great job Cindy! I really appreciate your efforts and thank you very much for helping me out. God bless you!

[estebanhenriquez]

I’m currently looking to switch careers, and with it, gain new skills. I cannot thank you enough for providing this tutorial!

[evxcohh]

I am going to refer friends and colleagues who, like me are in somewhat of a need to learn much more details than other programs offer. Good, easy yet comprehensive. The presenter is focused, on point and easy to listen to because her voice is melodious.

[rufflesal]

Thankyou very much for these lessons and exercise files! I'm going for a promotion and need a refresher. Thanks again Simon and Cindy!

[marzellabankspittman]

Awesome course! I personally enjoyed the entire course. Can't wait to implement this in my daily work routine.

[HARENDRAKUMAR-stnz]

you made my life because I bought first laptop and I was thinking about how to do work on excel, words and power point
and now I found you. thank you from bottom of my heart ❤️ it's genuine information