Written by Debra Dalgleish from Contextures Blog Do you remember the number grids from your schools days, where you filled in the multiplication answers? What's 4 times 8? Or 9…

Pivot tables are powerful. Use these 6 tricks to save time when working with them. 1 - Double click to see details Ever wondered what numbers add up to the…

Hello folks. 50% of 2020 is behind us. Let me share a few updates with you all. First check out this awesome double rainbow outside our house on 30th June.…

Written by Debra Dalgleish from Contextures Blog There's been an update to my Excel Search Form Builder (SFB), so download the latest version if you've bought this product before. In…

Are you AND(“In IT”, “Use Excel”)? Then this article is for you. Here is my list of top 10 Excel formulas for people in IT. As software miners use Excel…

Written by Debra Dalgleish from Contextures Blog Since you love Excel, you probably already noticed that today (June 15, 2020), is Excel day 44000. You'll see that if you type…

I have a fun Excel lookup challenge for you. You have data as shown below and want to find the last non blank value for a given account number. For…

Written by Debra Dalgleish from Contextures Blog The golf courses aren't too crowded here this summer, because of the social distancing rules. So, if you're trying to spread out the…

Use TEXTJOIN function to combine text values with optional delimiter. It is better than CONCATENATE because you can pass a range instead of individual cells and you can ignore empty…

Power BI is great for visualizing and interacting with your data. In this article, let me share a technique for creating variance chart in Power BI. Variance charts are perfect…