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

Excel Classes - Microsoft Office Excel


Bookmark and Share

Top
This is an introduction to Excel and the Excel 2007 interface. This tutorial is geared towards people who know very little about Excel and need to learn the very basics about the Excel interface. This tutorial covers some of the basic and most used Excel terminology; the basic layout of Excel; how to use the Office Button; how to move around the worksheet, zoom, and pan; how to use and customize...
Tutorial Length (mm:ss): 15:57
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction to excel interface terminology beginner new starting
Top
This tutorial covers some of the main benefits and features of Excel as well as why you might want or need to use Excel. Some of the reasons you might want to use Excel include features that allow you to analyze data, update large amounts of data, chart or plot / graph data, sort data, collect data, and much more. This video provides an overview of these features and attempts to show you why you...
Tutorial Length (mm:ss): 13:46
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training benefits of using excel overview introduction features
Top
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...
Tutorial Length (mm:ss): 13:05
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training beginner enter data cells lists auto fill autofill handle drag drop line text numbers move right down tab key
Top
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 ...
Tutorial Length (mm:ss): 12:40
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction beginner formatting format apply excel 2007 fonts colors alignment wrap text merge cells number styles
Top
Learn how to insert, remove, re-size, cut, copy, paste, and delete rows, columns, and cells in Excel. This tutorial shows you how to edit the appearance and location of rows, columns, and cells in order to change the organization of the data within the worksheet. The features mentioned in this tutorial are a cornerstone to using Excel.
Tutorial Length (mm:ss): 11:15
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training insert remove resize rows columns organize data
Top
Learn how to use the AutoSum feature in Excel to quickly sum, average, and count numbers. This tutorial shows you how to use the AutoSum feature to easily enter functions on sets of numbers without having to know much if anything about the functions that are being entered into Excel. This feature also allows you to quickly enter many functions at once. This is a great little feature of Excel th...
Tutorial Length (mm:ss): 5:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training autosum auto sum add average count numbers functions excel
Top
Learn how to change a static table of data in Excel 2007 into a dynamic and professional looking table using the Format as Table feature in Excel 2007. This tutorial is an introduction to using the Format as Table feature and does not cover all of the possible benefits of this feature in depth. Using this feature allows you to quickly add new rows to the table that are already formatted to fit...
Tutorial Length (mm:ss): 7:57
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction format data table excel 2007 dynamic sort filter overview beginner
Top
This is an introduction to using formulas and functions in Excel. This tutorial assumes little to no prior knowledge of formulas or functions and serves as a walkthrough of how to use formulas and functions. This tutorial covers these topics related to formulas and functions: whatís required to enter them into cells; math operators for formulas; using arguments with functions, different types of...
Tutorial Length (mm:ss): 17:04
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training beginner introduction formulas functions formula bar basic insert function help arguments locate
Top
Create your first formula in Excel with this tutorial. You will learn the basics of what a formula is and how to create one. You will also learn about linking cells, how to change the reference of a linked cell, and the affects of changing the contents of linked cells.
Tutorial Length (mm:ss): 7:38
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction first formula excel create syntax how to calculations cell link linking
Top
This tutorial provides an introduction to adding, editing, and using charts and graphs in Excel 2007. This includes the three main ways to add charts to your workbooks and worksheets, including two keyboard shortcuts, and an overview of how to use the three chart editing tabs that appear after you add a chart or graph in Excel 2007. Some of the topics covered include how to change the chart type...
Tutorial Length (mm:ss): 11:52
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training charts graphs introduction overview basic beginner tabs move resize create edit
Top
This Excel Chart tutorial shows you how to how to create your first chart in Excel 2007. This tutorial covers how to setup your data so that it can be viewed in a chart; multiple different ways to create a chart; and how to edit the chart after it has been created. This tutorial shows you how to make great looking and useful charts in Excel 2007. Creating charts in Excel is covered step by step...
Tutorial Length (mm:ss): 12:05
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training create insert chart graph add data excel 2007 setup edit overview learn how to intro bar column pie
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
Top
Learn how to add, remove, move, rename, and edit worksheets and tabs in Excel 2007. This tutorial shows you how to better organize the worksheets within a workbook in Excel. This includes how to move worksheet tabs and how to create groupings of tabs using different colors for different tabs.
Tutorial Length (mm:ss): 4:35
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training worksheets tabs delete add remove color organize edit excel 2007
Top
Learn how to very quickly add pre-made worksheets and workbooks into Excel. This feature allows you to get workbook and worksheet templates for items such as expense reports, time sheets, calendars, budgets, and much more. Using this feature can save you a lot of time and provide a good jumping-off point for you when you are creating your own forms or worksheets in Excel. Note that these workboo...
Tutorial Length (mm:ss): 3:41
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training quickly add custom pre built made workbooks worksheets calendar reports
Top
This tutorial shows you how to save Excel workbooks in many different file formats and how to check if the file will be compatible with previous versions of Excel. The file formats covered in this tutorial include PDF, Excel 97-2003, and Macro Enabled Workbooks. These are the most commonly used file formats outside of the new Excel 2007 workbook format.
Tutorial Length (mm:ss): 7:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training save excel workbook file format different previous version pdf macro enabled compatibility checker
Top
Learn what workbooks with macros look like for Excel 2007 and how to open these workbooks as well as enable or disable the macros within the workbook. Also, this tutorial shows you how to change the default security settings so that macros are always enabled, always disabled, or something in-between. This is a great tutorial for people just learning about and how to use macros in Excel.
Tutorial Length (mm:ss): 4:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open workbook with macro security settings enable disable
Top
Learn the limitations of opening and using old Excel files in Excel 2007. This tutorial also includes a brief overview of the compatibility mode in Excel 2007 and some of the new features that are not compatible with older versions of Excel. As well, there is a brief mention of how to convert an old Excel file to a new Excel file format.
Tutorial Length (mm:ss): 4:02
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training open old workbooks compatibility mode limits
Top
Learn how to convert your old workbooks to the new Excel 2007 workbook file format. This tutorial shows you two different ways to make this conversion. One way simply converts the current file into the new file format while the other way shown in the tutorial leaves the original file intact, similar to a backup copy, while creating a new file for you in the new Excel 2007 file format. Convertin...
Tutorial Length (mm:ss): 3:39
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training convert save as previous versions excel new old workbooks file format
Top
This tutorial covers pretty much everything you need to know about the Formula Bar in Excel 2007. This includes how to enter, edit, and cancel functions and formulas from the Formula Bar as well as how to resize the Formula Bar.
Tutorial Length (mm:ss): 5:14
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training formula bar in excel 2007 view functions edit insert formulas resize hide
Top
This tutorial explains what the order of operations is and how it is used in Excel. This is also sometimes known as PEMDAS for Parenthesis, Exponent, Multiplication, Division, Addition, and Subtraction. The order of operations is very important for mathematical calculations in Excel and needs to be mastered before you can learn more complicated formulas and functions.
Tutorial Length (mm:ss): 7:32
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training formulas operators order of operations pemdas parenthesis math mathematical
Top
Learn how to enter your first function in Excel with this tutorial. Specifically, you will learn the syntax required to enter any function into Excel; the different types of arguments that you can enter into a function; how to find a definition and explanation of a function; and how to reference cells for function arguments. This is a great tutorial for anyone just starting out with formulas and...
Tutorial Length (mm:ss): 9:53
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction overview first function excel syntax arguments help
Top
Create your first formula in Excel with this tutorial. You will learn the basics of what a formula is and how to create one. You will also learn about linking cells, how to change the reference of a linked cell, and the affects of changing the contents of linked cells.
Tutorial Length (mm:ss): 7:38
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction first formula excel create syntax how to calculations cell link linking
Top
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
   
