Spreadsheet Roundup 20190917

It’s only a month until we celebrate Spreadsheet Day 2019, on October 17th!  This year will be extra special – it’s the 40th anniversary of the VisiCalc launch. Were you using VisiCalc when it first came out, in 1979?

While we wait for Spreadsheet Day, here is a roundup of selected spreadsheet articles that I’ve read recently. You’ll find interesting tips, useful sample files, and new ideas for your own spreadsheets.

For Excel tips and tutorials, please visit my Contextures website.

Functions

  • This paper is definitely not for most Excel users, but you might find it interesting. It’s from 2003, and the authors wanted Microsoft to add worksheet-based User Defined Functions in Excel. See the screen shots on pages 4 and 7, for examples.
  • This article has spreadsheet tips for journalists, but it’s an interesting read for people in other professions too. The formula for % difference is correct, but the explanation is confusing

Spreadsheet History

 

Interesting Projects

)___________________

Spreadsheet Roundup 20190917

Spreadsheet Roundup 20190917

___________________

You may also like...

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.