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
Video Player Demo
Tutorial Demo
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
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.
Microsoft Office Excel Macros
Video Tutorials and Training
  • Hundreds of More Tutorials Available
  • Beginner to Advanced Level Training and Tutorials
  • Step-By-Step Instruction with Downloadable Files
Bookmark and Share

     Sign Up to Access the Macros


Automatically Highlight the Active or Selected Cell
Bubble Sort
Get Values from a Chart
Close a Workbook after a Time Limit is Reached
Combine Multiple Workbooks into One
Pop-Up Message Box When a Range of Cells Reaches a Certain Average
Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text
Delete Empty Columns
Delete Empty or 'Broken' Named Ranges (#REF!)
Name Worksheets Based on Cell Contents
Enter Text/Characters with a Double-Click of the Mouse
Change Formulas to Absolute or Relative References
Prevent Saving a Workbook under a Different File Name
Disables the "Save As" Feature in Excel
Delete Duplicate Rows
Delete Entire Rows Based on Predefined Criteria (Text)
Delete Multiple Named Ranges Quickly
Delete Hidden Worksheets
Delete Hidden Rows in a Workbook
Delete Blank Rows in Excel
Delete Rows in Excel if Completely Empty
Change Text to Lowercase
Highlight Cells with Text or Formulas (non-empty cells)
Highlight Cells which Contain Formulas
Highlight the Row and Column of the Selected Cell
Highlight the Row of the Selected Cell
Highlight the Column of the Selected Cell
Hide Formulas in a Worksheet and Prevent Deletion
Replace Formulas with Values (For The Entire Workbook)
Protect and Unprotect All Worksheets at Once
Capitalize the First Letter of Every Word in a Cell
Print All Charts That are in a Worksheet
Print all Embedded Charts in the Entire Workbook
Open a Word Document from Excel
Open Microsoft Word from Excel
Open a PowerPoint Presentation from Excel
Open Microsoft PowerPoint from Excel
Open Microsoft Outlook from Excel
Open any Program from Excel
Make Text to Uppercase
Sort Worksheet Tabs - Ascending or Descending Order
Email Current Workbook & or Other Attachments
Send Emails through Outlook using Email Addresses from Excel and text from Word
Reverse Row or Column Order in a Worksheet
Reverse Cell Contents (Mirror)
Delete Only the Text from Cells
Remove (Delete) Hyperlinks from Worksheets
Print Selected Worksheets in Excel
Print The Current Worksheet in Excel
Print Entire Workbook in Excel
Print Specific Pages in Excel
Display the Print Window in Excel
Print Preview Screen Display for The Current or Selected Worksheets in Excel
Print Preview Screen Display for The Entire Workbook in Excel
Print Preview Display for Specific Worksheets in Excel
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Format Cells as an Accounting Number in Excel Number Formatting
Format Cells as a Currency in Excel Number Formatting
Format Cells in The Long Date Number Format in Excel
Format Cells in The Short Date Number Format in Excel
Format Cells as a Fraction in Excel Number Formatting
Format Cells in The General (default) Format in Excel Number Formatting
Format Cells in The Number (Numerical) Number Format in Excel
Format Cells as a Percentage in Excel Number Formatting
Format Cells as a Scientific Number in Excel Number Formatting
Format Cells as Text in Excel
Format Cells as Time in Excel
Highlight Every Other Row in a Selection in Excel - Table Formatting
Filter Data to Display the Results that Begin With Specified Text or Words in Excel - AutoFilter
Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter
Filter Data to Show the Bottom 10 Percent of a Data Set in Excel - AutoFilter
Filter Data to Show the Bottom X Number of Items in Excel - AutoFilter
Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter
Display Filter Arrows in a Table or Data Set in Excel - AutoFilter
Filter Results in Excel to Show Only Those that End With Specified Text or Words - AutoFilter
Filter Data in Excel - AutoFilter
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Filter Data in Excel Without the Filter "Arrow" Appearing in the Filtered Column - AutoFilter
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Remove All Filtering From a Worksheet in Excel
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Filter Data to Show the Top X Number of Items in Excel - AutoFilter
Delete All Comments in a Worksheet in Excel Macro
Remove Comments from a Workbook in Excel - All Comments Deleted - Macro VBA
Add Comments to Cells with an Excel Macro
Hide Comments in Excel Partially - Comment Indicator Shows and Will Display on Hover
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
Display or Show all of the Comments within an Entire Excel Workbook
Hide Specific Comments in Excel - Comments Will Still Display on Hover
Delete Comments in Excel - Permanently Remove Specific Comments from Excel
Add Background Photos / Images to Comments in Excel
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
Basic Web Query in Excel - Import Data from the Web into Excel
Automatically Run a Macro so Many Seconds, Minutes, or Hours After an Excel Workbook has been Opened
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
Create a Line Chart with a Macro in Excel
Create a Bar Chart With a Macro in Excel
Create a Column Chart with a Macro in Excel
Sort Data that Doesn't Have Headers in Descending Order in Excel
Sort Data With Headers in Descending Order in Excel
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
Calculate the Future Value (FV) of Compound Interest in Excel - UDF Macro
Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
Generate a Non-Repeating List of Random Numbers in Excel - UDF
Display The Actual Link / Email Address From Links in Excel - UDF
Vlookup Function That Searches The Entire Workbook - UDF
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
Return the ISO Week Number from a Date in Excel - UDF
Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF
Convert Numeric Dollar Values into Text in Excel - UDF
Output the Worksheet Name in a Cell in Excel - UDF
Output the Name of the Current Excel Workbook Including Extension - UDF
Output the File Path to and Name of a Workbook in Excel - UDF
Output the Name of the Current Excel Workbook Without the File Extension - UDF
Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel
Get Text from Comments in Excel Including the Author of the Comment - UDF
Get Comment Text from Cell Comments in Excel - UDF
Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel - UDF
Reverse the Contents of a Cell in Excel - UDF
Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Return the Max Number from a Range That is Within a Minimum and Maximum Target Value in Excel - UDF
Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF
Add a Drop Down Menu to a Cell in Excel - Data Validation Macro
Add an Input Message to a Cell - Message Appears When the Cell is Selected in Excel - Data Validation Macro
Remove All Data Validation from a Cell in Excel
Create a 12 Month Calendar With The Current Day Highlighted in Excel
Delete a VBA Module From Excel
 
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.