business.tutsplus.com: Spreadsheets get a bad rap for being hard to read. Making spreadsheets user friendly is all about adding a bit of formatting—taking basic steps like adding column headers, adjusting your alignment, and using the right color in your spreadsheets.
1 comment:
I love conditional formatting. It's a weird thing to be a fan of, but this has saved me so many hours of communication problems. The number of spreadsheets of mine that have a progress column that changes colours when pope write either "not started" "initial" and "final" in to the column is very very high; it allows people to see the progress of other production team members without having to send email after email all saying "Hey! Just wondering what the progress is on ______" and having a time wasting conversation about it afterwards. I have never done it in Excel, only in Google Sheets where it is quite simple and easy to use, though limited in it's powers, so this article was particularly helpful to me in terms of how to use this wonderful tool on a different platform. I will definitely be using this information in some of my future projects.
Post a Comment