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!!
Click here to pull up some of the coolest tips and tricks for using Excel, as submitted by members of our HelpMeExcel.com community.
Stay Tuned For Coming Attractions! We're currently working on converting some of the coolest Tips and Tricks we offer into video tutorials.
Click here to submit your Excel questions and/or your cool Excel Tips and Tricks. We'll respond to your question within 36 hours of your submission.
If you could benefit from some one-on-one coaching or a group seminar, click here. On-site and web-based coaching and seminars are our specialty.
Ask it here and we'll try to get you an answer via email or new tutorial.
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!!
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!
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.
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.
My darling bride’s definition of “a first date” was getting dressed up and having a lousy time. That is, until she met…
At times when opening Excel, you don’t want to go thru templates or trek down the memory lane of previously saved files.
Ever wished Excel could speak to you? Instead of seeking professional help and stronger medications, I propose you look (listen) to this!
Creating a Personal Workbook is definitely something you should have in your Excel “bag of tricks”. It will definitely increase your productivity!
The Quick Access Toolbar (QAT) is a customizable toolbar that is always visible no matter which ribbon is currently displayed in Excel.
Many users miss the big advantages of having “Clipboard Powers”. See how you can increase your productivity while you “Cut/Copy and Paste”.
Join our community and stay up to date with all our latest Excel tips and tricks.