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.

Contextures Posts

Here’s what I posted last week, on my Contextures site and blogs:

Grouping: Instead of seeing dates grouped by year and month in a filter drop down, you can change a setting to ungroup them. I understand the benefits of that automatic grouping, but I’d rather see the individual dates most times.

Pivot Settings: 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.

I Hear Voices: If you accidentally turn on the Voice Narrator in Excel, here’s how to turn it off, so Excel stops talking to you.

  1. Tweets: 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:

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

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

Pivot Tables: Doug Glancy shares his technique and VBA code for using conditional formatting on a pivot table.

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

Risks: Simon Murphy asks the interesting question, “Has EuroSpRIG increased spreadsheet risk?”

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

AndyErrBar4

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.

__________________________________

0 thoughts on “Excel Roundup 20131216”

Leave a Reply

Your email address will not be published.

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