How to Create and Use Custom Lists (Excel)
If you use a specific list frequently (i.e. states or sales peoples names), you can save time by creating your own lists to use with auto-fill.
How to Use Index/Match Instead of Vlookup (Excel)
Using Vlookup is a great tool, however, if you add columns to your original table of data, you will have to create a new Vlookup formula. If you use Index/Match, you can add or remove columns without having to create…
How to Use ‘Flash Fill’ or ‘Concatenate’ to Combine Multiple Columns into One (Excel)
There are times when you may have data in multiple columns that need to be combined into one. You can use the ‘Concatenate’ function to easily accomplish this task. In this example, we will take two columns that contain a…