I think this #Excel tip will come as a relief, especially if you have inherited a workbook. Yes, quick statistics about your Excel workbook are now available.!. You may need to know how many...

I want to share with you a question from a subscriber. How to copy a worksheet It is going back to basics. They needed to take one worksheet from a sales workbook and create another workbook with...

Some Excel users do not mind the #DIV/0!, divide by zero error. I am not a fan, and whilst I like to be aware of any errors that Excel flags to me, on a presentation dashboard or a report, I think it...

This video and the corresponding blog post below is in response to a question I have been asked recently. A subscriber could not find or locate any Macros they had stored in their Personal Macro...

I kind of like odd things. Always have done, even this Function looks odd don’t you think?. It may be odd but heck it works if you want to identify odd numbers in your data. This Video has three...

This Excel tips video will show you how to Resize The Excel Formula bar. Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the http://www.howtoexcelatexcel.com blog for...