This is an Eval Central archive copy, find the original at depictdatastudio.com. I’ve been following Carlos for years. I fan-girled at his workshop at the Global Excel Summit in London: Later, I asked him for a 10-minute interview to talk about some of his favorite Excel vizzes. We accidentally talked for almost 2 hours (!!) […]
Show MORE Points in Time On Your Graph!!!
This is an Eval Central archive copy, find the original at depictdatastudio.com. If you have TONS of points over time… show tons of data in your graph! Too often, I see organizations show just a single point in time. A single number is meaningless. We need at least two numbers — preferably three, four, or […]
Why I’m Not in Love with Canva for Infographics & Dataviz
This is an Eval Central archive copy, find the original at depictdatastudio.com. Convince me otherwise…? What’s Inside 0:00 Intro 0:44 What Canva looks like inside 1:11 Making a new infographic in Canva 1:20 Paid vs. free Canva 1:55 Bad infographics are probably still better than 100-page Dusty Shelf Reports 2:15 Brand presets 2:39 Mixed case […]
A Dozen Tiny Differences
This is an Eval Central archive copy, find the original at depictdatastudio.com. I wish I could share the one secret you need to know about dataviz. But there isn’t one thing that’ll completely transform your dataviz. There are a dozen tiny details: What’s Inside 0:00 Welcome 1:04 Borders 1:15 Scale and Grid Lines 1:59 Branding […]
Line Chart to Small Multiples – Remaking a NSF Graduate Research Fellowship Program Graph
This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently saw this graph on LinkedIn. The topic caught my attention, but I was worried that the internet weirdos would ignore it because the axis doesn’t start at zero. People will create all sorts of excuses to ignore data and facts. I […]
6 Examples of Interactive Dashboards Made in Microsoft Excel
This is an Eval Central archive copy, find the original at depictdatastudio.com. Excel can do a lot—formulas, pivot tables, charts, static one-pagers, and even interactive dashboards! In this article, you’ll see a few examples and how-to tips to get you started. YouTube Stats Are you brand new to Excel dashboards? This YouTube video’s about the […]
Re-Sorting Categories in Pivot Tables
This is an Eval Central archive copy, find the original at depictdatastudio.com. By default, Excel will sort categories alphabetically or chronologically. But we can use the “brackety compass rose” to customize our pivot tables… which lets us customize our graphs. For example, with this technique, we can re-sort Agree, Disagree, Neutral, Strongly Agree, Strongly Disagree…. into Strongly […]
What are Helper Cells?
This is an Eval Central archive copy, find the original at depictdatastudio.com. What are Helper Cells, exactly? In this video, you’ll see 3 examples of these intermediate cells, which give you full editing control over your graphs, maps, and tables. What’s Inside 0:00 Intro 1:28 What are Helper Cells? Regular Table — Intermediate Table — […]
How to Make Online Courses
This is an Eval Central archive copy, find the original at depictdatastudio.com. I just finished re-recording Dashboard Design! I’ve had 10,000+ students in my online courses since 2018, and I get a lot of questions about this process, like… How did you turn your keynote into a full-length online course? How did you turn your […]
Why do my Excel formulas say “RC?!” Help!!
This is an Eval Central archive copy, find the original at depictdatastudio.com. Do your formulas look weird? Maybe they say “RC[-1]” or some other jargon. The solution: Go to File Options Formulas Uncheck the “R1C1 reference style” box Here’s a video tutorial: