Spreadsheet Roundup 20150506

Here is a roundup of selected spreadsheet articles that I’ve read in the past month. You’ll find interesting tips, useful sample files, and new ideas for your own spreadsheets.

For a weekly Excel Roundup, please visit my Contextures blog.

If you have suggestions for next month’s spreadsheet roundup, please let me know. Thanks!

Spreadsheet Roundup -- May 2015  http://spreadsheet-day.com/blog/

1. Spreadsheets in Education

In the Spreadsheets in Education journal, you can read a variety of interesting articles, including “Divination: Using Excel to explore Ethnomathematics” (Vol. 8, Issue 1). Some of the articles have workbooks that you can download.

Also, Alice Keeler, from the Teacher Tech blog, wants math teachers to start using spreadsheets in the classroom.

For teachers who are using Google Sheets, Corey Aylen lists a few helpful add-ons for education.

2. Project Tracking

Use Excel to track simple project tasks. Enter a task description, the estimated and actual times, date completed, and other info.

3. Google Sheets Chart Tricks

In a short video, Sara Silverstein shows how to create maps, add annotations, and show estimates, in Google Sheets charts.

Those features aren’t available in Excel charts, but James Hewitt lists 7 reasons to like Excel over Google Sheets.

4. Clustered Column Chart Alternatives

If you’d like a change from clustered column charts, you’ll be inspired by 6 new ideas from Ann K. Emery. She helped a colleague overhaul a chart, and wants to know which alternative you like the best.

5. Using Goal Seek

Goal Seek is one of the What If Analysis tools in Excel, and Winston Snyder shows how to use Goal Seek, manually, or with a macro. See how much you would have to adjust a number, to reach a target amount.

6. Function Tips

On the PC World blog, JD Sartain shared a list of 15 Excel function tips. There are 3 categories — entering formulas, formulas for common tasks, and bonus tips.

7. Understanding Array Formulas

Array formulas can be confusing and intimidating, if you don’t use them often, or haven’t used them before. On the Model Off blog, Dan Mayoh explains what arrays are, and how to use them in financial models.

8. Microsoft MVP Virtual Conference

The first ever (and free) Microsoft Americas MVP Virtual Conference will be held online, May 14-15, 2015, with sessions from 8 AM to 6 PM (Pacific Time), both days. If you don’t have time to attend the full online conference, you can see the full agenda, to find sessions you’re most interested in.

9. OpenVis Presentation Videos

The videos from the recent OpenVis conference are available online, and the interactive Table of Contents makes it easy to access them, and find topics of interest. Click on a topic or word at the top, and see a marker, where that occurs in the video.

Spreadsheet Roundup -- May 2015  http://spreadsheet-day.com/blog/

______________

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

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