Front Page

Excel Help HQ shares knowledge and tips on Excel problems. We focus on more obscure problems, memory aids and specialized VBA macro scripts generally suitable for heavy Excel users. Feel free to browse around or search our website to find tips and tricks.

Top Downloads

Excel templates and other downloads made by us. Our templates work off-the-shelf (without the need for any customization) and is made to be easily modified to fit your needs. If you want any modifications, troubleshooting, support, and do not want to do it yourself, feel free to hire us. Our services are reasonably priced and will save you a lot of time searching the Internet for solutions.

 

Top VBA Tutorials and Scripts

VBA scripts made to save you time from boring repetitive tasks. Topics span from basic VBA coding topics to very specific guides to perform certain actions.

 

Data Tables

Data tables is a very powerful tool if used correctly. Data tables, in its basic form, is “what-if” analysis in a grid form. In the following posts, we dig deeper into the topic.

 

Look Ups

Functions like vlookup and index & Match are handy when trying to look up data. A few posts below will teach you some new tricks and save you time.