Excel Roundup 20140203
Here’s a picture from her blog post, and you can download the sample file from her site.
Here’s what I posted last week:
- Have you shared files online with the Excel Web App? I found some pros and cons while using it for project tracking.
- In addition to sorting a pivot table’s values from top to bottom, you can also sort the values or grand totals, from left to right.
- If you import data into Excel, the dates might not format or sort correctly, and you can take a couple of steps to fix them.
- 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:
- Even if you don’t like statistics, or it makes your head hurt, take a look at Mike Alexander’s article on identifying outliers in your Excel data. You’ll feel smarter by the end of the article!
- If you’d like feedback on a chart or other data visualization that you’re working on, check out the new forum – HelpMeViz. Even if you don’t submit your own work, you’ll benefit from reading the comments there.
- If you need to compile data from several Excel files into one, you can use the sample code that Winston Snyder shared on his Data Prose blog.
- There was traffic chaos in some parts of the southeastern USA last week, when snow and ice coated the roads. To help out, volunteers set up a spreadsheet, to organize a rescue of stranded motorists.
- How do you like to learn new computer topics? Video? Books? Dive right in? Videos put Simon to sleep, and he wonders if you feel the same.
New Excel Books
What’s new on the Excel bookshelves at Amazon?
PowerPivot Alchemy: Patterns and Techniques for Excel, by Bill Jelen and Rob Collie.
295 pages, Feb. 1, 2014
“This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.”
Microsoft Excel 2013: Data Analysis and Business Modeling, by Wayne Winston
”Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.”
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.