Teach Microsoft Office
Online Video Tutorials for Microsoft Office
Video Player 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

Search Results for Microsoft Office Training Tutorials

Bookmark and Share
This Excel Text tutorial shows you how to use the LEFT function in Excel in order to extract text from a cell in Excel. This tutorial includes examples of extracting text and numbers from cells and thoroughly covers the syntax of the LEFT function. This function is a building block upon which many complicated text manipulation functions are built and is essential to learn. This is a great introduction and explanation of the LEFT function.
Tutorial Length (mm:ss): 6:14
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to extract characters from the left of a string or text using VBA and macros. This is a text extraction and manipulation feature within VBA and it allows you to quickly and easily take apart a string. This tutorial covers examples that show you exactly how to extract text from the left of a string and how this feature can be used in more complicated applications.
Tutorial Length (mm:ss): 6:40
Microsoft Office Program: Microsoft Office Excel
Learn the basics of extracting or pulling text from cells in Excel with the LEFT, RIGHT, and MID functions in Excel. These three functions serve as the basis for all text extraction and editing formulas in Excel. This tutorial uses the examples of splitting up a name into the first and last name and also splitting up parts of a part number into different cells.
Tutorial Length (mm:ss): 6:22
Microsoft Office Program: Microsoft Office Excel
This Excel Text tutorial shows you how to use the RIGHT function in Excel in order to extract text from a cell in Excel. This tutorial includes examples of extracting text and numbers from cells and thoroughly covers the syntax of the RIGHT function. This function is a building block upon which many complicated text manipulation functions are built and is essential to learn. This is a great introduction and explanation of the RIGHT function.
Tutorial Length (mm:ss): 7:00
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to remove any extra or blank spaces from the left of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the left of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or strings that come from an external source or from user input, such as through a message box, userform, or imported csv file. Note that this tutorial focuses on removing extra spaces from the left of a string whereas our other tutorials will show you how to remove the spaces from the left and right of a string in VBA.
Tutorial Length (mm:ss): 5:56
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to remove the extra spaces from the left of a TextBox. By default, UserForm TextBoxís contain an extra space or margin to the left of any text that is input into it. This can be very annoying and does not look professional. Note, removing this extra space is sometimes referred to as Ďleft justifyingí the text within a TextBox.
Tutorial Length (mm:ss): 2:41
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to remove any extra or blank spaces from the left and right of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the left or right of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or strings that come from an external source or from user input, such as through a message box, userform, or imported csv file.
Tutorial Length (mm:ss): 7:00
Microsoft Office Program: Microsoft Office Excel
This Excel sorting tutorial shows you how to sort data from left to right, also referred to as sorting rows. This is a skill that will help you to organize data that is presented left to right in Excel. This works especially well with things such as sales data that is listed by day, week, month etc. across a spreadsheet. This is a more advanced method used to sort data and will help you to better organize your data in Excel.
Tutorial Length (mm:ss): 5:26
Microsoft Office Program: Microsoft Office Excel
This Excel date and time tutorial shows you how to separate a date into its three parts, the day, the month, and the year. This allows you to extract parts of a date from a full date. For instance, you can pull the day, month, and year into individual cells from one normal date cell in Excel. This is a very helpful thing to know when working with dates in Excel.
Tutorial Length (mm:ss): 6:08
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to remove any extra or blank spaces from the right of a text string within VBA and macros. This feature allows you to quickly clean or scrub data to ensure that there are no extra spaces to the right of it that might cause problems later within the code or application. This is a great feature to use when you have code that collects or uses text or strings that come from an external source or from user input, such as through a message box, userform, or imported csv file. Note that this tutorial focuses on removing extra spaces from the right of a string whereas our other tutorials will show you how to remove the spaces from the left and right of a string in VBA.
Tutorial Length (mm:ss): 7:02
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to reverse the direction of the X (horizontal) axis in a chart in Excel. Reversing the X axis means that data will be displayed from right to left instead of from the default left to right. Also, the Y axis will then be on the right side of the chart instead of the left side of the chart. If you perform data analysis with charts in Excel, knowing how to reverse or flip the X axis in a chart will be very helpful. This tutorial thoroughly covers how to reverse the direction of the X axis for a chart in Excel.
Tutorial Length (mm:ss): 2:08
Microsoft Office Program: Microsoft Office Excel
Learn how to add and remove page numbers from the left and right margins of Word documents. This tutorial will also cover some of the different styles of page numbers that can be placed in the left and right margin of a document.
Tutorial Length (mm:ss): 4:30
Microsoft Office Program: Microsoft Office Word
This tutorial shows you how to change text to upper case text using VBA and macros. This is especially helpful if you need to quickly format a large amount of text in upper case letters and also when you need to compare text strings and you donít want any potential difference in text case to affect this comparison.
Tutorial Length (mm:ss): 5:10
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to change text to lower case text using VBA and macros. This is especially helpful if you need to quickly format a large amount of text in lower case letters and also when you need to compare text strings and you donít want any potential difference in text case to affect this comparison.
Tutorial Length (mm:ss): 5:07
Microsoft Office Program: Microsoft Office Excel
This Word tutorial shows you how to quickly add sample text to a Word document. You will learn three different ways to add as much or as little sample text as you want to a document. This technique is great to use when you need to fill some space within a Word document and you donít want to waste time writing something out or copying and pasting text.
Tutorial Length (mm:ss): 5:00
Microsoft Office Program: Microsoft Office Word
This Excel tutorial shows you how to import a CSV or text file into Excel. This is a comprehensive overview of exactly how to import and organize data from a CSV or text file in Excel. This tutorial covers everything you need to know to import data from a CSV or text file into Excel and can be understood and followed by Excel users of any level. This is a great walkthrough tutorial with step by step explanations.
Tutorial Length (mm:ss): 10:16
Microsoft Office Program: Microsoft Office Excel
This Excel tutorial shows you how to import a CSV or text file into Excel. This is a quicker version of the tutorial. This means that it covers the basics of importing a CSV file into Excel but does not go over every little detail. This is a great tutorial for intermediate to advanced users of Excel who only need a quick tutorial for how to import a CSV or text file into Excel.
Tutorial Length (mm:ss): 4:13
Microsoft Office Program: Microsoft Office Excel
This Excel VBA macro tutorial shows you how to wrap text using VBA. This will allow you to ensure that all of a cellís contents fit within the cell. This is a useful method because it will not change any of the formatting for the cellís contents. Instead, using wrap text will simply resize the cell in order to fit everything within the cell.
Tutorial Length (mm:ss): 2:45
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to add a text label to a UserForm in Excel. A label is just text that you can put into a UserForm in order to tell a user what to input and where to input it. Labels are essentially all of the text that you see within a UserForm. This tutorial shows you how to add labels and change the display text of labels in a UserForm.
Tutorial Length (mm:ss): 4:34
Microsoft Office Program: Microsoft Office Excel
This Excel Text tutorial shows you how to use the REPT function in Excel in order to repeat text, numbers, or any other characters a certain number of times within a cell in Excel. This tutorial includes examples of repeating text, numbers, dashes, and more. You will also learn how to combine text from a cell with hard coded values within the REPT function in order to achieve a specialized repeat within a cell. This is a thorough introduction and explanation of the REPT function.
Tutorial Length (mm:ss): 6:02
Microsoft Office Program: Microsoft Office Excel
This Excel Chart Formatting tutorial shows you how to add effects to the text within a chart. You will learn how to edit the effects of a chartís title, legend, X axis labels and title, Y axis labels and title, and any other text within a chart in Excel. This tutorial shows you everything you need to know to change the appearance of text within a chart in Excel.
Tutorial Length (mm:ss): 5:58
Microsoft Office Program: Microsoft Office Excel
This Chart Formatting tutorial for Excel shows you how to format the text within a chart in Excel. You will learn how to change the size, color, font, and more for all text that is contained within a chart in Excel. This is a great tutorial to watch if you need to make formatting changes to the text in a chartís title, legend, X axis, Y axis, or anywhere else within a chart.
Tutorial Length (mm:ss): 4:06
Microsoft Office Program: Microsoft Office Excel
This Excel Text tutorial shows you how to use the LEN function. This function allows you to count characters within a cell in Excel. And, though its use may not be readily apparent, this function serves as one of the building blocks of more powerful text manipulation formulas in Excel. The LEN function also has some important features to watch out for, especially when it comes to spaces and non-text characters. All of this and more is covered in this tutorial for the LEN function in Excel.
Tutorial Length (mm:ss): 5:55
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to reverse a string in VBA and macros. This feature will allow you to quickly and easily completely reverse the characters in a string. You can make text read backwards or forwards using this method. This will save you a lot of time when you need to format any amount of text in reverse or backwards.
Tutorial Length (mm:ss): 4:58
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to change the text or label of a button in an Excel UserForm. You will learn how to add a command button to a UserForm; how to change the text displayed on the button; and, how to change the name of the button. This tutorial covers all of the basics related to command buttons in Excel UserForms.
Tutorial Length (mm:ss): 3:37
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to add a tip to the UserForm that will appear when you hover over a control, such as a TextBox, CommandButton, etc. This feature allows you to save space on the UserForm by putting any helpful or auxiliary text or tips into a box that only appears when you hover over a specified UserForm control.
Tutorial Length (mm:ss): 4:00
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to add vertical gridlines to a chart in Excel. Vertical gridlines are gridlines that go up and down instead of left and right. These gridlines can be very helpful when trying to visually segment data in a chart in Excel. This tutorial covers how to add and how to remove vertical gridlines from a chart in Excel.
Tutorial Length (mm:ss): 3:23
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to move the legend within a Chart in Excel. You will learn how to put the legend above, below, to the left, and to the right of the data within a chart. And, you will also learn how to incrementally move a legend anywhere within a chart. This tutorial covers everything you need to know about moving the legend within a chart in Excel.
Tutorial Length (mm:ss): 3:03
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to change the title of the UserForm. The title is the text that appears in the bar at the top of the form. By default, the text reads something like UserForm1, and this does not look very professional. In addition to changing the title of the UserForm, you will learn how to change the name of the form.
Tutorial Length (mm:ss): 4:14
Microsoft Office Program: Microsoft Office Excel
This Excel VBA macro tutorial shows you how to merge and unmerge cells within the worksheet. This is a great feature to use when you donít want to resize columns to fit a lot of text and when you need to apply a header across multiple columns. This tutorial will also show you how to center text within merged cells using VBA.
Tutorial Length (mm:ss): 6:10
Microsoft Office Program: Microsoft Office Excel
This Excel sorting tutorial will show you how to sort text in Excel from A to Z and Z to A (alphabetical and reverse alphabetical order). This is a seemingly basic sort but does require that you format your data in a certain way. This is a great tutorial for those just starting out sorting in Excel.
Tutorial Length (mm:ss): 2:29
Microsoft Office Program: Microsoft Office Excel
This tutorial covers how to enter or input text, numbers, characters, or values into cells and ranges in Excel using VBA and macros. This is an important feature of VBA to learn in order to create more useful macros with varying types of output. This tutorial uses an invoice template as an example.
Tutorial Length (mm:ss): 7:50
Microsoft Office Program: Microsoft Office Excel
Change text in cells to all upper case, lower case, or the proper case using the functions mentioned in this tutorial. These functions are the UPPER(), LOWER(), and PROPER() functions. The proper function simply capitalizes the first letter of each word.
Tutorial Length (mm:ss): 2:47
Microsoft Office Program: Microsoft Office Excel
Limit the length of text that can be entered into a cell in Excel. This is achieved using data validation.
Tutorial Length (mm:ss): 3:38
Microsoft Office Program: Microsoft Office Excel
Learn how to combine text or data or numbers from multiple cells into one cell in Excel using the concatenate features in Excel. The two features mentioned in this tutorial include using the CONCATENATE() function and the ampersand in order to combine data from multiple cells into one cell.
Tutorial Length (mm:ss): 4:19
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to limit the number of characters that a user can enter into a TextBox control within a UserForm. This is a form of data validation and allows you to prevent incorrect values from being input into the form. Note, this tutorial does not show you how to prevent certain text or numbers from being entered into a TextBox; users will still be able to enter any character into the TextBox, but they will be limited by how many characters they can input.
Tutorial Length (mm:ss): 3:21
Microsoft Office Program: Microsoft Office Excel
Prevent users from being able to or force users to enter text that is upper, lower, or proper case in a cell in Excel. This allows you to control the case of the text being entered into a cell and is achieved using data validation.
Tutorial Length (mm:ss): 5:43
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to calculate the length of a string within VBA and macros. The feature illustrated in this tutorial is covered with many examples and a thorough explanation of how to use it. This feature is one of the basic building blocks for more complex text manipulation and extraction applications within VBA and macros.
Tutorial Length (mm:ss): 6:14
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to quickly repeat a single character within VBA and macros. This feature allows you to very quickly create a string of a desired length without much programming code and can therefore save you a lot of time within VBA.
Tutorial Length (mm:ss): 3:33
Microsoft Office Program: Microsoft Office Excel
This Excel sorting tutorial provides an overview of how to sort your data in Excel. This tutorial includes an example of sorting numbers and text. As such, you will learn how to sort numbers from lowest to highest and highest to lowest (ascending and descending order) and how to sort text in alphabetical order and reverse alphabetical order (A to Z and Z to A). Also, this tutorial covers some other things to watch out for when you sort data within your spreadsheets in Excel.
Tutorial Length (mm:ss): 4:42
Microsoft Office Program: Microsoft Office Excel
This Excel VBA macro tutorial shows you how to shrink cell contents using VBA so that everything will fit within one cell in the worksheet. This method will allow you to ensure cell contents do not spill over into other columns while at the same time retaining all of the original formatting for the cellís contents.
Tutorial Length (mm:ss): 3:35
Microsoft Office Program: Microsoft Office Excel
Learn how to create your first PowerPoint presentation. This tutorial covers how to add text and bullet points to slides; how to choose different slide layouts; how to add notes to slides; how to edit text; how to add pictures to slides; how to add designs and themes to a presentation; and how to run a PowerPoint slide show presentation. This is an introduction to PowerPoint presentations.
Tutorial Length (mm:ss): 10:15
Microsoft Office Program: Microsoft Office PowerPoint
This tutorial shows you how to combine multiple separate pieces of text, strings, or information within VBA and macros using concatenation. This will allow you to put separate pieces of information into one variable or one string and this method is also the basis for many calculations within VBA and macros. This is a thorough concatenation tutorial that includes multiple examples which show you different ways you can combine or concatenate information within VBA and macros.
Tutorial Length (mm:ss): 8:18
Microsoft Office Program: Microsoft Office Excel
Learn the basics of entering data, numbers, and lists in Excel. This tutorial is for the beginner who is not very familiar with or has never used Excel. You will learn how to move the active cell to the right instead of down using the keyboard; how to cut and paste data with the drag and drop feature; how to automatically increment numbers using the auto fill handle; and how to add an extra line to text within a cell in Excel.
Tutorial Length (mm:ss): 13:05
Microsoft Office Program: Microsoft Office Excel
Learn the basics of formatting in Excel 2007. This introduction to formatting gives you an overview of all of the basic cell, font, and number formatting options in Excel 2007. These formatting options include how to change the font size, color, and appearance; how to use the Cell Styles feature to quickly create professional looking spreadsheets; how to use the alignment features of Excel; how to change the formats of data to represent dollars, dates, time, percentages, and more; how to merge cells; how to wrap text within a cell and much more.
Tutorial Length (mm:ss): 12:40
Microsoft Office Program: Microsoft Office Excel
Force a user to enter specific text, characters, or numbers at the beginning and or end of the contents of a cell. This feature allows you to force a user to always put ďASDĒ or any characters as the first letters of a cell and to end the cell with specific characters. This is really helpful when someone is inputting data that follows a pattern such as an employee email database where only the name of the employee changes for each email address. This tutorial covers case sensitive and case insensitive validation; text manipulation functions as well as data validation are used in this tutorial.
Tutorial Length (mm:ss): 15:03
Microsoft Office Program: Microsoft Office Excel
Learn how to prevent users from entering a value into a cell if that value is not contained within a predefined list and how to customize error messages for that cell.
Tutorial Length (mm:ss): 4:40
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to combine formulas and functions in Excel. This means the formulas and functions will be in the same cell and will be combined so to speak in order to generate output. This example also includes how to output text with formulas and functions to create output in sentence form.
Tutorial Length (mm:ss): 6:27
Microsoft Office Program: Microsoft Office Excel
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
This Excel tutorial shows you how to export data from Excel into a CSV file. You will learn how to put all of the data from an Excel workbook or worksheet into a CSV file. This will allow you to transfer data more easily and quickly between Excel and other programs, as well as providing you with a lightweight file format in which to transfer your data.
Tutorial Length (mm:ss): 3:34
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to change the color of everything within a UserForm. You will learn how to change the color of a TextBox, ComboBox, ListBox, the entire UserForm, and anything else that you can put into a UserForm. Adding color to your UserForms is a great way to make them stand out or blend in with your worksheet and this tutorial explains everything that you need to know about it.
Tutorial Length (mm:ss): 5:24
Microsoft Office Program: Microsoft Office Excel
This tutorial covers how to start page numbering on the second page of a Word document using either 1 or 2 as the page number listed on the second page. This feature allows you to have a cover or title page that does not have a page number but where page numbering starts on the second page with 1. This is great for formatting small projects that have just one cover page before the text.
Tutorial Length (mm:ss): 4:04
Microsoft Office Program: Microsoft Office Word
This Excel VBA macro tutorial shows you how to add subscript and superscript formatting to cell contents using VBA. As well, this tutorial also covers how to remove subscript and superscript formatting with a macro in Excel.
Tutorial Length (mm:ss): 5:03
Microsoft Office Program: Microsoft Office Excel
Insert complicated functions easily and quickly using the Insert Function feature in Excel. This tutorial shows you how to use this wonderful tool in order to enter functions into Excel. This specific example inserts a Present Value function and a Text Function using the Insert Function feature.
Tutorial Length (mm:ss): 6:26
Microsoft Office Program: Microsoft Office Excel
How to sort the results returned from a query in Microsoft Access. This tutorial will show you how to sort numbers, text, and dates within a query in Access. Also, you will learn how to have a sort automatically applied to the query every time the query runs. This will save you time and allow you to organize data returned by a query in just about any way you need within Access.
Tutorial Length (mm:ss): 6:32
Microsoft Office Program: Microsoft Office Access
This Word tutorial shows you how to correctly format a block quote in Word. This tutorial shows you how to make the block quote narrower than surrounding text and also how to add some extra spacing above and below the block quote. You will learn two different ways to create a block quote in Word and also some quick formatting tips for block quotes.
Tutorial Length (mm:ss): 4:52
Microsoft Office Program: Microsoft Office Word
This Excel VBA macro tutorial shows you how to change the orientation of a cell using VBA. The orientation of a cellís contents is the same as its degree or angle within the spreadsheet. This method will allow you to tilt cell contents up or down plus or minus 90 degrees.
Tutorial Length (mm:ss): 6:09
Microsoft Office Program: Microsoft Office Excel
Learn how to pull text and numbers from one cell into another cell using cell linking. This technique also works for creating formulas and functions using links to cells that contain numbers. Also, you will learn that you can perform mathematical operations on numbers from other cells without using a function. This is a pretty good ground-work building tutorial for formulas and functions.
Tutorial Length (mm:ss): 4:10
Microsoft Office Program: Microsoft Office Excel
This Excel tutorial shows you how to import data from the internet and websites into Excel. This allows you to pull data in from any site on the internet so long as that data is formatted in a table. This tutorial covers all the steps that you need to take in order to import data from a website. The example used in this tutorial shows you how to pull stock prices into Excel from the web.
Tutorial Length (mm:ss): 5:02
Microsoft Office Program: Microsoft Office Excel
This Excel VBA macro tutorial shows you how to clear or erase all of the items contained within a static array variable. This means that all text strings will be turned into empty strings and all numbers will be turned into zeros. However, this method will not change or alter the size of the static array.
Tutorial Length (mm:ss): 5:50
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to automatically run a Macro or VBA code before an Excel workbook or spreadsheet is closed. Specifically, you will learn how to run a Macro after a user tries to close a workbook or Excel file but before the file is actually closed. This allows you to automatically perform tasks within the workbook, using VBA, which the user might otherwise forget to do, such as protect worksheets, hide data, remove sample data, format text, etc.
Tutorial Length (mm:ss): 4:41
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to remove the columns from a Word document. This tutorial covers multiple methods for removing columns from an entire document and also how to remove column formatting from just a section of text or just a page or two of the entire document. This tutorial covers everything you need to know about removing columns from a Word document.
Tutorial Length (mm:ss): 3:45
Microsoft Office Program: Microsoft Office Word
This Excel UserForm tutorial shows you how to get values from a UserForm. You will learn how to get the values that a user inputs into the controls within a form and then how to do whatever you need with those values. This includes getting the input from a Textbox, ComboBox, ListBox, CheckBox, OptionButton (Radio Button), and ToggleButton. Every step of this process is covered in this tutorial, including how to reference UserForm controls from within the UserForm or from within a separate VBA Module. In addition, this tutorial will cover the types of output that come from different controls within the UserForm.
Tutorial Length (mm:ss): 8:10
Microsoft Office Program: Microsoft Office Excel
This tutorial shows you how to remove or delete just about everything from a chart in Excel. This includes removing chart labels, titles, text, and the legend. This tutorial shows you how to clean up the appearance of the chart and how to make it better blend in with your Excel spreadsheet. You will also learn how to input or restore every element that you delete or remove from the chart. This is a great tutorial to view if you need to edit or change the appearance of a chart in Excel.
Tutorial Length (mm:ss): 5:45
Microsoft Office Program: Microsoft Office Excel
This Excel UserForm tutorial shows you how to reset or clear the values for UserForm controls. You will learn how to reset all controls back to the default values as well as how to simply clear all input from the controls within the form. This means that you will be able to remove all text from a TextBox, selections from a ComboBox or ListBox, clear any CheckBoxes or OptionButtons, as well as reset ToggleButtons. This tutorial will help you prevent duplicate entries in Excel from the UserForm and will help to improve the overall UserForm experience.
Tutorial Length (mm:ss): 11:05
Microsoft Office Program: Microsoft Office Excel
This Excel tutorial shows you how to import XML files or data into Excel. This tutorial covers multiple different ways to import data from an XML file into Excel. You will learn how to quickly pull all of the data from an XML file into Excel as well as how to pull only specific information from an XML file into Excel. As well, you will learn how to organize data from an XML file within an Excel spreadsheet. This tutorial covers everything you need to know to pull data into Excel from an XML file.
Tutorial Length (mm:ss): 9:33
Microsoft Office Program: Microsoft Office Excel
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 and footers to pages; how to print title on every page; how to scale data to fit on one page; and a few other printing features. This tutorial does not cover every printing option but it does offer a comprehensive overview of what is available in terms of printing options and features in Excel and how to use many of those options.
Tutorial Length (mm:ss): 11:20
Microsoft Office Program: Microsoft Office Excel
This Excel Text tutorial shows you how to use the TRIM function in Excel in order to remove extra spaces from a cell. This is an especially important thing to understand in Excel since it is often times hard to visually determine if a cell contains extra spaces. The TRIM function will help to remove extra trailing, leading, and double spaces from data in Excel. This tutorial thoroughly covers how to use this function in order to clean up or remove the spaces from your data. This is a very important function to learn how to use, especially when performing data analysis within Excel.
Tutorial Length (mm:ss): 4:35
Microsoft Office Program: Microsoft Office 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.