VLOOKUP was one of the first functions I learned. As I began using it, I felt like a superhero!
VLOOKUP searches for specific data in a data table. VLOOKUP can be static or dynamic.
Click to learn more!!
You’re About to Input Something That Will Rip the Space-Time Continuum…
Have you ever received a database that contains data in a column with misspellings, inconsistent formats or multiple variations of abbreviations?
Click here to find out how to ensure that you’re using valid data!
Alright, Mr. Demille, I’m Ready for My Close Up! (Excel Camera Feature)
There are times when an Excel schedule, as presented, is disjointed to the point of appearing much like some cubist painting. This tip will help you avoid that type of goofy presentation.
Templates!!
Cookies I shape “freehand”, end up looking like science fiction experiments gone bad. Excel cookie cutters (aka Templates) ensure that your presentations are more appealing, consistent and will save time.
Dating Isn’t Really That Hard!
My darling bride’s definition of “a first date” was getting dressed up and having a lousy time. That is, until she met…
Speed Up Your Opening!
At times when opening Excel, you don’t want to go thru templates or trek down the memory lane of previously saved files.
SPEAK TO ME!!
Ever wished Excel could speak to you? Instead of seeking professional help and stronger medications, I propose you look (listen) to this!