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…

Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with…

This week, I am running a contest on YouTube. One of the criteria for picking winners is that they must comment on my video. So far, I got more than…

Written by Debra Dalgleish from Contextures Blog Do you spend lots of time in Excel tables, filtering the data, then clearing those filters later? If so, this free add-in from…