Author Archives: Mariana Trapnell
Freeze Panes, Not Brain Cells
Rather than using valuable brain cells trying to remember what data appears in each column as you scroll down your list, use Freeze Panes to force headers to stay at the top and left of your sheet.
Fabulous F4
The F4 key is a fabulous shortcut to speed up your Excel work. It will hold your ranges constant by adding dollar signs, but it can also be used to make your formatting faster. If you haven’t already done so, please visit the following link to receive an alert when new posts are available, or…
Automatic VLOOKUP Column References
Even if you’re an experienced Excel user, you may not know this handy trick for automating column number references in the VLOOKUP formula. We’ll also cover holding the other range references constant by using the F4 key on your keyboard. In case you missed it, check out the first post on VLOOKUP here, and/or read…
What’s Up with VLookup?
Vlookup is one of the most talked about formulas and is also a great time-saver when you’re combining a lot of data together, but is also one that gives people a lot of trouble. It can be a bit picky when it comes to the different pieces you need to enter and I share a…
SHIFT into high gear on your Excel analysis
Use the SHIFT key on your keyboard to select data between two cells. Combining it with the CTRL key at the same time makes for a dynamic duo that lets you quickly select ranges for further analysis or action. Thanks for stopping by! p.s. You can check out other posts on the Blog feed or Sign up to…
Fast Excel Analysis with the CTRL Key
Fast Excel analysis isn’t always about formulas and pivot tables. Sometimes, it’s just about knowing how to move through your data quickly so you can get where you need to be and carry on with your review. This short video looks at how to use the CTRL key on your keyboard to do just that.…