Excel Roundup 20140106

Happy New Year! I hope you had time to relax over the holidays, and didn’t have to endure too much cold weather and snow.

It’s a little late for a holiday poem, but I enjoyed this one on the Code? Boom. blog. – I’m an Excelebrity, get me out of here. The poem is a variation on Night Before Christmas, and ends with:

And I heard them exclaim, as they walked out of sight—
“Excel’s not that bad”   “Yeah,  I think it’s alright.

There are also some downloadable files, with Excel activities for grade school students.

codeboom_excelebrity

Contextures Posts

I took some time off blogging, to enjoy the holidays, and just made a few posts since the last roundup:

  1. My old mouse started acting up, so I had to get a new one. Which do you prefer, wireless mouse or wired?
  2. For a humorous peek at what other people are saying about Excel, read the December 27th collection of Excel tweets, on my Excel Theatre blog.
  3. And here is a link to the January 3rd edition: Excel Tweets collection

Other Excel Articles

Here are a few of the Excel articles that I read last week, that you might find useful:

  1. Good news – the Daily Dose of Excel blog is up and running again, after some server problems. Dick Kusleika takes a look at error handling via an error class.
  2. If you like soccer (football), you might enjoy Jough Donakowski’s article on keeping sports statistics in a spreadsheet.
  3. The always informative and entertaining Science Goddess finds quick ways to improve the appearance of Excel charts. In another post, she tackles line charts.
  4. If you’re planning your activities for 2014, you can download a free Excel calendar template from Chandoo’s website. You can see a screen shot of the calendar below
  5. For more details on Excel’s named tables, you can read the Customizable Spreadsheet Table Styles patent application that was published last week.
  6. Chris Webb shows how to use local groups in Power Query, with an example of grouping by time ranges.

chandoocalendar2014

What Did You Read?

If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.

Please include a brief description, and a link to the article.

__________________________________

You may also like...

3 Responses

  1. Tara says:

    Thanks for sharing my links on the chart redesigns in Excel!

  2. deepak phadtare says:

    i have question regarding sum product condition
    A B C D E F G
    1 2.2 2.2 2.2 0.61 0.61 0.61

    2 Ach 2012 Tgt 2013 Ach 2013 Ach 2012 Tgt 2013 Ach 2013
    3 10 62 30 29 65 4
    4 23 45 30 21 54 67
    I AM LOOKING RESULT IN CELL G3 FOR SUMPRODUCT OF A1:F1 WITH A3 & D3 BUT I COULDNT GET IT SUMPRODUCT OF ONE CONTINUOUS ROW WITH SELECTED CELLS SO PLEASE GUIDE.

Leave a Reply to deepak phadtare Cancel reply

Your email address will not be published. Required fields are marked *