XLf(x)s

Starting Excel 2007, users are not getting easy access to developer stuff. Not sure why is that, but we can go around that, so quickly,...

Again, thanks to one of my students, I am getting another post with example 🙂 I did promise her to post it after she sounded...

The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or...

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore...

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will...

Excel 2010 was great because you can easily open another Excel session while your current session is working. This allowed us to run multiple tools...

Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter...