A trick with MONTH() Function in Excel
I guess we are all familiar with the MONTH function in Excel. If you give it a date as an argument, it will return the month number. So far so… Read more »
Author Archives: excelgoodies
When to use Multi-Cell Array Formulas
Excel Multi-cell array formulas are a single formula which returns multiple values and is entered into multiple cells. Hence ‘multi’ in the name. Let’s look at an example, say we… Read more »
How to enter same Formula in multiple cells?
As you probably know, there are a TON of ways to copy or fill formulas. I am going to show you the technique that works best when you already have… Read more »
Fill All Blank Cells in an Excel Range With a Desired Value
Here’s a nifty little trick I use every day while working in Excel. It’s a two part trick. Part one will be selecting all the blank cells in a range… Read more »
Formula to get the start or end of the week date
On many occasions and in many dashboards, time will be the main factor of your analysis and reports. As far as time goes, you can do a Yearly, Quarterly, Monthly,… Read more »
Creating PowerView Dashboards from the PowerPivot Gallery Data Sources
The real benefit of hosting your PowerPivot workbooks within a PowerPivot Gallery is that people can then report off the data source as if it were a mini data warehouse… Read more »
IFERROR Puts an End to Messy Workarounds
It can be used as a ‘wrapper’ to hide many different errors; #DIV/0, #NAME?, #NULL, #NUM, #REF, #VALUE, and one of the most common being VLOOKUP’s #N/A error. In this… Read more »
Case-sensitive/insensitive Sort in Excel (bug or a feature)
This post will talk about the way that Excel sorts data and the Case Sensitive sorting it offers. If we look at this data And sort it in ascending order… Read more »
Top 40 of the best Excel shortcuts you need to know
Almost everyone uses Excel in some form or fashion in the modern workforce, but many of us may be wasting a little too much time trying to format those pesky… Read more »
Add Scroll bar to an Excel Chart
Scroll bars or Sliders on an Excel Chart are a great addition if you are building interactive Excel Reports and Dashboards. This guide will walk you through the steps in… Read more »