Remove courses simple-spreadsheets
article thumbnail

Visualizing 24 School Divisions’ Submissions with a Dashboard in Microsoft Excel

Depict Data Studio

This guest post comes from Amadu Sidi Bah, who’s graduated from our Simple Spreadsheets, Great Graphs, Report Redesign, and Dashboard Design courses. Step 1: Creating an Excel Spreadsheet. I created a spreadsheet from Excel using all the acquired skills I learnt and as professionally as I could.

article thumbnail

Automated Mentoring with ChatGPT

O'Reilly on Data

First, Ruby and Prime Numbers I first tried a Ruby program I wrote about 10 years ago: a simple prime number sieve. Preventing this rewrite is as simple as just adding “Do not rewrite the program” to the prompt. However, it isn’t a serious problem. This program had a few problems–as we’ll see. ChatGPT is good at giving basic advice.

Testing 182
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Humanity in Data Visualization: Designing a One-Pager for My Grandma’s Caregivers

Depict Data Studio

I registered for the Simple Spreadsheets course because I was a beginner with using Excel and I knew I was utilizing only a fraction of its capabilities. It made sense to me to organize the info into two columns, and I made the text as clear and simple as possible. The Result. Unfortunately, grandma is no longer with us.

article thumbnail

Applying Data Visualization Principles to Your Business: A Before/After One-Pager Makeover

Depict Data Studio

So, I sufficed with Ann’s free Soar Beyond the Dusty Shelf Report course and blog posts. Ann’s Dashboard Design was one of the first courses I wanted to sign up for. I registered for the Dashboard Design course along with Simple Spreadsheets , Great Graphs: Design Principles , and Great Graphs: Excel How-To’s.

article thumbnail

Better Storytelling with the Same Data: Upgrade that Board Packet!

Depict Data Studio

Fortunately, after completing about 70% of the Dashboard Design course, I was able to revitalize a tired spreadsheet into an information powerhouse and a colorful budget visualization into a professional presentation. But the course showed me what little changes I could make to have a big impact. The Budget.

article thumbnail

Watch Out for Mars! 6 Data Cleaning Steps to Save You Millions

Depict Data Studio

Collecting Survey Data at HOPE International So what exactly does this have to do with spreadsheets? 6 Data Cleaning Steps to Save You Millions I’d like to show you what we do for our data cleaning process, and how Simple Spreadsheets helped to make this process even stronger. The result was a $125 million conversion error.

Testing 52
article thumbnail

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

Depict Data Studio

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. Your spreadsheets might come from…. Oftentimes, at least some spreadsheets are entered by hand. Typos Are Not Inevitable!!!