Warning: mysqli::mysqli() [mysqli.mysqli]: Headers and client library minor version mismatch. Headers:50642 Library:50173 in /usr/www/users/excelish/teachmsoffice/includes/connect/connect.php on line 9
Data Analysis - Excel - Microsoft Office Video Tutorials & Training - Excel, Word, PowerPoint - Teachmsoffice.com
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

Data Analysis - Microsoft Office Excel


Bookmark and Share

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
Quick Version of the Tutorial - 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): 3:02
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation drop down menu list quick version
Top
Learn how to create a drop down menu or list in Excel where the source data for the list is on another worksheet or on a hidden worksheet. This method allows you to create cleaner looking spreadsheets and to hide the source data in order to improve the end-user experience.
Tutorial Length (mm:ss): 5:58
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation drop down menu list separate hidden worksheet tab
Top
Learn how to automatically update a drop down list or menu in Excel. This tutorial shows you how to create a drop down list or menu that automatically updates whenever and item is added to or removed from the list or menu. Also covered is how to achieve this result with source data on a different worksheet than the list or menu. This is achieved using the offset and counta functions.
Tutorial Length (mm:ss): 10:41
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation drop down menu list automatically dynamically easily quickly update
Top
Create dependent drop down menus or lists in Excel. This tutorial shows you how to link multiple drop down menus so that different items will appear in the menus based on what was selected in a previous menu or list; this functionality is achieved using data validation and the indirect function.
Tutorial Length (mm:ss): 7:02
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation drop down menu list link dependent dependant
Top
Create dependent drop down menus or lists in Excel using complex two word or multi-word list items. This tutorial shows you how to link multiple drop down menus so that different items will appear in the menus based on what was selected in a previous menu or list; this functionality is achieved using data validation and the indirect and substitute function.
Tutorial Length (mm:ss): 7:04
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation link dependent dependant drop down menu list complex spaces multi-word two word
Top
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
   
Keywords: training excel data validation list allow specific values only prevent
Top
Learn how to create a custom input error message dialog box for cells in Excel. This feature works when you prevent the entry of certain values into a cell.
Tutorial Length (mm:ss): 2:53
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation custom input error message window
Top
Learn how to create a helpful input message box that appears next to a specific cell when that cell has been selected. This feature is great for providing reminders or tips for what to enter into specific cells in Excel.
Tutorial Length (mm:ss): 2:27
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation helpful input message box window
Top
This tutorial covers how to limit the range and scope of numbers that a user can enter into cells in Excel. This functionality is achieved using data validation.
Tutorial Length (mm:ss): 3:36
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation limit numbers numeric amount cells
Top
Limit the total numeric amount or value that a user can enter into a range of cells in Excel. This tutorial uses a travel budget as an example and the functionality comes from data validation.
Tutorial Length (mm:ss): 6:54
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation limit amount entered range cells travel budget
Top
Prevent duplicate values or entries from being entered into a range, worksheet, column, or row in Excel. This tutorial uses the data validation method and the countif function to control what a user can enter into a cell.
Tutorial Length (mm:ss): 4:44
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation prevent duplicate values entries list range
Top
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
   
Keywords: training excel data validation limit text character length cell
Top
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
   
Keywords: training excel data validation prevent upper lower proper case input entry cell
Top
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 n...
Tutorial Length (mm:ss): 15:03
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data validation force entries cells start end specific values characters numbers
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 video training tutorial shows you how to remove duplicate values from a list based on multiple columns. This means that multiple columns within a row must match another row before it will be removed. This allows you to perform sophisticated duplicate value removal in an Excel spreadsheet. This tutorial is specific to Excel versions 2007 and later.
Tutorial Length (mm:ss): 5:55
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data remove delete duplicate duplicates values cells rows multiple columns
Top
This Excel video training tutorial will show you how to quickly and easily remove any blank or empty cells from a column in Excel. This tutorial shows you a method for quickly removing cells that works on a few cells or hundreds of thousands of cells and all without the use of a macro or VBA in Excel.
Tutorial Length (mm:ss): 3:58
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data remove blank empty cells cell from column
Top
This Excel video training tutorial will show you how to quickly and easily remove any blank or empty cells from a row or multiple rows in Excel. This tutorial shows you a method for quickly removing cells that works on a few cells or hundreds of thousands of cells and all without the use of a macro or VBA in Excel.
Tutorial Length (mm:ss): 4:29
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data remove delete clear blank empty cells cell from row rows
Top
This Excel video training tutorial will show you how to quickly and easily remove any blank or empty columns from a list, data set, or table in Excel. This tutorial shows you a method for quickly removing columns that works on a few columns or thousands of columns and all without the use of a macro or VBA in Excel.
Tutorial Length (mm:ss): 4:11
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data remove delete clear blank empty columns cells cell from list set table
Top
This Excel video training tutorial will show you how to quickly and easily remove any blank or empty rows from a list, data set, or table in Excel. This tutorial shows you a method for quickly removing rows that works on a few rows or hundreds of thousands of rows and all without the use of a macro or VBA in Excel.
Tutorial Length (mm:ss): 4:10
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training excel data remove delete clear blank empty rows cells cell from list set table
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 quickly and easily sort data in Excel using the mouse. This method allows you to forgo using the Ribbon menu to sort data and will increase the speed and efficiency with which you sort data in Excel.
Tutorial Length (mm:ss): 3:03
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort data excel quickly fast easy easily mouse spreadsheet efficiency efficient
Top
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
   
Keywords: training sort data excel sorting text alphabetical order lowest highest
Top
This Excel sorting tutorial will show you how to sort numbers in Excel from lowest to highest and highest to lowest. 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:45
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort data excel sorting numbers numerical lowest highest
Top
This Excel sorting tutorial will show you how to sort dates and time in Excel. This tutorial covers some of the things to watch out for when you need to sort this type of data and how to ensure that the sort is performed correctly. This is an important type of sort to use in Excel when you need to view your data across a timeline.
Tutorial Length (mm:ss): 5:13
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort data sorting excel date dates time times numbers earliest latest
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 sort tutorial will show you how to perform a sort on multiple columns of data at the same time in Excel. This means that you can refine sorting to include multiple different criteria and multiple levels at the same time. This will allow you to create more sophisticated and useful sorts in Excel.
Tutorial Length (mm:ss): 6:16
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort sorting excel multiple levels columns data advanced refine criteria
Top
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 bett...
Tutorial Length (mm:ss): 5:26
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort excel data sorting left to right rows row numbers text analysis
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 sorting tutorial will show you how to sort one column or a small group of columns in Excel without sorting or rearranging the adjacent columns. This means that you can sort subsets of your data and not affect or change the order of the rest of the data in the spreadsheet. This is a very important feature of sorting in Excel and will help you to better organize and refine your data. T...
Tutorial Length (mm:ss): 3:55
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training sort data sorting excel one column next subset adjacent data set table advanced
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 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
   
Keywords: training import excel text csv file open view files comma separated text value values delimiter delimited quick version
Top
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...
Tutorial Length (mm:ss): 9:33
Microsoft Office Program: Microsoft Office Excel
   
Keywords: training import excel xml text file open view files data value values arrange organize map maps developer
Top
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
   
Keywords: training import web data query website internet excel view open files page pages text values stocks prices numbers
Top
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
   
Keywords: training export save excel csv file comma separated data value values delimiter delimited text numbers
 
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.