Data Hygiene & Normalized Table Schemas
Eliminate merged headers, mixed date formats, text-formatted numbers, and duplicate CRM rows so formulas never fail silently.
AI & Generative Media
Program #016 · AI Media
✓ Free Online Intro Included
Spreadsheet Architecture, Formulas & AI Automation in Excel & Sheets
Normalize messy business exports, engineer auditable XLOOKUP and QUERY formulas, validate Apps Script automations, and design clear executive reports.
Asking a chatbot for a giant nested formula on top of a messy spreadsheet usually trades one headache for a silent calculation error. Good spreadsheet automation begins with clean table structure. When raw exports mix text currencies, merged cells, and inconsistent dates, every downstream chart breaks. In this course, we separate raw imports from calculation layers, use AI to write and audit XLOOKUP, dynamic array, and QUERY logic, validate lightweight Apps Script routines safely, and build calm financial or operational dashboards.
✓ Free Online Introductory Session
Start with a free online intro consultation for this course: we review the syllabus together, clarify how many sessions you need based on your goals and pace, and decide whether continuing Online ($69 CAD/hr) or In-Person ($99 CAD/hr) suits you best.
First Session
Free Online Intro
Session Rates
$69/hr Online · $99/hr In-Person
Course Structure
Tailored to Your Level & Pace
Instructor & Language
Iman Adlkhah · EN & Persian
Prefer just the written framework instead of live sessions? A standalone $39 CAD PDF guide option can also be requested for this course: select the PDF option below.
Want our Toronto studio to build or produce this directly for your business? Explore Tehranto.Plus Custom Web Apps & AI Systems, Commercial Video Production, and recent studio work on @tehranto.plus on Instagram.
Course Learning Pillars
Core Capabilities Developed in This Course
Every learner starts from a different background. These are the core capabilities this course develops, paced to your goals across the sessions we plan together.
Auditable Formula Architecture
Design modular XLOOKUP, INDEX/MATCH, FILTER, SUMIFS, and Google Sheets QUERY pipelines that you and your team can read and verify.
Privacy-Safe AI Prompting & Math Validation
Share synthetic schema headers instead of confidential client ledgers, and reconcile totals with control checks so chatbot math never slips through.
Validated Scripts & Executive Dashboard Clarity
Test Google Apps Script or Office Script automations on sandbox copies first and present key revenue, margin, and cohort metrics without clutter.
Course Syllabus
Core Concepts & Topics Covered
Below are the main concepts and topics covered in this course. In your Free Online Intro Session, we align the exact depth and number of sessions to your experience and goals.
Topic 01
Data Normalization & Three-Layer Workbook Architecture
Restructuring fragile spreadsheets into separated Raw Import, Staging Calculation, and Executive Presentation layers.
- Cleaning bank, Stripe, Shopify, and CRM CSV exports with TRIM, VALUE, DATEVALUE, and regex tools
- Designing anonymized 'header plus sample rows' prompts to protect private financial records
- Building reconciliation check cells that immediately flag row mismatches or missing categories
Topic 02
Modern Lookup, Dynamic Array & QUERY Engineering
Using AI as a formula co-architect to write, document, and debug clean relational logic across tabs without brittle column-index counting.
- Replacing fragile VLOOKUP habits with structured tables, XLOOKUP error handling, and FILTER arrays
- Writing multi-condition Google Sheets QUERY statements for live grouping, sorting, and monthly rollups
- Decomposing unreadable nested IF chains into clean LET variables or lookup reference tables
Topic 03
Apps Script & Macro Automation With Sandbox Validation
Automating repetitive formatting, archiving, and alert workflows safely, even if you are not a full-time software developer.
- Generating readable, commented Google Apps Script or Office Script functions from clear specs
- Reviewing script permissions, trigger schedules, and rollback backups before touching live sheets
- Automating recurring snapshots, overdue-invoice flags, and clean PDF summary exports
Topic 04
Executive KPI Modeling & Decision-Ready Dashboards
Translating normalized rows and pivot summaries into a calm, scannable dashboard focused on real business decisions.
- Structuring Pivot Tables, dynamic date or cohort selectors, and variance comparisons (actual vs target)
- Choosing honest chart types and restrained conditional formatting that surface true anomalies
- Locking formula ranges and documenting handoff notes so teammates never break the template
Course Reference Overview
Spreadsheet Architecture & AI Validation Matrix
Core practical benchmarks and standards covered as part of this course's curriculum.
| Workflow Layer | Fragile Spreadsheet Habit | Principled Architecture | Business Reliability |
|---|---|---|---|
| Data Intake | Editing raw exports directly inside summary tabs | Isolated raw-import tab with normalized schema types | Repeatable imports without broken references |
| Formula Logic | Blindly pasting giant AI-generated nested formulas | Modular XLOOKUP, LET, and QUERY with audit totals | Transparent math any manager can verify |
| Data Privacy | Uploading full client ledgers to public chat tabs | Anonymized schema headers with synthetic test rows | Zero exposure of sensitive client records |
| Script Automation | Running untested scripts straight on live company files | Sandbox validation, clear comments, and backup logs | Safe automation of routine reporting tasks |
Start With Your Free Intro Session
Book Program #016: Spreadsheet Architecture, Formulas & AI Automation in Excel & Sheets
Choose a time for your Free Online Intro Session to map out your course path, or book an Online ($69/hr) or In-Person ($99/hr) session directly, or request the $39 CAD PDF guide option.
1. Choose Option & Preferred Time (ET)
Standalone PDF Guide Option ($39 CAD)
If you prefer to study the written framework and reference checklists of this course on your own instead of live coaching sessions, enter your details on the form to request the $39 CAD PDF edition. We will coordinate and send your payment link and PDF guide via email or WhatsApp.
Program FAQ
Common Questions
Should we focus on Microsoft Excel or Google Sheets in this course, and can I bring my own messy work template?
You can focus on Excel, Google Sheets, or a bridge between both depending on what your workplace runs daily. Bringing an anonymized version of your own financial tracker, inventory sheet, or CRM export works best, and in your Free Online Intro Session we review its complexity so we can plan the exact sessions you need.
How does the Free Online Intro Session work, and how many sessions will I need?
Every course begins with a Free Online Introductory Session where we review the core syllabus together, evaluate your current background and goals, and map out how many sessions you actually need and whether continuing Online ($69 CAD/hr) or In-Person ($99 CAD/hr) suits you best. Session count is never a rigid one-size-fits-all number; it adapts to your own level and pace.
Do I have to commit to a multi-session package, or can I get just the PDF guide?
There is zero upfront package commitment: live sessions are booked flexibly session-by-session ($69 CAD/hr online or $99 CAD/hr in-person). If you prefer a self-paced written guide instead of live coaching, a standalone $39 CAD PDF option can also be requested for this topic.
Are courses taught in English, Persian (Farsi), or bilingual?
Your choice: every session with Iman Adlkhah can be conducted 100% in English, 100% in Persian (Farsi), or naturally bilingual with industry terminology.
More in AI & Generative Media
Related Courses to Explore Next
#010
Free Intro
Custom GPTs & Claude Projects: Knowledge Systems for Teams
Turn scattered company SOPs, pricing rules, and client templates into reliable team AI workspaces with clear guardrails and consistent brand voice.
Short-Term · 1-on-1
View Syllabus →
#011
Free Intro
AI Talking-Head Avatars & Multilingual Video Dubbing
Build an ethical, natural-looking presenter workflow for multilingual dubbing and hybrid educational videos across English, Persian, and French.
Short-Term · 1-on-1
View Syllabus →
#012
Free Intro
Higgsfield Cinema Studio: Character Lock & Camera Direction
Pair clean anchor frames, Soul ID character continuity, and motivated camera movement in Higgsfield Cinema Studio without falling into gimmicky visual effects.
Short-Term · 1-on-1
View Syllabus →