How Accountants Can Use AI to Skip Years of Technical Learning
Accountants used to earn their technical skills the hard way: years of formulas, VBA, and self-teaching on nights and weekends. Episode 1 shows the new path. Open AI inside Excel and just ask the question.
Can AI Really Help Accountants Skip Years of Technical Learning?
Yes. You no longer have to do the learning first. You just have to ask the question. Accountants used to build technical skills through a slow progression: basic Excel formulas, then advanced functions, then VBA, all learned out of necessity because the repeatable work never stopped coming. AI tools like Claude in Excel and ChatGPT collapse that progression. They are context aware, they can see the data you are actually working with, and they can show you a better way to do what you are already doing the moment you ask.
The learning still happens. It just happens through the asking. Episode 1 walks through exactly where to start and the one rule that keeps you safe: trust, but verify.
Why Did Building Technical Skills Take Years?
If you wanted to be a tech-enabled accountant, there was a progression, and everyone who went through it knows it by heart. You started with simple formulas: VLOOKUPs, then INDEX MATCH. From there you graduated to SUMPRODUCT and formulas of that complexity. And once you had exhausted every available formula, you started writing VBA and other expert-level code.
Nobody did that for fun. You did it because the repeatable work never stopped coming, the volume kept increasing, and nobody hired anyone to help you. Upskilling was survival: you taught yourself so the computer could do the heavy lifting, if you could even find the time to learn while staying afloat.
And the learning itself was slow. It meant tons of training, LinkedIn Learning courses, and years of being a nerdy Excel user, playing around on nights and weekends until things clicked. That was the price of admission. Episode 1 is about why you no longer have to pay it.
The Shift
Ask the Question, Get the Learning
"Now you don't have to do any of that learning. All you have to do is ask the question."
John Ikosipentarhos, Episode 1
If you have a problem, launch Claude in Excel or ChatGPT within Excel and ask if there is a better way to do what you are already doing. These tools are context aware: they can look across the tabs in your workbook and bring your actual data into the conversation. The answer is not a generic tutorial. It is specific to the file in front of you.
That one habit is what moves you from AI skeptic to "okay, this actually does work." And it is the foundation everything else in this series builds on.
Inside the Episode
What Episode 1 Covers
- The unique position accountants are in today, and why the old upskilling path is now optional
- The single best starting point for AI skeptics: Claude or ChatGPT inside Excel
- What context awareness means: AI that reads across your workbook tabs and understands your actual data
- A high-level example: using GL detail, account mappings, and supporting context to draft a balance sheet, P&L, and cash flow
- How to decode an inherited workbook: what it does, and which inputs are manual versus formula driven
- The number one rule for putting AI into your workflow: trust, but verify
3 Ways to Start Using AI in Excel This Week
These are the exact starting points John walks through in Episode 1. No VBA, no courses, no prerequisites.
Ask if there is a better way to do what you are already doing
Open Claude in Excel or ChatGPT within Excel and describe the task in front of you. Because the AI can see your workbook, the answer comes back grounded in your actual data instead of a generic tutorial. If you are still an AI skeptic, this is the place to start.
Turn raw GL detail into financial statements
Give AI a transaction detail report along with the chart of accounts, opening balances, reporting period, and relevant classifications, then ask it to help draft a balance sheet, P&L, and cash flow. Reconcile the draft to the source data and review every mapping and adjustment before relying on it.
Decode a workbook you inherited
Taking over a file from someone who left, moved on, or went on leave? Ask AI what the workbook is doing, where the manual inputs live, and which cells are formula driven. It walks you through the file so you are productive on day one instead of reverse engineering it for a week.
The Number One Rule: Trust, But Verify
AI in Excel will do heavy lifting that used to take years of skill to automate. It will also occasionally be wrong. John's rule in Episode 1 is simple: trust, but always verify. Let AI draft the formula, build the statement, or explain the workbook, then check the output against your source data before you rely on it. You own the result, the same as if a staff accountant had prepared it.
Key Takeaways from Episode 1
- You no longer have to grind through formulas and VBA before you can automate your work. Ask the question instead.
- Start with Claude in Excel or ChatGPT inside Excel. Context awareness makes every answer specific to your workbook.
- By asking the question, you get the learning. Every answer teaches you something that used to require a course.
- Trust, but verify. Review AI output against your source data the way you would review anyone's work.
Your Guide
Who's Teaching This Episode
John Ikosipentarhos, CPA
President & Co-Founder, Zeroed-In Consulting
John spent years climbing the exact learning curve this episode describes: formulas, advanced functions, and VBA, learned out of necessity. Today he helps accounting and finance teams skip that curve using AI. He has 12+ years of experience in public and private accounting, specializing in month-end close, financial statement preparation, AI and Automation, and is a licensed CPA in California.
Common Questions
Episode 1 Frequently Asked Questions
No. That progression, from VLOOKUPs and INDEX MATCH to SUMPRODUCT to VBA, was the old path to automating repeatable work. AI removes the prerequisite: you describe what you need in plain English and the tool writes the formula, builds the output, or explains the approach. The learning now comes through asking, not through years of courses.
Tools like Claude in Excel can read across the tabs in your workbook and bring that data into the conversation. Instead of answering from a generic template, the AI reasons about your actual GL detail, your actual schedules, and your actual formulas, which makes its answers immediately usable.
Start with chat inside your spreadsheet: Claude in Excel or ChatGPT within Excel. Ask if there is a better way to do what you are already doing. It is the lowest-risk, highest-payoff first step, and it is usually the moment skeptics realize the technology actually works.
Yes, AI can help draft financial statements when the GL detail is paired with the chart of accounts, opening balances, reporting period, mappings, and other supporting context. Episode 1 demonstrates the workflow, but the output still needs to be reconciled to the source data and reviewed before you rely on it.
Trust, but verify. That is the number one rule of the episode. AI is reliable enough to do real work, and fallible enough that every output should be checked against your source data before it reaches a deliverable.
Episode 1 premieres free on YouTube on August 3rd, 2026 at 9:00 a.m. Pacific Time. Join the series to get the episode delivered to your inbox the moment it's released, along with practical takeaways you can apply immediately.
Episode 2, releasing in September 2026, covers what to do before implementing AI in your accounting team: building repeatable prompts and processes that produce reliable results. A new episode is released every month through December 2026.
Keep Going
Your Next Step
Find Your Team's Place on the AI Skill Tree
Episode 1 gets you from skeptic to your first hands-on win. The interactive AI Skill Tree maps the full journey for accounting and finance teams, so you can pinpoint where you are today and the next move that compounds.
Explore the AI Skill TreeSee the Full Episode Roadmap
Zeroed-In on AI runs monthly from August through December 2026, moving from asking better questions in Excel to repeatable prompts, deeper Claude in Excel workflows, end-to-end automation with n8n, and custom AI dashboards.
View All 5 EpisodesJoin the Series
Receive Each New Episode as It's Released
Most accounting and finance professionals know AI is changing the industry. The challenge isn't whether to adopt it. It's knowing where to start.
This video series walks you through a practical progression from using AI as a research assistant to building custom workflows and AI-powered applications that solve real accounting problems.
Each month, you'll receive a new episode, practical takeaways you can apply immediately, and guidance from our President and Co-Founder, John Ikosipentarhos, as you move from AI curiosity to confident implementation.