“The one piece of advice I would give is first normal form inside a table in Excel. So that means that where you've got different months across the top, you don't want different months. You want a column and then a single column of values.”

Mark Proctor · FP&A Unlocked · Why Understanding Data is a Critical FP&A Skill with Mark Proctor

Play from 42:54
42:54

Audio streams from the publisher’s own feed. Verbatim does not host or copy it.

What was described

research first normal form and place data in an Excel table instead of using positional columns

Said nearby on the same subject

“‘we just created one in Excel where you point to the amount column… you can go look at the visual and you see huge spikes’”
DM
Daniel McCarville
The Audit Podcast ·
“I used Claude later when Lovable started to simplify a lot of my tooling instead of having tables or paper.”
CG
Christof Gomez
Data, AI & Beyond - The Podcast ·
“Make sure you have the right to the research, the right to use the data… data traceability all the way through the process.”
BH
Bethany Hills
FDA Watch ·
Data play Share this moment
“I made a column of all the worst things that could happen… then a column for how to minimize each… then a column for how to get back quickly”
TF
Tim Ferriss
Tony Robbins Podcast Daily ·
How they work Share this moment

Moments like this, every Monday

The strongest new moments on your topics, in the speakers' own words. Free for three topics.

No card. No password. One-click unsubscribe.

Track a competitor?

Pro watches up to 25 names or phrases and emails you the morning after they are said.

See Pro, $29 a month

Verbatim quotes a short extract and links to the episode; the episode belongs to its publisher. Remove a show.