Excel Roundup 20151123

In this week’s roundup, get file creation dates, plan for Thanksgiving, create icons with number formatting, and much more.

Excel Roundup http://blog.contextures.com/

1. Get File Dates

Last week was the 15th anniversary of the Contextures website, and I wanted to know how old my earliest sample files were. You can download my latest sample file, which has a macro that lists all the files in a folder, with all its properties, including the Content Created date.

2. Power Query

Don’t miss it! The last Power Query course for 2015 starts tomorrow — November 24th. The live online course is led by experts Ken Puls and Miguel Escobar. Click here for registration details.

And if you can’t make it to the course (it might be full by now), their new book, M is for (Data) Monkey, is available now. The print version comes out next month (pre-order on Amazon).

3. Create Icons With Custom Formats

Jordan Goldmeier shows how to use custom number formatting to create icons on a dashboard. This won’t slow down your workbook, like conditional formatting will, but it has fewer formatting options.

4. Plan for Thanksgiving

The Internet is all excited about the spreadsheet that this guy’s mom uses to plan for Thanksgiving dinner. If you’d rather use Excel, there’s a Holiday Dinner Planner on my website. It’s not as colourful, but it does have a Gantt chart!

5. Office 2016 Review

Zack Barresse has been using Office 2016 for a while now, and posted his review of the new features. Some things, including the pivot table changes, are Good, and he is undecided about several other new features, like One-click forecasting. Zack would be pleased to know that I turned his blog post into an Excel table, so I could filter his scores. ;-)

And if you’d like to hear more from Zack, he was interviewed on Jon Michaloudis’ Excel podcast last week.

6. Excel Tips on Twitter

If you like quick Excel tips, Kevin Lehrbass recommends that you follow a few Excel people on Twitter. He especially enjoys the tips from Bill Jelen and Tom Urtis, and shares a few examples of their helpful tweets.

7. Excel Humour

Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here’s one of my favourite tweets from this week’s collection.

twitter20151120b

Get Weekly Excel News By Email

To get Excel news and tips by email, add your name for the Contextures Excel newsletter.

________________

Excel Roundup http://blog.contextures.com/

 

You may also like...

Leave a Reply

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