Keywords: training link linking cell values formulas functions operations operators
Top
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
   
Keywords: training combine formulas functions cell & ampersand concatenate
Top
This feature of Excel allows you to search for a function like a search engine searches websites; you simply enter some search terms and Excel returns every function similar to your search terms.
Tutorial Length (mm:ss): 4:11
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training insert search excel for function quickly
Top
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
   
Keywords: training easy insert functions complex complicated arguments formulas tab
Top
Learn how to cut, copy, and paste formulas and functions in Excel. This tutorial includes an explanation of absolute and relative cell references. You will learn how to move formulas and functions around a spreadsheet while preventing parts of the formulas or functions from changing or updating based on the new position of the formula or function. This will allow you to quickly add many formula...
Tutorial Length (mm:ss): 8:34
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training absolute relative cell references formulas functions cut copy paste move quick fill handle dollar sign f4
Top
This tutorial covers proper function usage in Excel. Proper function usage includes separating variables from the functions and formulas in which they are used. Separating the variables from the functions allows you to easily and quickly change the values used in the functions or formulas without having to actually change the functions or formulas themselves.
Tutorial Length (mm:ss): 4:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training proper function formulas usage separate separating variables arguments link cells
Top
Use the new Formulas Tab in Excel 2007 in order to locate functions and to easily insert them into Excel. This feature in Excel 2007 is really helpful when you are not sure exactly which function you want to use or when you are just browsing for functions. Also, entering a function from the Formulas Tab allows you to use the Insert Function feature, which walks you through entering the arguments...
Tutorial Length (mm:ss): 4:46
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training functions excel 2007 formulas tab insert
Top
IF statement syntax and usage overview and introduction in Excel. The IF statement is one of the most important functions in Excel; it is used to make decisions and is part of the logical functions in Excel. This function essentially makes decisions based on input. For instance, if A > B do this.
Tutorial Length (mm:ss): 7:53
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training introduction overview IF statement syntax function excel logical condition
Top
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
   
