Tag: <span>Spreadsheets</span>

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.

How to Enter Cleaner Data AND Automate the Entire Analysis and Visualization Process

Feb 25th, 2020 / Data Analysis, Data Visualization

This is a brand new bonus module for current and past students in my data analysis course, Simple Spreadsheets: From Spreadsheet Stress to Superstardom with Microsoft Excel. In this post, you’ll learn how with a little upfront planning, you can automate the rest of the analysis and visualization process. Here’s how.

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?

How to Add Dotted Lines to Line Graphs in Microsoft Excel

Nov 12th, 2019 / Data Visualization

What to do if you’re missing chronological data? Learn how to represent the missing data by turning solid lines into dotted lines.

How to Explore Your Spreadsheets with Miniature At-a-Glance Graphs

May 1st, 2018 / Dashboards, Data Analysis, Data Visualization

I worked in several university research centers before transitioning to applied settings and learned data analysis and data visualization as two distinct phases. But nowadays I mix and mingle them a lot. My favorite exploratory visualization techniques are sparklines and data bars. I use these techniques daily, and I want to share them with you, too.

Simple Spreadsheets: From Spreadsheet Stress to Superstardom in 12 Weeks

Apr 24th, 2018 / Data Analysis

This is one of the happiest days of my career. I’ve been running my own data design company for four years. And for four years, I’ve been itching to build online courses which I haven’t been able to do… until now! I’m launching Simple Spreadsheets: From Spreadsheet Stress to Superstardom in 12 Weeks, a course all about data analysis time-savers

Blog