We can select a few cells in Excel and quickly see their count, sum etc. in the status bar. Ever wanted to customize the status bar to show something else,…

In Excel, you can use the drop down arrows in the table headings, to sort or filter the data. In this example, we'll filter for dates that fall within a…

Over the last few days Microsoft released XLOOKUP formula to the early adopters of Excel. Think of XLOOKUP as VLOOKUP 2.0. In this post, learn all about the function, syntax,…

Waffles = Power BI = Waffle chart in Power BI = So let’s make some waffle charts in Power BI. They can be a fun way to show single numbers…

Howdy folks. Almost the end of August here. Let’s wrap it up with a nice little partial text match in Excel challenge, inspired from my recent consulting gig. Say you…

Risk comes from not knowing what you are doing.Warren Buffet If you ever ask a project manager what they are up to, they will tell you “I have no idea“.…

Even if you love Excel, there might be times when you want to work on paper, instead of on the screen. I've made a printable Excel weekly planner, and you…

We, humans like to compare. Whether we are on Facebook or workbook, we want to compare. So how do you compare two tables and extract common values? Simple, use Power…

This is part of our Excel Interview Questions series. Subscribe for more questions. VLOOKUP or INDEX+MATCH? When you should use each function and why? This is such a great question…

Someone asked me how to create a chart where there could select a date range, and the chart would update automatically, to show results for those dates. Here's a quick…