
How To Identifying Duplicate Values in Microsoft Office Excel Part 1
From time to time, you may need to identify duplicate values with a list in Excel. Modern versions, including Excel 2007, 2010, 2013 and later, provide this capability with just a few mouse clicks.
For good measure, I'll also describe…

How to Create Dynamic Cascading List Boxes In Excel
You may know how to create cascading validation drop down list in Excel. However, how to create dynamic cascading list boxes in Excel? This article introduces a VBA method to get it down.
As below screenshot shown, you need to create a parent…

How To Extract first letter of each word from sentence in Excel
Supposing you have a list of countries’ name in your worksheet, and now, you need to extract the first letter of each word in the cell as following screenshots shown. Normally, there is no direct feature to pick up the first letter of each…

How to quickly add dollar sign ($) in formulas in Office Excel
In Excel, you put dollar signs in a cell reference to keep it fixed when you copy a formula around. It's laborious having to type dollar signs into a cell reference, but fortunately there's a keyboard shortcut you can use instead!
Start…

How to quickly Concatenate Columns data in Office Excel
In your Excel workbooks, the data is not always structured according to your needs. Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column. Common…

How to quickly copy a Formula in Excel
There are many ways to copy a formula down a column in Excel, but by far the quickest is to simply double-click on the AutoFill Handle. To do this:
Select the cell containing the formula you want to copy.
Hover the mouse cursor over…

94. Excel: Complete list of Keyboard Shortcuts: Categorywise
This article describes keyboard shortcuts, function keys, and some other common shortcut keys for Microsoft Excel for Windows. This includes the access keys that you can use for Ribbon commands.
FREQUENTRLY USED SHORTCUTS
If you're new to…

93. Excel: General Keyboard Shortcuts
MS Excel offers many keyboard short-cuts. If you are familiar with windows operating system, you should be aware of most of them. Below is the list of all the major shortcut keys in Microsoft Excel.
Ctrl + A − Selects all contents of…

92. Pivot Tables
A pivot table is essentially a dynamic summary report generated from a database. The database can reside in a worksheet (in the form of a table) or in an external data file. A pivot table can help transform endless rows and columns of numbers…

91. Data Tables
In Excel, a Data Table is a way to see different results by altering an input cell in your formula. Data tables are available in Data Tab » What-If analysis dropdown » Data table in MS Excel.
Data Table with Example
Now, let us see…