Excel Roundup 20150209
Microsoft announced that Office for Windows 10 Preview is now available for download, and they’re working on Office 2016
You see the preview in this video, and the Excel demo starts around the 1:00 mark.
Or watch on YouTube: First Look at Office for Windows 10
Here’s what I posted recently:
- Save space with compact buttons and captions for macros or hyperlinks
- Create a combo column-line pivot chart in Excel 2013
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Gábor Madács uses an area chart, with 4 bands, to show daily traffic in the subway system.
- Learn a very useful keyboard navigation shortcut from Gašper Kamenšek – I didn’t know that one, and it will come in handy!
- Chandoo explains how to set up custom number formats with a wide array of colours.
- When you import data with Power Query, the dates might not look right on the worksheet. Ken Puls shows how to set the date formats.
- Dick Kusleika created a macro to toggle a pivot field between Sum and Count, and assigned a shortcut key to run the macro.
- Michael Ashton built a User Defined Function because Excel’s PRICE and MDURATION functions return errors for negative bond yields.
- To clean up data, Steve Chase uses the TRIM function, and he likes to call the Fill Handle the “hockey puck”. That’s a new one!
- Tanner Bell is still working on his Fantasy Baseball workbook, and this week he is calculating custom rankings.
- Jerome Cukier, data visualization designer at Facebook, looks at some of the new problems with dashboards.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
- Excel MVP, Bernard Liengme, has just published his latest book, Modelling Physics with Microsoft Excel
- “This book demonstrates some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics…This book shows Excel in action in various areas within physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA.”
- Amsterdam Excel Summit, April 13-15, 2015. Mark your calendar for April 13-15, so you can attend this amazing Excel event. Last year’s summit was an outstanding success, and registration will open soon, for this year’s event. Registration is now open, and you can click here to register.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please let me know. Thanks!
Links to Recent Excel Books on Amazon.com