Free tips and tricks

Click here to pull up some of the coolest tips and tricks for using Excel, as submitted by members of our HelpMeExcel.com community.


In-depth video tutorials

Stay Tuned For Coming Attractions! We're currently working on converting some of the coolest Tips and Tricks we offer into video tutorials.


Interactive community

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.


One-on-one coaching

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.

Got an Excel question?

Ask it here and we'll try to get you an answer via email or new tutorial.

  • Jim Tobin has been a life saver over the years. His Excel skills and overall knowledge helped my company through three different payroll software conversions which is a bear. Jim’s macros automated many of our accounting processes which increased staff productivity and shortened month-end close time. Jim even sat with me a full day watching me work, showing me how to streamline everything I was doing. I continue to apply his tips and tricks to my job every day. It is nice to know I have someone trustworthy to call for any needed project or problem.  Anyone who utilizes Jim’s abilities is making a smart move!
    Angie A.
    Director of Central Accounting at Aimbridge Hospitality
  • We hired Jim to assist with an accounting software enhancement that involved several hundred entities and thousands of account and vendor records. Jim and his team executed the processes flawlessly. I also hired them to assist with several process improvements that required extensive Excel knowledge using data from multiple resources to achieve the results we needed. These process improvements shaved days from our monthly workload.Whenever I have a project that requires excellent Excel skills, attention to detail, thorough accounting knowledge, and an ownership mindset, Jim is the only company I will turn to.
    Monica K.
    CFO at Western International

Tips and tricks

VLOOKUP Made Me Feel Like A Superhero!!!

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!!

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!

Join our community

Join our community and stay up to date with all our latest Excel tips and tricks.