Tag: Microsoft Excel

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?

Four Stats Formulas that Every Spreadsheet User Should Know About

Dec 10th, 2019 / Data Analysis

Summarizing datasets for use in your data visualizations doesn’t have to be time consuming and frustrating. This article will outline four statistical formulas that every spreadsheet user should know.

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.

Condensing Many Data Elements into an At-a-Glance Directory Using Symbols, Reference Codes and Colors

Oct 1st, 2019 / Dashboards

Guest author Anna Williams was tasked with developing a national directory of organizations working on sexual and reproductive health for one of the United Nations’ country offices. In this blog post, Anna gives you a behind-the-scenes peek at that searchable Excel database.

How to Aggregate Information Across Sites

Aug 20th, 2019 / Data Visualization

When you’re working in the weeds of a spreadsheet, it can be hard to step back and find the bigger picture. Here’s the approach I used in a recent training with a government client.

Blog