image of a spreadsheet done as a blur with a quote about the beauty of spreadsheets

Playing with Excel

image of a spreadsheet done as a blur with a quote about the beauty of spreadsheetsI think one of my favorite things about this week has been the use of Concatenate in excel. And split.

My boss loaned me to a couple professors who needed registration to be simplified. Hello spreadsheets and Google Forms! We built the form before I knew what level of information they expected to use. Oops. Still it was a nice start.

Some of the information was located on a visually pleasing (to the maker) spreadsheet that required some fancy Queery formulas. I am just glad Google sheets can talk to each other across documents. The “visually pleasing layout” is usually a synonym for “useless”.

Once that mess was sorted I had to combine and split names into about twenty formats. W00T!

So…it sounds bad in writing but I secretly loved this week.

TwitterFacebookGoogle+LinkedInPinterestTumblrShare

About the author: Rurik

Known both as Ru (or as the title suggests, Ru Ru the Ruiner), Rurik studies ways games can designed to improve society, especially in the realm of education.