Today, we're going to talk about how to freeze rows and columns so that they are visible no matter how big your spreadsheet is, or how far you scroll. Also! Don't miss out on my second webinar with the Working Families Party and ResistHere.
Post Pi Day Pie Chart “Round” up
Maybe you're thinking I should finally get a-round (hehe) to making my point about pie charts. I don't blame you. I think pie charts are a good tool for changemakers (despite all of the banter and vitriol!) Please don't turn me into mincemeat!
How to build a “table” in Google Sheets
Back when The Data Are Alright was just a prototype, I made a blog post about one of my favorite Excel tricks, the "Format as Table" feature but the instructions were only for Excel users. Now, I'm eating my words and serving up a second helping, this time in Google Sheets.
Turn it upside down!
However you do your work to turn our political system upside down, I hope you can make good use of this post, whether it's inspiration from the Purim story or the technical tips about rotating your data that most resonates with you. I've been doing movement work for long enough to know that we desperately need both!
One slice of data… a la mode!
I talk a lot about making meaning out of data-- that's what I want to support changemakers to be able to do! Looking more closely at these student write-up records can help guide a strategy toward pursuing restorative justice and student growth and accountability. My goal was to leap from 650 entries in the restorative justice discipline log to identifying trends and outliers, and using that information to recommend actions.
3 easy Excel wins for organizers
Most of us learned organizing the slow way. But it doesn't have to be that way with learning spreadsheets! Here are 3 easy tricks that will make your work MUCH easier, so you can get back to changemaking!
“I want a sign-in sheet that *does the work for me!*”
How can we make better sign-in sheets that minimize the work for organizers and maximize our capacity to follow up?
Let me Google that for you
Well, with tech questions, it's not what you ask, it's how you ask it.
It's the same with asking Google, Jeeves, (or me, The Spreadsheet Whisperer), when you need help with Excel. Here are some tried and true tips for asking good questions, so that you can get better, quicker answers.
Law and Order CSV
CSV? XLS? Saving your document in Excel is like getting to the bottom of a mystery, but without very many clues. Never fear, I've got a handy table AND some tried and true tips to share about the different types of spreadsheet files.
Let’s table it
Today I want to introduce you to a simple tool that will make organizing data in Excel easier AND prettier. It's called "Format as Table." I think you'll love it (or your money back!)