
What is so good about VBA?
Here is why I think VBA is so great, but first let’s try and define VBA. A tightly integrated application automation system that allows professionals from non software development disciplines… Read more »
Here is why I think VBA is so great, but first let’s try and define VBA. A tightly integrated application automation system that allows professionals from non software development disciplines… Read more »
Word Documents are everywhere – proposals, tenders, notes, technical papers. In many cases there are more than one authors and more than five reviewers. Just in case you get a… Read more »
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 »