When an Excel list is filtered, how can you show a total sum or count for numbers in the visible rows only? There are two Excel functions for that task…

Recently, I interviewed a few people for Power BI roles and here are some questions I asked in the initial rounds to assess their skill level. I’ve included sample answers…

Make it easy to enter valid data in an Excel workbook. Choose “Fastener” in one combo box drop down. The next combo box shows a list of fastener parts, with…

On the left side, we have a veteran warrior with 37 years of data battle scars and  redundant six pack.  They call him SQL. On the right side, there is…

In your job, are there Excel tasks that need to be done at month end? Here’s how I use a hidden hyperlink to help with my month end routine. Make…

Do you know that we can easily calculate the critical path for a project using Excel formulas? For a long time, it has been tricky to calculate the Critical Path…

Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain…

In some workbooks, you might need to block duplicate entries in a column. For example, we don’t want 2 employees to have the same ID number. See how to set…

Recently Microsoft announced Python support for Excel. This is a BIG news for everyone using Excel to analyze data or find insights. In this article, let me give you a…

Do you ever find yourself scrolling through an endless number of worksheet tabs, while you’re working in a large Excel file? It’s happened to me, more times than I can…