AI: Spreadsheet Formula Time-Saver

Author

Andrew Walker
April 22, 2025

  • AI instantly solves spreadsheet formula challenges that cost organizations money.

  • Simple AI prompting saves clubs and small businesses from absorbing hidden costs.

My wife and I help out a local club and came across another easy opportunity to save time and frustration by using AI.

We have a spreadsheet for members ordering merchandise, but the last time we placed an order we realised we hadn't apportioned freight, so that expense was worn by the club (no pun intended).

We had just added the freight total at the top of the spreadsheet and we were trying to figure out how to apportion it .. when I thought, AI will get this done for us.

I gave it this screenshot, and asked..

can you give me a formula for G6 to copy down, that spreads the freight in G3 by the number of items each person has ordered.

here's the first step and the adjustment....

here's the end result after one adjustment for blank values..

Just one of the countless ways AI makes life these days easier.

When you're ready, here's how I can help:

1. AI Orientation Session

A two-hour strategic briefing for you and your executive team.

  • Gain a clear, executive-level framework for AI

  • Cut through the hype and speak the language confidently

  • Explore the 6 most impactful, practical AI applications

  • Learn to identify and prioritise AI-driven opportunities

  • Define smart, secure next steps

  • No advance preparation needed

  • Focused on business outcomes, not technical jargon

2. Custom AI Strategy & Roadmap

Tailored, actionable AI strategy for your organisation.

  • Pinpoint high-value AI opportunities unique to your business

  • Prioritise your top 3-5 practical, low-risk AI use cases

  • Set a clear, detailed roadmap for immediate implementation

  • Align your executive leadership with board-ready documentation

  • Leverages insights from the Orientation Session

3. AI Integration & Implementation

Full-service implementation of your AI initiatives.

  • Comprehensive, end-to-end management of AI initiatives

  • Seamless integration into existing systems and processes

  • Emphasis on security, compliance, and reliability

  • Dedicated technical team and specialised resources

  • Fully managed, hassle-free execution—we handle the complexities

Andrew Walker
Consulting to for-purpose CEOs to deliver more impact with existing teams and systems - by freeing humans up from admin.
https://www.linkedin.com/in/andrew-walker-the-impatient-futurist/

Did someone forward this email to you? Want your own subscription? Head over here and sign yourself right up!

Back issues available here.

Reply

or to participate.