Excel Unplugged

Monthly Archives: February 2015

Learn a foreign language with Excel

Surprisingly, this is not a post about the Translate feature in Excel. Rather we will take an in depth look into Cell Format and a great feature of Excel that allows ...

Scroll trouble in Excel (scrolling beyond your data)
February 17, 2015

Sometimes in Excel, we are just an innocent bystander when enthusiasm gets the better of people and they start drifting around Excel inserting data in places where ...

Get data from Folder in Power Query

Following a wide demand, I also wrote a post about getting data from Excel files in a folder. You can read it here. It seems that lately Excel users can be separated ...

My Excel Shortcut of the Year

In my work as a Trainer and also as a Data Scientist (I love that term), Shortcuts in Excel are a vital part of doing things efficiently. This shortcut helps you ...

"