Spreadsheet Roundup 2021-02-17

Here is a Winter 2021 roundup of spreadsheet articles that I’ve read recently. You’ll find interesting tips, and new ideas for your own spreadsheets.

For Excel tips and tutorials, visit my Contextures website.

Data and Dashboards

Clean Your Data — The worst part of working with data is cleaning it up. To help save time, use these data cleanup techniques, from the Investintech blog.

Dashboard Tips — There are lots of great tips and examples in this Dashboard Design Essentials article by Spencer Baucke

In the News

Personal Finance – See how couples use spreadsheets to manage their cash, and try to spot potential problems.

Online Spreadsheets – Recent updates to Google Sheets and the online version of Excel should make your work a bit easier.

Spreadsheet Problems – Edward Hearn says companies need to take their spreadsheets more seriously, to avoid problems. Fancy technical solutions won’t get rid of bad data.

Functions

XLOOKUP: Have you tried Excel’s new XLOOKUP function yet? Chandoo has 13 examples that show you how XLOOKUP works.

Spill Functions: Thanks to Dermot Balson, who sent me his Excel workbook with examples for all the new functions (dynamic arrays) in Excel for Office 365. To get the sample file, go to the Excel Spill Functions page on my Contextures site.

Spreadsheet Resources

Spreadsheets – The Essential Spreadsheets guide, on the University of York site, shows how to do things in Excel and Google Sheets, with written steps, videos and sample files. It’s interesting to see the comparisons!

Excel Tips — Watch Excelling in Excel, a mini course from the University of Edinburgh. There 3 videos – data organization, tips and tricks, data visualisation

Spreadsheet Tweets

Finally, here are a few recent spreadsheet tweets, for a bit of humour.

________________________________________________

________________________________________________

________________________________________________

________________________________________________

________________________________________________

Spreadsheet Roundup 2021-02-17

Spreadsheet Roundup 2021-02-17

Spreadsheet Roundup 2021-02-17

_______________________________________________

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.