depictdatastudio

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 […]

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 — […]

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 […]

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:

This is an Eval Central archive copy, find the original at depictdatastudio.com. My 3rd grader was not impressed. ;P What’s Inside 0:00 Intro 2:26 Behind the Scenes 3:12 Single Contiguous Dataset 3:50 Pivot Tables 4:15 Pivot Charts 4:24 Slicers 4:26 Helper Tables 5:35 Step-by-Step Demo

This is an Eval Central archive copy, find the original at depictdatastudio.com. A quick demo for my kindergartener.

This is an Eval Central archive copy, find the original at depictdatastudio.com. Behind-the-scenes Excel workarounds to label your x-axis juuust right.

This is an Eval Central archive copy, find the original at depictdatastudio.com. Sure, you can add anything and everything to your dashboard. (Here’s a running list of all the great graphs you can make in Excel.) In this article, you’ll learn about 20 stress-free charts that we can make inside spreadsheet software like Microsoft Excel. These visuals […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. If you’ve got a column chart with lots of labels, chances are, the labels have gotten twisted diagonally, like this: Diagonal text takes longer to read than plain ol’ horizontal text, so we want to avoid it. In this lesson, you’ll learn 5 […]

This is an Eval Central archive copy, find the original at depictdatastudio.com. Are you presenting online? Are you sharing the replays with attendees? Captions increase the accessibility of our recordings, making it easier for attendees with hearing issues, audio/tech glitches, and non-English speakers to follow our ideas. In this lesson, you’ll learn about embedded captions […]