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
1
Module 1: AI in the Grid
Copilot and Gemini inside spreadsheets, and AI functions in cells.3 lessons
Copilot in Excel: Chat, Agent Mode and Plan Mode
Formula Help You Can Audit: Explaining, Fixing and Rewriting Formulas
The =COPILOT and =AI Functions: Row-Level Text Work and Its Limits
2
Module 2: Analysis Without Code
Deeper analysis and cleanup with AI assistance.3 lessons
Python in Excel for Questions Beyond Pivot Tables
Gemini in Google Sheets: Building and Editing Spreadsheets from a Prompt
Cleaning Messy Exports: Splits, Lookups and Deduplication
3
Module 3: Power BI with Copilot
Reports, Q&A and the semantic model that makes them accurate.3 lessons
Copilot in Power BI: Report Pages, Summaries and Questions
Preparing a Semantic Model for Copilot: Names, Descriptions and Synonyms
Fabric Data Agents for Questions Across Your Data
4
Module 4: Tableau with AI
Tableau's assistants and metrics layer.2 lessons
Tableau Agent in Desktop, Cloud and Prep
Tableau Pulse Metrics and Tableau Next on Salesforce Data 360
5
Module 5: Trusting the Numbers
Verification, access controls and knowing when to escalate.3 lessons
Checking AI Answers Against Totals, Filters and Metric Definitions
Sensitivity Labels, Row-Level Security and What Copilot Can See
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.
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.
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.
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.