Excel Roundup 20140609
What’s the oldest version of Excel, or other spreadsheet program, that you have lying around your office? In my office, there’s an old Multiplan disc and manual, and before that, I probably used a rock and chisel.
Gough Lui took a trip back in time, and installed Excel for Windows Version 3.0 – nine floppies, all 5.25″ in DD 360kB format. There are lots of screen shots, which might make you nostalgic for the good old days.
Here’s what I posted last week:
- I presented a couple of Excel sessions at a Microsoft meeting, and you can see a couple of pictures, and of of the tips that I shared.
- See how to turn off the GetPivotData formulas that create an absolute reference when you link to a pivot table.
- Use shortcuts to quickly create a chart on a new sheet, or embedded on the active sheet.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read this week’s collection of Excel tweets, on my Excel Theatre blog.
And be sure to come back here tomorrow – I’m announcing an Excel giveaway, which will have a very short deadline!
Other Excel Articles
Here are a few of the Excel articles that I read last week, that you might find useful:
- Ron de Bruin and Norman Harker have released an online Excel Function Bible, with examples for all 468 functions.
- On the Cogent Legal blog, Michael Kelleher shares Excel tips for litigators, who might need to present numbers and calculations at a trial.
- Colin Legg answers 3 common questions about changing the number signs in a list of numbers.
- James Longden, at BPM Global, shared his World Cup Monte Carlo Simulator, that you can download, to predict how well your team will do.
- Mike Alexander jazzed up a few charts with icons, to create infographics.
- Winston Snyder shares his code for normalizing data that is in crosstab format, to make it usable in pivot tables.
- Cole Nussbaumer, on the Storytelling With Data blog, shows four alternatives to pie charts, and you can download his sample file.
Here are some upcoming events, courses and recently published books, related to Excel.
- Using Excel with Chicago City Data — Ross Loforte (Microsoft Technology Center Architect) and William Stanley (Principal Solution Specialist for Microsoft) discuss how to use Excel against City Data Sets to visualize, analyze, and share those insights. Wed. June 11, 2014, 6:00 PM
- The European Spreadsheet Risks Interest Group – EuSpRIG –has announced the preliminary program for Eursprig 2014. This event will be held in Delft (Netherlands) on July 3, 2014. Read more about it on Patrick O’Beirne’s blog.
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
Links to Recent Excel Books on Amazon.com