Have you ever pasted a long list of data, and then wondered if you completely pasted over the existing data?
In the following video I explain how to use the keyboard shortcut Ctrl+. (period) to quickly answer this question. It’s one of my favorite keyboard shortcuts because it can save you from having to scroll hundreds or thousands of rows with the mouse.
In the last two videos I explained how the Tab Hound and Tab Control add-ins can save you a ton of time with your everyday Excel tasks. Here are links to the two videos in case you missed them.
In the last video we learned how Tab Hound can save time with common tasks like finding and jumping to sheets, flipping between sheets, and unhiding multiple sheets.
Do you spend time doing any of the following tasks in Excel?
In this post I will explain how to compare two or more lists of names using a Pivot Table.
The INDEX function is commonly used in combination with the MATCH function to provide powerful and dynamic lookup formulas.
This post will just focus on explaining the how the INDEX function works. It is best to understand the basics of INDEX before creating more advanced formulas using INDEX & MATCH.
This post provides an explanation of how to use the VLOOKUP and MATCH functions to give you better control over how the column index number changes. This is often referred to as a dynamic formula. You will learn how this dynamic duo can help prevent errors and improve your VLOOKUP formulas.