• Twitter
  • Google+
  • Pinterest
  • RSS
Excel Unplugged

Monthly Archives: November 2016

Excel vs. Excel 365
November 29, 2016

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
November 8, 2016

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
November 1, 2016

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 ...