What should you do if the built in Excel Table Styles don't match your colors or preferences? Create a Custom Table Style, of course! Here's a post that walks you through the "how" and "why" to customize your table designs. Here's a hint- think about who else uses your spreadsheets besides just YOU! Come for the puns and stay for the data 🙂
far afield
Reflecting on what database managing and farming have to do with each other. Come for the puns, stay for the data tips!
5 days in 5 minutes
How to filter a list based on another list, featuring one of my favorite data tools... the VLOOKUP! Plus, some examples for how this tool can be used for political organizing, and the "pull rabbit out of the hat" meme makes another appearance.
now you see me, now you don’t
Have you ever played spreadsheet hide and seek with hidden columns, filter views, and more? Or have you ever needed to temporarily hide or restrict access to certain information? If yes, then this post is for you (plus, cute bunny gifs!)
(our data are) wild but not wonderful
What do you do if you're outgrowing a contact list in Google Sheets? How can you store info for a political campaign before you go live with a database? Last but not least, how to link Google Forms to existing Google Spreadsheets. Onward!
Impasta Syndrome
5 concrete ways to unravel Impostor Syndrome (praise the planning crew for the Salesforce.Org Open Source Community Sprints!), plus some cute cartoons.
my daily dilly-dally, or, how activism makes me a better database admin
My job is to be a database administrator... and so much more! When users get frustrated and angry with me, I rely on lessons I've learned from my activism. Read on for stories, suggestions, questions, answers, and more questions!
strawberry shortcut cake
I wanted to share a set of tips that could supercharge ANY spreadsheet maker's work. So what could be better than SHORTCUTS? For repetitive functions, selecting cells, and navigating around a spreadsheet, keyboard shortcuts will make a heck of a difference. Here are 5 Excel shortcuts you shouldn't live without!
digital self care vol iii
*cue soundtrack from a pharmaceutical commercial* Has this ever happened to you? Devices blinking and buzzing. Email inundation. Hard drive sounding alarm bells. *Groan* *Sigh* It doesn't have to be this way! Try our silver pill. Side effects will be extreme, but at least you will achieve digital serenity. Call today! This post features tried and true tips to help you move from information overload to digital serenity. Plus, original art by @shebanimal!
default, not your fault!
Today I wanted to focus on time-saving skills and tricks that will supercharge your spreadsheet powers and save you time. Understanding and modifying Excel's "default settings" can get you well on your way to a spreadsheet that works for you, instead of the other way around.
