At Macstock X in Crystal Lake, Illinois, Allison took the stage to teach a 90-minute workshop titled “How the Cool Kids Use Spreadsheets.” Since people have different preferences in spreadsheet tools, she taught the concepts in Microsoft Excel, Apple Numbers, and Google Sheets. She taught how to fill down and right not just functions, but how many items like months, days of the week, quarters, and even hand-crafted lists can fill sequentially. Next, she taught the important distinction between relative and absolute cell references. She showed two of her favorite but tricky concepts: CONCATENATE to combine cells, and VLOOKUP to search for data in an array. The real crowd-pleaser was when she showed how she was able to analyze the entire dataset of the name of every baby born from 1880 to 2026 from the US Social Security system using a pivot table. She actually found the end of Excel because this dataset was so huge.<\/p>\n
If you’d like to follow along using her example files, here are a few links to help you. The first is a link to a PDF of the very tight and crisp notes she followed while conducting the workshop. You can download the demo files for Excel and Numbers, and we also have a link to a Google Sheet that you can’t change, but you can copy to play with on your own. And if you really want to go crazy, you can download the baby name file with the pivot table included on its own tab.<\/p>\n
File Downloads:<\/strong><\/p>\n