Remove courses pivot-tables-in-spreadsheets
article thumbnail

How to Make Interactive Dashboards in Excel

Depict Data Studio

You’ll need four pieces: A Clean, Contiguous Dataset (maybe stored as an Excel Table) Pivot Tables Pivot Charts Slicers Are you already using these four features regularly? Are you new to Excel Tables, pivot tables, pivot charts, or slicers? Interactive (a.k.a. Be patient with yourself.

article thumbnail

Two Types of Tables: Datasets vs. Tabulations

Depict Data Studio

From a data prep perspective, one really long table is the correct way to store the underlying data. Dealing with dozens of tables that should just be a single set is a typical rookie mistake.” ” Let’s chat more about that distinction: storing underlying data vs. tables that look nice visually. .”

Insiders

Sign Up for our Newsletter

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

article thumbnail

Top 23 Dataviz Resources of 2023

Depict Data Studio

9,200 total participants in my dataviz courses so far (and ~25,000 taught virtually and in-person over the past decade). Host Jon Krohn asked me to summarize some of my favorite tips for data storytelling, spreadsheets, reports, and presentations. 32 new blog posts : 28 from me , and 4 from guest authors. 2 more podcast interviews.

article thumbnail

My 6 Data Communications Classes

Depict Data Studio

Class 1: Simple Spreadsheets: How to Analyze Data from Start to Finish in Excel Need to make sense of spreadsheets? These spreadsheet skills will save your time, energy, and sanity. For example, in the Analyze Data with Pivot Tables module, the instructor will show how to insert a pivot table and drag-and-drop variables.

article thumbnail

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

Depict Data Studio

I was going on and on about all my great spreadsheet skills. These days, I spend most of my time training others on data visualization—which means I spend less time inside spreadsheets. Download the spreadsheet here: Download the spreadsheet. Download the spreadsheet here: Download the spreadsheet.

Testing 118
article thumbnail

The Inside Scoop on Excel with Bill Jelen (Mr. Excel)

Depict Data Studio

He was a guest speaker inside our data analysis course, Simple Spreadsheets. Bill’s first spreadsheet experience. Bill shared that his first time with a spreadsheet of any sort was in 1984 while he worked for a company that sold computer software. His thoughts on Excel Tables. Watch Our Conversation Here.

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. to set up foolproof data entry spreadsheets.