Sarah Schlott
  • Home
  • Contact
  • Click to open the search input field Click to open the search input field Search
  • Menu Menu

How to VLOOKUP Your Will to Live: A Beginner’s Guide

August 6, 2025/by Sarah Schlott

Let’s not pretend anyone enjoys Excel. You don’t crack open a spreadsheet because life is bursting with meaning. You open Excel the way a mid-century housewife opened gin at 2pm: quietly, with dread, and because someone just asked about KPIs again. So today, we’re doing something useful with it. We’re going to use Excel to […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/08/ChatGPT-Image-Aug-6-2025-11_49_07-AM-1.png 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-08-06 11:55:232025-08-14 00:46:52How to VLOOKUP Your Will to Live: A Beginner’s Guide

7 Excel Functions That Will Replace Your Therapist (and Probably Your Job Too)

July 24, 2025/by Sarah Schlott

By Someone Who’s Been Held Hostage by a Circular Reference Since 2020 At some point in the past ten years—no one’s exactly sure when—therapy got outsourced to Google Sheets and SaaS dashboards. The budget got cut, the benefits evaporated, and suddenly your emotional stability was being maintained by a locked cell and a conditional format. […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/07/pexels-serpstat-177219-572056-1-2.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-07-24 17:30:412025-08-14 00:46:577 Excel Functions That Will Replace Your Therapist (and Probably Your Job Too)

We Tried Running a $100M Forecast in Excel—Here’s What Broke First

July 8, 2025/by Sarah Schlott

Running your entire FP&A process in Excel is like flying a commercial airline with Google Maps. It’ll get you off the ground. But you’ll crash the minute conditions change. Let’s get something straight:This is not an anti-Excel piece. This is a pro-sanity one. Excel is the most powerful modeling tool in finance. No question. But […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/06/pexels-natri-792199.jpg 801 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-07-08 18:00:042025-08-14 00:47:01We Tried Running a $100M Forecast in Excel—Here’s What Broke First

Excel Is Dead: FP&A Team Now Builds Models in PowerPoint

June 4, 2025/by Sarah Schlott

It started, as most modern corporate absurdities do, with a single sentence in a leadership Slack thread: “Do we really need Excel for this?” Cue the floodgates. Someone (from Marketing, naturally) posted a Medium think piece on how “spreadsheets are a relic of the past.” Someone else chimed in about their nephew using Notion for […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-pavel-danilyuk-7868972-1.jpg 801 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-06-04 23:45:222025-08-14 00:47:29Excel Is Dead: FP&A Team Now Builds Models in PowerPoint

Avoiding Hidden Risks: Data Integrity Best Practices with Excel Power Query

June 1, 2025/by Sarah Schlott

Here’s a dirty little secret of finance: the more polished the deck, the more likely there’s duct tape holding the data pipeline together. I’ve seen it. Flashy dashboards. Perfectly aligned KPIs. Everyone nodding in the boardroom—until someone asks, “How was that calculated?” Cue the mad scramble: Slack threads, undocumented Excel formulas, a stale mapping file […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-mareklevak-2265488-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-06-01 17:04:112025-08-14 00:47:37Avoiding Hidden Risks: Data Integrity Best Practices with Excel Power Query

The CFO’s Guide to Scaling Financial Data Prep: From Manual to Automated Workflows

June 1, 2025/by Sarah Schlott

Let me give it to you straight: most finance teams are flying their planes while building the wings. And that’s fine—until you hit turbulence. I’ve worked with scaling companies where the first $10M in revenue was built on ad hoc Excel reports, stitched together the night before the board meeting. And hey—it worked. Until it […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-mikhail-nilov-6963857-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-06-01 11:52:422025-08-14 00:47:40The CFO’s Guide to Scaling Financial Data Prep: From Manual to Automated Workflows

How to Build an Audit-Friendly Financial Data Pipeline with Excel Power Query

May 31, 2025/by Sarah Schlott

Let’s start with a truth no one likes to say out loud: audits don’t fail because the numbers were wrong. They fail because no one can prove they were right. I’ve seen it too many times. You’ve got a perfectly accurate board deck. A forecast that matches actuals to the penny. But when the auditors […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-serpstat-177219-572056-1-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-05-31 19:43:152025-08-14 00:47:42How to Build an Audit-Friendly Financial Data Pipeline with Excel Power Query

10 Common Financial Reporting Tasks You Can Streamline with Power Query

May 31, 2025/by Sarah Schlott

Here’s a hard truth they don’t tell you in finance onboarding: most “financial reporting” is glorified janitorial work. You know the drill. Dump the GL. Copy and paste into five different workbooks. Filter out the junk rows. Reformat dates. Fix that one column that always comes in as text instead of numbers. Then pray your […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-vojtech-okenka-127162-392018-scaled-e1748310603244.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-05-31 10:10:352025-08-14 00:47:4410 Common Financial Reporting Tasks You Can Streamline with Power Query

Advanced Excel Forecasting Models for CFOs: From Scenario Planning to Sensitivity Analysis

May 28, 2025/by Sarah Schlott

Let me tell you something about forecasting that doesn’t make it into the glossy investor decks: it’s less art, more street fight. Forecasting is what happens when you’re locked in a room with imperfect data, an impatient executive team, and the ticking clock of a quarterly board meeting. I’ve lived that loop more times than […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-pavel-danilyuk-7868972-1.jpg 801 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-05-28 16:07:312025-08-14 00:47:50Advanced Excel Forecasting Models for CFOs: From Scenario Planning to Sensitivity Analysis

Why Smart Finance Teams Build Dashboards in Excel First: 4 Tactical Wins

May 26, 2025/by Sarah Schlott

I’ve seen more dashboards die in the wild than PowerPoint decks in an abandoned investor folder. You know the type—some over-engineered, visually stunning, SaaS-powered monstrosity that looks great until someone asks for a new metric and you realize no one on the team knows how it was built. Or worse: the original architect left the […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/05/pexels-lexovertoom-1109543-scaled-e1748310564879.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-05-26 21:57:552025-08-14 00:47:52Why Smart Finance Teams Build Dashboards in Excel First: 4 Tactical Wins
Page 2 of 3123

Latest Posts

  • The Budget Was Approved Long Before the Meeting
  • 8 Financial Mistakes Women in Their 40s Make—and How to Fix Them (2026 Guide)
  • Jobless Claims Fell Below 200,000
  • The Most Dangerous “Modern” Excel Formula: =UNIQUE()
  • The Most Dangerous Excel Formula in Finance
  • The Quiet Revolution: AI in FP&A 2025
  • I Didn’t Choose the Spreadsheet Life — The Spreadsheet Life Chose Me
  • The night before our board meeting, the ARR report didn’t tie out.
  • We rebuilt our churn model after it lied to us — in front of the board.
  • Some days being a SaaS CFO feels like air traffic control — but every plane is on fire.
© Copyright - Sarah Schlott
Scroll to top Scroll to top Scroll to top