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:

My old mouse started acting up, so I had to get a new one. Which do you prefer, wireless mouse or wired? The wired one has the advantage of never needing batteries, but that long tail can get in the road sometimes!

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.

And here is a link to the January 3rd edition: Excel Tweets collection. There’s usually a tweet or two that sounds like something I’d comment on! How about you?

Other Excel Articles

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

Excel Errors: 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.

Sports: If you like soccer (football), you might enjoy Jough Donakowski’s article on keeping sports statistics in a spreadsheet.

Charts: The always informative and entertaining Science Goddess finds quick ways to improve the appearance of Excel charts. In another post, she tackles line charts.

Calendar: 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

Tables: For more details on Excel’s named tables, you can read the Customizable Spreadsheet Table Styles patent application that was published last week.

Power Query: 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.

__________________________________

0 thoughts on “Excel Roundup 20140106”

  1. 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 Tara Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.