What do passwords and canned air have in common? Read this blog post to find out!
smol, medium, large
Not knowing if a given scenario is easy or hard, or if there's an easier work-around to avoid a super-hard thing, feeds the overwhelm/impostor machine. It's so clarifying and liberating to just know what you're getting yourself into. PLUS, baby animal memes!
breadcrumbs trail / matzo meal
I think it's a best practice to design ALL spreadsheets as if they will be manipulated by other people, which means leaving a strong "breadcrumbs trail" of your assumptions, formulas, variables, data sources, and more. In my case, it's a matzo meal trail until tomorrow evening when Passover ends and I will devour pizza with all my might!
shape shifter
From a downloaded file with weird fonts and titles, wacky colors, no wrapped text, superwide columns, and repeating header rows, I was able to create a useable, sortable, shareable, printable, filterable, not-make-you-want-to-throw-your-computer-out-the-window spreadsheet. And you know what the best part is? You can too!
borders / no borders
How do you apply borders and formatting to a spreadsheet, and then copy them somewhere else? When should you use borders? Are geopolitical borders wrong? Yes, we tackle all this and MORE! Plus, .GIFs!
iterative installments
Solving database problems is kind of like cooking without a recipe! In this post ... how to send donation notifications (plus installment info from recurring donations) plus a cute koala meme!
dashboard dr-UMMMM-er
Facing a perfect storm of issues leading to dashboard problems, I used the "5 why" and "Positive Changemaker Mindsets" approach to solve the problem (and you can too!)
i am not a crocheter
How learning a new crafting medium offers insights into resilient spreadsheet skill building. Plus, puns, puns, and more puns.
resource roundup + cool job alert
What do a camel, a mermaid, and an awesome job opportunity have in common? You'll have to read this post to find out, chock full of tips, gifs, puns and more!
validation rules!
Ahh, nothing like a good pep talk to make you feel validated. When I can't cheer you on, try data validation tools to add "dropdown menus" inside of your spreadsheets. Google Sheets and Excel users will both find something of value here. Read more for useful tips and tutorial videos.
