Recent Blog Posts

 

Power Query – Running Total
VBA Code Snippets How to add a prefix or suffix to every cell using VBA
Convert Color Codes with VBA Convert color codes (RGB, HSL, Hex, Long, CMYK)
VBA Code Snippets Apportion a value across cells with VBA

 

Change image based on cell value - Featured image 3 ways to change or insert images based cell values
Remove blank rows - Featured Image Remove blank rows in Excel
Application.CutCopyMode = False Application.CutCopyMode = False
INDEX MATCH MATCH featured image INDEX MATCH MATCH in Excel: 2 dimension lookup

 

Subscribe to the newsletter to claim your free downloads

Subscribe to receive the newsletter.

  • Exclusive content, which is only for subscribers
  • My favorite tips and tricks to help you save time and achieve more
  • Free tools & downloads

The downloads are available to newsletter subscribers, click the button below to become a subscriber and download the free tools.

Download Icon

Check out the subscriber-only tools and downloads

Excel Downloads

 

Top Excel Books

 

Looking for a book to improve your Excel skills?  Have a look at these.

These are affiliate links, please read this for more information.