Here’s a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here’s the solution!
Read more
Here are some nice tricks on how to quickly insert formulas in Excel. Forget all that dragging of the fillhandle and stuff. With these tricks you will be inserting formulas in no time.
In this tutorial I show you how to sum diagonally using an array formula. You will also learn how to add conditional formatting in order to track the diagonal being summed.
In this short tip, I describe how you can return the names of files located in a folder without using VBA.
This is a very neat and easy trick to perform.