How to compare data in two columns to find duplicates in Excel
You can use the following methods to compare data in two Microsoft Excel worksheet columns and find duplicate entries.
Keyboard shortcuts in Excel - Microsoft Support
Press Ctrl+F, and then type your search words. If an action that you use often does not have a shortcut key, you can record a macro to create one. For instructions, go to Automate tasks …
IF function – nested formulas and avoiding pitfalls
Let’s look at how to properly create a complex nested IF statement using multiple IFs, and when to recognize that it’s time to use another tool in your Excel arsenal. Following is an example of …
Add a list box or combo box to a worksheet in Excel
When you want to display a list of values that users can choose from, add a list box to your worksheet. Create a list of items that you want to displayed in your list box like in this picture. …
Add a column from an example (Power Query) - Microsoft Support
Use Excel's Get & Transform (Power Query) experience to add new columns of data in the Query Editor by simply providing one or more sample values for your new column. You can create a …
Merge and unmerge cells - Microsoft Support
After merging cells, you can split a merged cell into separate cells again. If you don't remember where you have merged cells, you can use the Find command to locate merged cells quickly. …
Video: Add and delete table rows and columns - Microsoft Support
How to add rows and columns for more data, or delete cells you no longer need.
Enter data in multiple worksheets at the same time
In Excel, you can enter the same data into several worksheets without retyping or copying and pasting the text into each one.
Create a table in Excel - Microsoft Support
Training: In Microsoft Excel, you can create a table to easily group and analyze data. Then you can quickly format the table and apply a design style. Watch this video to learn how.
Excel data types: Stocks and geography - Microsoft Support
You can get stock and geographic data in Excel. It's as easy as typing text into a cell, and converting it to the Stocks data type, or the Geography data type. These two data types are …
How to correct a #NAME? error - Microsoft Support
To avoid typos in formula names, use the Formula Wizard in Excel. When you start typing a formula name in a cell or the Formula Bar, a list of formulas matching to the words you've …