It is not uncommon to face large amounts of data that need to be aggregated across myriad cells in Excel. If you have to =SUMIFS() through big ranges, you might spend too much time waiting for the calculations to finish. Better data structure and focus on efficiency might help you out of this situation. Read More
In order to make spreadsheets better for everyone involved with them, there are many rules to follow. 3 of them are Being aware of the end user; Putting proper checks; and Avoiding hard inputs.
In this post I explain why. Read More