Excel Unplugged

Monthly Archives: November 2014

What Excel should learn from Word
November 25, 2014

I’m only guessing, but I think that anybody who wants to use Excel at an above average level, will have to learn at least a few keyboard shortcuts to get ...

Give Excel it’s voice (The Speak Cells Command)
November 18, 2014

Very often, we will conduct a more or less pointless discusions with our Excel :), but not many people are aware that Excel in fact can talk. It can do so from Excel ...

Last word in a string with an Array formula

As promised in the Pragmatism vs. Purity in Excel article from last week, this week’s article will explain the following array formula ArrayFromula   ...

Pragmatism vs. purity in Excel

One of the greatest things about Excel is that with its endless array of tools and commands it almost always offers multiple ways of achieving a certain goal. ...

"