Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Account Types
Personal/Single User
Business/Multi User
Academic License
Helpful Links
List of Tutorials
Product Solutions
Product Overview
Testimonials
Popular
Contact Us
FAQ
Newest Tutorials
Introduction to the Query Object in Access Access
Create a Basic Query in Access Access
View the Results of a Query in Access Access
Sort Data in a Query in Access Access
Display Only Certain Records Using a Query in Access Access
Access Features and Security Concerns Introduction Access
Change the Views of Objects in Access Access
Use the Navigation Pane in Access Access
Import Excel Files into Access Access
Export Access Files into Excel Access
Add a Pre Made Table Template to an Access Database Access
Make an Access Table in Datasheet View Access
Rename Access Table Fields from Datasheet View Access
Search Access Tables Quickly and Easily Access
Sort Data in Access Tables Access
Is Access a Database? Access
What is a Database? Access
Create a New Blank Access Database Access
Create an Access Database from a Template Access
Input View and Save Data into an Access Database Access
Overview of the Main Elements of Microsoft Access Access
When to Use Access Instead of Excel Access
Why Would I use Microsoft Access? Access
What Can Microsoft Access Do? Access
What is Microsoft Access? Access
Video Player Demo
Tutorial Demo
User Testimonials
Easy to Follow and Great Content
Awesome tutorials. This is great work; thanks a lot for all of these tutorials, and at a great price. The tutorials are easy to follow and understand and are very valuable for me. Teachmsoffice.com has helped me a lot in terms of increasing my Excel skills and learning how to master Excel. Keep up the good work!
- Sarah M.
Thank you so much!
Thank you so much! My professor was giving me a hard time with this...so I told him I will just figure it out on my own and this site really helped me figure everything out!!
- Ms. R
Thank you and godbless
My text book really sucks and I'm very thankful that you have all of these tutorials. I finished my last two questions because of your site! Thank you and godbless.
- Rob V.
Amazing Videos
Just wanted to say that your videos are amazing. I'm watching them and they really help me understand. The way you explain and go through everything is amazing. Thank you soo much!
- Design X
Saved a Ton of Time!
You have just saved me so much time, I cannot thank you enough!
- L. J.
Thank You!
Thank you for sharing these important tips. Your voice is clear and the steps are clear. It is easy to follow. Thank you!
- Kent
Saved Me Time
Thanks for the tutorials, I never had to do this before today and I needed it done very quickly. These videos saved me time I didn't have!
- Mitchel S.
Thank You!
Thank you! Helped me so much!
- M. Clean
Excellent Tutor
I was just listening to the tutorial online and I must say that the tutor is doing an excellent job.
- D. B.
Sign Up to View Tutorials
Purchase Subscription

Bookmark and Share

Copy and Paste Values Using a Keyboard Shortcut in Excel

Top
This tutorial shows you the keyboard shortcut for copying and pasting values in Excel. This will allow you to take any formula or function and turn it into the value that it outputs. This is a great technique to use when you need to turn dynamic values into hard-coded values in Excel.
Tutorial Length (mm:ss): 3:28
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training copy paste values keyboard shortcut excel tutorial help tip trick

Auto Resize Columns Using a Keyboard Shortcut

Top
This tutorial shows you a keyboard shortcut for Excel that will allow you to quickly and easily automatically resize columns in Excel. This keyboard shortcut works great for any situation that requires columns to be resized and it will save you a lot of time and work resizing columns in Excel.
Tutorial Length (mm:ss): 3:30
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training auto resize columns keyboard shortcut excel automatically resize tip trick

Clear All Formatting from Cells with One Mouse Click

Top
Learn how to quickly and easily remove all formatting from cells in Excel. This tutorial shows you how to select individual cells, multiple cells, and an entire worksheet and then remove any and all formatting from those cells. This technique even removes number, date, text, etc. formatting from cells.
Tutorial Length (mm:ss): 2:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training clear formatting cell formats remove excel quick easy mouse click spreadsheet

Remove Comments from an Entire Worksheet with One Mouse Click

