Excel Roundup 20131216

It’s almost Christmas, so here’s an Excel-themed version of Santa Baby for your entertainment, sung by Santa Monica Excel Consultant Szilvia Juhasz.

Or watch on YouTube: Santa Baby – Excel

Contextures Posts

Here’s what I posted last week:

  1. Instead of seeing dates grouped by year and month in a filter drop down, you can change a setting to ungroup them.
  2. When you add new items to a pivot table, change a setting to make them appear in alphabetical order, and show them even if a filter is applied.
  3. If you accidentally turn on the Voice Narrator in Excel, here’s how to turn it off, so Excel stops talking to you.
  4. Finally, for a humorous peek at what other people are saying about Excel, read this week’s collection of Excel tweets, on my Excel Theatre blog.

Other Excel Articles

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

  1. Did you learn any cool Excel tricks this year? Chandoo shares his favourite new trick, and read the comments to see what other people have learned.
  2. I’ve used Excel for all kinds of things, including keeping track of chapters when writing a non-fiction book. Lisa Alber explains how she uses Excel to connect the chapters in her novel.
  3. Doug Glancy shares his technique and VBA code for using conditional formatting on a pivot table.
  4. If you’re creating reports in Excel, Charley Kyd shows how the SUMIFS, INDEX and MATCH functions can help you pull the data for the report.
  5. Simon Murphy asks the interesting question, “Has EuroSpRIG increased spreadsheet risk?”
  6. Jon Peltier gives step by step instructions for building a multiple width overlapping column chart. You can see the final result in the screen shot below.


What Excel News 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.