Excel Roundup 20150202
Happy Groundhog Day! Please feel free to read this roundup over and over again.
Poynter posted a couple of videos from the early days of Lotus 1-2-3, which was released 32 years ago, on Jan. 26, 1983. In this video, you can see how exciting a workday becomes, when new spreadsheet software is installed. Does Excel ever make you feel like dancing?
Here’s what I posted recently:
- Have some football fun in Excel – find functions and compare close games
- Pros and cons of saving the Source Data with a Pivot Table file
- 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.
- Gašper Kamenšek shows how you can set specific days as the weekend, with the WORKDAY.INTL function.
- Chandoo has a light bulb moment, while setting up a cost benefit analysis.
- Fowmy built a pop-up calendar add-in for Excel. Right-click to insert a date, and select a date format.
- Jon Peltier shows how to create several types of floating bar charts.
- Inspired by the blizzard that hit the north-east USA last week, the BBC used dogs in a chart to show expected snowfall levels.
- Jordan Goldmeier uses the Color Brewer tools to create new color palettes for his workbooks.
- Microsoft announced that Word, Excel and PowerPoint are now available for Android tablets.
- Ken Puls created a VLOOKUP function in Power Query, to find approximate matches.
- Mike Alexander describes how Microsoft’s free Fuzzy Lookup add-in works.
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
PASS BA Marathon
- Feb. 3, 2015 — Sign up now, for tomorrow’s free online preview of the upcoming Business Analytics Conference. There will be 6 live webinars, including “Productivity Revolution in Excel”, led by Chandoo (Purna Duggirala) and Avi Singh.
- 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