## Excel Data Validation using Dependent Lists

Using Dependent Lists is an excellent trick that allows you to input information in Excel faster and with more precision thanks to the data validation functionality....

From Aldo Mencaraglia

Using Dependent Lists is an excellent trick that allows you to input information in Excel faster and with more precision thanks to the data validation functionality....

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/10/excel-substitute-formula-trick/ The SUBSTITUTE function in Excel allows you to substitute specific portions of text within a larger string....

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/09/how-to-calculate-the-number-of-work-days-between-two-dates/ Excel has a function which allows you to calculate the number of work days between two dates. This can be particularly useful for Human Resources professionals...

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/09/how-to-calculate-the-number-of-work-days-between-two-dates/ Excel has a function which allows you to calculate the number of work days between two dates. This can be particularly useful for Human Resources professionals...

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/07/how-to-apply-vlookup-across-worksheets/ Using different worksheets for a VLOOKUP function is a good way to create an efficient spreadsheet....

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/06/how-to-create-a-chart-with-data-not-next-to-each-other/ In an ideal world, you would have data in an spreadsheet set up in such a way so that Excel can easily create a chart. Sometimes however you might need to keep the ...

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/06/how-to-create-a-chart-with-data-not-next-to-each-other/ In an ideal world, you would have data in an spreadsheet set up in such a way so that Excel can easily create a chart. Sometimes however you might need to keep the ...

From Aldo Mencaraglia

The MIN, MAX, SMALL and LARGE functions in Excel are effective in finding data within a range....

From Aldo Mencaraglia

http://www.xlninja.com/2012/08/01/excel-ceiling-and-floor-formulas/ The Ceiling and Floor formulas in Excel allow you to set a ceiling and a floor on certain values....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/31/the-iferror-function-to-manage-error-messages-in-excel/ You can use the IFERROR function to manage error messages that appear in Excel cells....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/31/the-iferror-function-to-manage-error-messages-in-excel/ You can use the IFERROR function to manage error messages that appear in Excel cells....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/30/convert-to-lower-case-in-excel/ How do we convert it to lower case? or the other way round? It's very simple. There are three functions in Excel that can help with this issue. First of all, the 'lower' function transf...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/30/convert-to-lower-case-in-excel/ How do we convert it to lower case? or the other way round? It's very simple. There are three functions in Excel that can help with this issue. First of all, the 'lower' function transf...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/27/excel-cumulative-sum-formula/ There are a couple of easy ways to add a running total to a range of data in your spreadsheet....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/26/how-to-find-duplicate-values-with-conditional-formatting/ This is an update on a previous article on how to find Duplicate Values in Excel. Thanks to Bluesbender69 for the tip....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/25/excel-choose-function-explained/ The CHOOSE function in Excel allows you to 'Choose' a "value' depending on a specific input....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/24/tips-for-making-your-excel-chart-more-interesting/ The default charts that Excel makes available might not be what you are looking for. With a few formatting changes you can make a chart much more interesting and effect...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/23/how-to-calculate-someones-age-from-a-date-in-excel/ A little known function in Excel allows you to calculate someone's age in years, months and days. You can use this function more in general to calculate the time elapse...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/20/excel-basics-formulas/ This is a video aimed at Excel beginners which explains the basics behind the use of formulas in Excel....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/19/search-with-conditional-formatting/ Conditional Formatting can be used very effectively to visually highlight the result of a search query within Excel....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/18/how-to-find-duplicate-values-in-excel/ Often you will have a set of data with duplicate values due to typing errors. How do you find those duplicate values easily so that you can remove them? The idea for this video wa...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/17/how-to-format-individual-data-points-in-excel-chart/ Formatting individual data points in Excel can be a very useful way to highlight information better than using a default Excel chart....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/16/calculated-fields-pivot-table/ When you set a pivot table up in Excel you might want to perform calculations using the base data. For instance, you might have information about sales revenue and sales commission and you ...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/16/calculated-fields-pivot-table/ When you set a pivot table up in Excel you might want to perform calculations using the base data. For instance, you might have information about sales revenue and sales commission and you ...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/13/make-excel-speak-to-you/ A very cool functionality of Excel is the one that makes Excel speak to you as you input information. Watch this video to understand how to activate it!...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/11/absolute-reference-and-relative-reference-in-excel/ Knowing the difference between absolute reference and relative reference in Excel is vital to make the best use of formulas....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/10/how-to-delete-blank-rows-in-excel/ Often you will receive a spreadsheet with information organised in a table but with blank rows. How do you delete blank rows in Excel quickly and easily?...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/09/how-to-use-the-today-function-in-excel-to-calculate-late-payments/ The TODAY function in Excel is very useful to calculate how late payments are....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/09/how-to-use-the-today-function-in-excel-to-calculate-late-payments/ The TODAY function in Excel is very useful to calculate how late payments are....

