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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
