Excel Unplugged

Tag Archives: Excel Shortcuts

Excel Shortcut of the year

On February 3rd this year I published a post titled My Excel Shortcut of the Year. Now, only two months later, I’m passing the flattering title on to another ...

Add data to your Chart (the easy way)

(as simple as Copy and Paste) This is our sample data. First we select the data for all days but only for the first three months and press Alt + F1. That is the best ...

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

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

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

    Last day of previous month formula in Excel

    On many occasions we would like to somehow get the dates belonging to the last day of current, previous or any other month, the first day of this month or any day of ...

    Boost your Excel efficiency with one key – F5 (Go To and Go To Special)

    Very often you will find yourself in a position where you wish to either move efficiently through the workbook or you wish to select only cells containing certain ...

    Who knew (Just another day with Excel)?

    One day as I was giving a basic(!!!!) Excel training, my mind got sort of blown. We were discussing the use of A1:A100 in the Name Box for the selection of a range ...

    Increase your efficiency in Excel with these mouse based Excel shortcuts

    These days when talking about efficiency in any Office application, particularly in Excel, keyboard shortcuts are a must. But since we can’t really be ...