Getting Started with Google Sheets: Conversation with Ben L. Collins

Dec 8th, 2020 / Data Analysis
I recently had the chance to talk with my longtime friend, Ben L. Collins, who is THE Google Sheets instructor. Ben joined as a special guest at Office Hours (special live sessions for full course students where we share ideas and give feedback on each other’s projects). Ben shared about his consulting and training work with Sheets, and his personal take on Sheets – favorite features, surprising features, and so on. The personal insights and reflections you can’t learn just by googling something.
More »

A Real-Life Excel Test from a Job Interview: Can You Pass??

Feb 18th, 2020 / Data Analysis
Ten year ago, I was interviewing for an analyst position and I’d sat in the interviewer’s office going on and on about all my great spreadsheet skills. And then the interviewer was like, “Prove it. Come with me.” I was then led to an office with a computer that had an Excel test just waiting for me. My heart just about stopped– what did I say I knew how to do again?? Spoiler alert: I got the job but fast forward ten years later- can I still pass that Excel test today?
More »

Taking Federal Grant Data from Dull to Dynamite with Custom Visualizations

If you’ve ever worked with publicly available government data, you probably know the headache and eye strain that comes with trying to make sense of a huge spreadsheet. Guest author Megan Johanson explains how you can easily create a customized chart that will make your federal grant data conversations a breeze. Megan Johanson is the Data Analytics and Insights Manager at the Educational Service Center of Central Ohio. She’s also a student in Depict Data Studio’s hybrid synchronous/asynchronous training program.
More »

Visualizing Your Annual Survey Results: Four Makeovers That Didn’t Work, and the Fifth That Did

Virtually every organization conducts satisfaction surveys of one kind or another. I’m going to show you the before version followed by five makeovers. The first makeover didn’t work. The second makeover didn’t work. The third makeover didn’t work. The fourth makeover didn’t work. Just as I was about to give up, I found a winning design with my fifth attempt!
More »