Wirewalk Instituteof AI
wrk-202 Basic Waitlist

Spreadsheets and BI with AI: Excel, Power BI and Tableau

For everyday spreadsheet and dashboard users who want to analyze data faster with Copilot in Excel, Gemini in Google Sheets, Power BI Copilot and Tableau's AI, and still trust the numbers.

The curriculum is being prepared and reviewed. Enrollment is not open yet.

About this course

Most people meet AI-assisted analysis inside a spreadsheet or a dashboard, not a notebook. This course teaches those tools directly. In Excel it covers Copilot chat, Agent Mode and Plan Mode, formula explanation and repair, and the =COPILOT function for row-level text work; in Google Sheets it covers Gemini in the side panel, building spreadsheets from a prompt and the =AI function. It then covers analysis without code using Python in Excel, and cleaning messy exports with AI help.

The BI modules cover Copilot in Power BI for report pages, summaries and Q&A, how to prepare a semantic model so Copilot answers correctly (names, descriptions, synonyms), and Fabric data agents; and on the Tableau side, Tableau Agent in Desktop and Prep, Tableau Pulse metrics and Tableau Next on Salesforce Data 360 (formerly Data Cloud). The final module is about trust: checking AI answers against totals, filters and metric definitions, understanding what sensitivity labels and row-level security let Copilot see, and recognizing when a question needs an analyst. Licensing and feature availability are as of October 2026 and vary by plan. Analysts working in SQL and Python should see wrk-118. Completion and a passing exam score earn a Wirewalk Institute of AI certificate of completion and assessment; it is not a vendor certification or endorsement.

What you will be able to do

  • Use Copilot in Excel and Gemini in Google Sheets to build, explain and fix formulas, and audit the result
  • Apply the =COPILOT and =AI functions to row-level text tasks and explain their limits for numeric work
  • Prepare a Power BI semantic model with clear names and descriptions so Copilot answers questions correctly
  • Use Tableau Agent and Tableau Pulse to explore data and monitor metrics
  • Verify an AI-generated answer against totals, filters and metric definitions before sharing it
  • Explain how sensitivity labels and row-level security limit what AI features can see

Syllabus

5 modules · 14 lessons · about 7 hours

Module 1: AI in the Grid

Copilot and Gemini inside spreadsheets, and AI functions in cells.
3 lessons
  1. Copilot in Excel: Chat, Agent Mode and Plan Mode
  2. Formula Help You Can Audit: Explaining, Fixing and Rewriting Formulas
  3. The =COPILOT and =AI Functions: Row-Level Text Work and Its Limits

Module 2: Analysis Without Code

Deeper analysis and cleanup with AI assistance.
3 lessons
  1. Python in Excel for Questions Beyond Pivot Tables
  2. Gemini in Google Sheets: Building and Editing Spreadsheets from a Prompt
  3. Cleaning Messy Exports: Splits, Lookups and Deduplication

Module 3: Power BI with Copilot

Reports, Q&A and the semantic model that makes them accurate.
3 lessons
  1. Copilot in Power BI: Report Pages, Summaries and Questions
  2. Preparing a Semantic Model for Copilot: Names, Descriptions and Synonyms
  3. Fabric Data Agents for Questions Across Your Data

Module 4: Tableau with AI

Tableau's assistants and metrics layer.
2 lessons
  1. Tableau Agent in Desktop, Cloud and Prep
  2. Tableau Pulse Metrics and Tableau Next on Salesforce Data 360

Module 5: Trusting the Numbers

Verification, access controls and knowing when to escalate.
3 lessons
  1. Checking AI Answers Against Totals, Filters and Metric Definitions
  2. Sensitivity Labels, Row-Level Security and What Copilot Can See
  3. When a Question Belongs with an Analyst

Exam and certificate

The exam unlocks once you have completed every lesson. It draws 20 questions from a larger bank, spread across the modules, with the answer options shuffled for each attempt. You have 40 minutes and need 80% to pass. After a failed attempt you can try again after 24 hours, up to 3 attempts in total. Feedback is given per module, never as the answer key.

Passing earns a certificate of completion and assessment from the Wirewalk Institute of AI with a unique ID that anyone can check at institute.wirewalk.com/verify. It is not an accredited qualification or a vendor certification. How certification works.

The Wirewalk Institute of AI is independent. This course teaches publicly documented products and is not affiliated with or endorsed by Microsoft, Google, or Salesforce. Product and company names are trademarks of their respective owners.

wrk-110 Basic Waitlist

AI for Finance and Accounting Teams

Practical AI for finance and accounting: reviewing models in Excel with Copilot and Claude, reconciliation and close support, invoice extraction, FP&A commentary, and the SOX and audit-evidence discipline that keeps AI-assisted numbers reliable.

7 h · 15 lessons Join the waitlist
wrk-111 Basic Waitlist

AI for Legal Professionals

Using AI in legal work without ethical or evidentiary missteps: ABA Formal Opinion 512 and the Model Rules, grounded research in Westlaw and Lexis, contract review, eDiscovery, court AI-disclosure orders and building a practice-group AI policy.

7 h · 15 lessons Join the waitlist
wrk-112 Basic Waitlist

AI for HR and Talent Teams

AI across the employee lifecycle with the legal guardrails built in: drafting and screening in recruiting, NYC Local Law 144, Illinois HB 3773 and the EU AI Act's employment rules, handbook assistants, performance writing, and employee privacy.

7 h · 15 lessons Join the waitlist