Top
This tutorial shows you how to quickly remove all or just a selection of comments from a worksheet in Excel. This tip allows you to save a lot of time because you will no longer have to individually select each comment in order to delete it. Deleting or removing comments from cells in Excel is especially important when you need to clean up a spreadsheet before you send it out to someone.
Tutorial Length (mm:ss): 2:30
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training remove delete comments worksheet cells excel spreadsheet quickly tip

Select All Cells that Contain Formulas and Functions

Top
This Excel tutorial shows you how to quickly and easily select all cells that contain a formula or function. This method allows you to identify cells that have hard-coded values and cells that contain a formula or just a function. Also, this method is non-invasive, which means that it won’t affect the appearance of your Excel worksheet.
Tutorial Length (mm:ss): 2:22
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training select cell formulas functions all excel worksheet spreadsheet quickly

Remain in the Same Cell After Hitting Enter

Top
This tutorial shows you how to keep the current cell active after you hit the enter key in Excel. This allows you to input data into a cell without moving away from that cell after you hit the enter key. This is a great Excel tip to learn and will save you a lot of time and work in the long run.
Tutorial Length (mm:ss): 2:08
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training same cell hit enter key excel input data remain stay enter keyboard

Remove Gridlines from a Worksheet in Excel

Top
This tutorial shows you how to remove gridlines from a worksheet in Excel. Gridlines are the default outlines of each cell in a worksheet in Excel. When you remove these gridlines, you are able to make a cleaner looking spreadsheet interface in Excel.
Tutorial Length (mm:ss): 1:50
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training remove gridlines cell excel worksheet cell outlines clear boxes

Remove Dotted Print Lines in Excel

Top
This tutorial shows you how to remove the dotted print lines that appear in a worksheet in Excel after you go to Print Preview or after you print the worksheet. These little lines are actually page break lines and they can be very annoying. This tutorial shows you how to quickly and easily get rid of these little dotted print lines.
Tutorial Length (mm:ss): 2:40
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training remove dotted print lines clear show page breaks excel printing preview

Print Gridlines in Excel 2007

Top
This tutorial shows you how to print gridlines in Excel. When you open a new spreadsheet in Excel, the little box or cell outlines that you see are called gridlines. By default, gridlines do not print from Excel. This tutorial shows you how to make gridlines show up when you print a worksheet from Excel.
Tutorial Length (mm:ss): 2:43
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training print gridlines cell outline border box excel view tip trick spreadsheet

Hide the Ribbon Menu in Excel 2007

Top
Learn how to hide or minimize the Ribbon Menu in Excel 2007. Hiding the Ribbon Menu in Excel 2007 allows you to have more space to work and a cleaner looking interface in Excel. This tutorial also shows you how to unhide the Ribbon Menu.
Tutorial Length (mm:ss): 1:16
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training hide ribbon menu excel 2007 remove minimize get rid of tip trick

Printing in Excel Introduction and Feature Overview

Top
This is a comprehensive introduction and overview of the printing features in Excel. This tutorial shows you how to print selections of text, specific worksheets, multiple worksheets, and an entire workbook. Also, you will learn about some other printing features including: how to use the new Page Layout view; how to use print preview to check documents before you print them; how to add headers ...
Tutorial Length (mm:ss): 11:20
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training printing print overview introduction comprehensive worksheets workbook page setup page layout selections header footer

Page Layout View for Printing

Top
This tutorial provides an overview of the new Page Layout view for Excel 2007. This new view type allows you to view exactly what the spreadsheet will look like when printed without having to go to the Print Preview screen. This is a very welcome and useful enhancement for printing in Excel.
Tutorial Length (mm:ss): 3:45
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training new features excel 2007 page layout view printing header footer
 
Official PayPal Seal SSL
Join TeachMsOffice.com on Facebook
Follow TeachMsOffice.com on Twitter


Microsoft Office Tutorials | Office Tutorials - Excel Word PowerPoint | HD Tutorial Video Player Overview | About TeachMsOffice.com

TeachMsOffice.com provides HD Online Video Tutorials and Training for Microsoft Office programs such as Excel, Word, and PowerPoint. We use a specialized video player interface to teach a vast list of Microsoft Office Tutorials and we add new tutorials on a weekly or monthly basis.