Excel Unplugged

Monthly Archives: November 2016

Excel vs. Excel 365

Whatever side of the Cloud vs. On Premise debate you take, it’s a fact that at this point there are two Excel 2016 versions out there. First there’s ...

Search a Range for the closest value to a chosen number

How to find a closest value to a chosen number within an Excel range? Let’s do it through a simple example! We start with a range of values in Excel (A1:G20). ...

Dynamic Power Query

Another example how to utilize dynamic capabilities of Power Query comes from our reader. The following post was written as the reply to a great question Dane asked ...