Recent Blog Posts

 

VBA Code Snippets Swap ranges, rows and columns in Excel
Power Query Percent of Total Featured Image Power Query – Percent of total or category
VBA Code Snippets VBA code to control and manage Excel Tables
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

 

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.