Recent Blog Posts

 

VBA Code Snippets VBA Arrays
VBA Code Snippets VBA to protect and unprotect Sheets
Top 10 with formulas featured image Top 10 with formulas in Excel
Power Query - Absolute and relative references - featured image Power Query – Absolute and relative references

 

Auto-refresh Power Query Featured Image Auto refresh Power Query on parameter change
Crack Excel passwords with VBA
VBA Code Snippets Swap ranges, rows and columns in Excel
Power Query Percent of Total Featured Image Power Query – Percent of total or category

 

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.