From Aldo Mencaraglia

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #15 Video topics: 1)Excel Date Calculations and Format 2)Excel Time Calculations and Format 3)Date Format Math for formulas 4)Time Format Math for form...

From Aldo Mencaraglia

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #15 Video topics: 1)Excel Date Calculations and Format 2)Excel Time Calculations and Format 3)Date Format Math for formulas 4)Time Format Math for form...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/06/the-index-function-for-finding-a-value-buried-in-an-avalanche-of-data-in-excel/ The INDEX function is very useful for finding a specific value buried in thousands of data points. Used in conjunction with the MATCH functi...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/05/how-to-filter-in-excel/ The ability to quickly filter data in Excel can save you hours of time and help you become more effective in your job....

From Aldo Mencaraglia

Learn how to analyse data better by using a filter to display only data that you want to see....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/04/the-and-function-in-excel/ With the AND function in Excel you can highlight items that satisfy multiple conditions. See how to use the AND function to highlight which products sell the most and are also profitable using...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/04/the-and-function-in-excel/ With the AND function in Excel you can highlight items that satisfy multiple conditions. See how to use the AND function to highlight which products sell the most and are also profitable using...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/02/excel-charts-secondary-axis-how-to-improve-your-chart/ The Secondary Axis is an effective way of improving your Excel charts and can be very useful when you need to represent on the same chart two sets of data which have...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/02/excel-charts-secondary-axis-how-to-improve-your-chart/ The Secondary Axis is an effective way of improving your Excel charts and can be very useful when you need to represent on the same chart two sets of data which have...

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/03/how-to-create-an-excel-dynamic-chart/ An Excel Dynamic Chart is an excellent way to wow your audience as it requires a level of Excel knowledge higher than the average Excel user....

From Aldo Mencaraglia

http://www.xlninja.com/2012/07/03/how-to-create-an-excel-dynamic-chart/ An Excel Dynamic Chart is an excellent way to wow your audience as it requires a level of Excel knowledge higher than the average Excel user....

From Aldo Mencaraglia

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm 1. IF Function: Put 1 of 2 things into a cell based on a logical test 2. AND Function: When all logical tests are passed, AND delivers a TRUE; If any one of the tests come out FALSE, AND...

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/29/cleaning-data-in-excel/ How often do you receive an Excel spreadsheet with information that is written incorrectly and you have to spend hours to clean it up? Very often! With this video I will share a quick and easy wa...

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/28/how-to-use-excel-to-highlight-employee-performance-rating/ A video on how to use Excel within a Human Resources context. How do you highlight Employee performance according to where the rating falls within the range of ...

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/27/how-to-create-a-drop-down-box-in-excel/ A Drop Down Box in Excel helps you to input in a much more efficient and accurate way a large amount of information. In this video I will show you a step-by-step procedure to crea...

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/25/match-one-of-the-best-functions-to-help-you-find-what-you-are-looking-for-in-excel/ The MATCH function is a very powerful tool for finding specific data within a large set of information in Excel....

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/22/excel-pivot-table-tutorial/ A Pivot Table in Excel is one of the most powerful tools available for analysis of large sets of data....

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/21/how-to-custom-format-a-number-in-excel/ The ability to custom format a number in Excel is a powerful tool to enhance how you display numbers in your spreadsheet....

From Aldo Mencaraglia

http://www.xlninja.com/2012/06/20/vlookup-function-one-of-the-best-functions-to-know-in-excel/ The VLOOKUP function is definitely one of the most useful functions to know in Excel. Its objective is to allow you to find a specific value within a large ra...

From Aldo Mencaraglia