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

Tag Archive for: Excel

Account Reconciliation in Excel With ChatGPT Prompts

September 26, 2025/by Sarah Schlott

Why I tested ChatGPT on account reconciliations Reconciliations are the part of accounting that quietly eats time. Matching bank feeds against the general ledger, hunting down timing differences, and tracing stale checks — it’s thankless but essential. For years, I did this manually in Excel. I’d lean on VLOOKUP, COUNTIF, and conditional formatting, and it […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/09/pexels-rdne-7821731-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-09-26 02:31:332025-09-26 02:31:33Account Reconciliation in Excel With ChatGPT Prompts

Cash Flow Forecasting in Excel With ChatGPT Prompts

September 23, 2025/by Sarah Schlott

Why Cash Flow Forecasting Breaks FP&A Models Cash flow forecasting is one of the hardest FP&A tasks. You can nail revenue projections, lock in expense budgets, and still lose credibility if your cash schedule doesn’t tie out. In practice, building cash flow forecasts in Excel means handling messy timing differences: deferred revenue, staggered collections, and […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/09/pexels-tima-miroshnichenko-6693647-modified-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-09-23 19:39:262025-09-27 17:56:53Cash Flow Forecasting in Excel With ChatGPT Prompts

Excel Has a New Add-In: It’s Called ChatGPT

September 22, 2025/by Sarah Schlott

Excel Meets Its Secret Weapon Excel has always been the quiet workhorse of business. Rows, columns, SUM, VLOOKUP — a reliable toolbox. But mastering it came at a cost: you either memorized hundreds of functions or spent hours debugging formulas that broke without warning. Now there’s a twist. You don’t have to do it alone. […]

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-09-22 19:08:342025-09-26 02:10:08Excel Has a New Add-In: It’s Called ChatGPT

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

What a 13-year-old babysitter taught me about financial leadership

August 1, 2025/by Sarah Schlott

You don’t forget the first time you’re left in charge of someone else’s chaos. For me, it was a suburban living room full of Goldfish crumbs and sticky Legos. I was 13. My older sister—a seasoned babysitter with a Rolodex of wealthy neighborhood clients—was passing the torch. I asked the question every first-timer asks.“What do […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/08/pexels-kampus-7414391-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-08-01 09:02:132025-08-14 00:46:55What a 13-year-old babysitter taught me about financial leadership

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

Why Most Annual Operating Plans Are DOA by Q2 (And What Smart CFOs Are Doing Instead)

July 5, 2025/by Sarah Schlott

It’s not just you—the AOP is broken. By the time your operating plan is finalized, conditions have already changed. Yet every finance team still rolls out the same rigid framework, convinced that precision equals control. But the smartest CFOs know that an AOP built for static reality won’t survive dynamic conditions. This post unpacks why […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/06/pexels-thecoachspace-2977565-1.jpg 800 1200 Sarah Schlott https://sarahgschlott.com/wp-content/uploads/2026/08/icon-10c-two-blob-light_clearspace-1030x1030.png Sarah Schlott2025-07-05 18:03:082025-08-14 00:47:02Why Most Annual Operating Plans Are DOA by Q2 (And What Smart CFOs Are Doing Instead)

Designing Your Finance Operating System: The Hidden Lever Behind High-Performance Companies

July 4, 2025/by Sarah Schlott

Most companies don’t scale because they lack capital. They stall because they never designed an operating system strong enough to handle the weight of growth. And the finance team? They’re often the last to get one. Instead of operating like a product org with sprints and a clear roadmap, or like sales with a CRM […]

Read more
https://sarahgschlott.com/wp-content/uploads/2025/07/pexels-cowomen-1058097-2041627-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-07-04 18:07:412025-08-14 00:47:04Designing Your Finance Operating System: The Hidden Lever Behind High-Performance Companies

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
Page 1 of 212

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