Keywords: training change case text upper lower proper functions formulas
Top
Use the TODAY and NOW functions in Excel to display the current date and time. This tutorial also covers how to use the number formatting options in order to change the way the date and time are displayed with the TODAY and NOW function in Excel.
Tutorial Length (mm:ss): 4:35
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training current todays date time excel today now functions formatting
Top
This Excel Graph and Chart tutorial shows you how to insert many different types of charts into Excel. This tutorial covers the two basic ways to add all of the different chart types available in Excel into a spreadsheet. This provides you with a good overview of different chart types in Excel.
Tutorial Length (mm:ss): 5:40
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training insert add types data graph chart different create excel make visual how to
Top
This Excel Chart tutorial shows you how to change a Chartís type after it has already been created in Excel. This will allow you to quickly and easily change charts within a spreadsheet or worksheet without having to recreate them. This tip will save you a lot of time when working with Charts or Graphs in Excel.
Tutorial Length (mm:ss): 2:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training chart type graph change create excel add use column bar pie pyramid
Top
This Excel Chart tutorial shows you how to move charts to other worksheets within a workbook in Excel. Specifically, you will learn how to copy a chart to many worksheets; how to move a chart to another worksheet; and how to move a chart onto a chart sheet. This tutorial will save you a lot of time when you need to organize charts within an Excel workbook.
Tutorial Length (mm:ss): 5:31
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training move charts worksheet tab separate another chart sheet excel different resize how to
Top
This Excel tutorial shows you how to very quickly create a Chart or Graph using a keyboard shortcut in Excel. You will learn how to create a chart within the current worksheet or tab and also within a separate chart tab. These shortcuts will save you a lot of time and increase the speed with which you create spreadsheets in Excel.
Tutorial Length (mm:ss): 3:32
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training keyboard shortcut graph chart create excel make quickly insert data
Top
This Excel Chart tutorial shows you how to align a chart in Excel 2007 and later perfectly with any cell, row, or column within the worksheet. This tutorial shows you a feature that makes positioning a chart within the worksheet easy. You will learn how to quickly align, position, and resize, all of your charts evenly and professionally throughout the worksheet.
Tutorial Length (mm:ss): 3:21
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training align chart cell row grid column excel resize move position easily
Top
Learn how to create a drop down menu or list in Excel using the data validation feature. This is the introductory tutorial for creating drop down menus and lists.
Tutorial Length (mm:ss): 5:51
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation drop down menu list
Top
Learn how to use the new Remove Duplicates feature in Excel 2007 to remove duplicate entries in a list or data set in Excel. This is a great new feature that provides for a lot of functionality and removes the need to use a macro to remove duplicates in Excel.
Tutorial Length (mm:ss): 3:01
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training remove duplicate duplicates new feature excel 2007
Top
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 o...
Tutorial Length (mm:ss): 4:42
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort excel sorting data spreadsheet alphabetical numerical alphabetically atoz order reverse text numbers
Top
This Excel sorting tutorial will show you how to sort data based on cell color, font color, and icon set. This will allow you to refine your data by color and increase the ability to analyze the data. This sorting tutorial also briefly covers conditional formatting in Excel, which is tied together with sorting based on font color, cell color, and icon set. This is an advanced sorting technique ...
Tutorial Length (mm:ss): 11:06
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort data sorting excel cell font color icon set sets conditional formatting format advanced
Top
This Excel data analysis sorting tutorial will show you how to sort case sensitive data in Excel. This is the same as a regular sort except that it also takes into account the case of the data being sorted. This is a great feature to learn when you need to sort values where upper and lower case letters mean different things.
Tutorial Length (mm:ss): 5:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort sorting excel case sensitive data analysis order numeric alphabetical
Top
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...
Tutorial Length (mm:ss): 10:16
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training import excel text csv file open files comma separated text value values delimiter delimited comprehensive overview explanation
Top
This Excel date and time tutorial shows you how to add days, months, and years to a date in Excel. This tutorial covers this complicated subject in a step by step manner and thoroughly explains everything along the way. Adding days or months or years to a date is an often required task and, once you watch this tutorial, will be very easy for you to do. As well, this tutorial covers multiple dif...
Tutorial Length (mm:ss): 17:48
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training date time excel dates month day year times calculate compute formula function add
 
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.