Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Claude Code with Python, Power BI, Excel, PowerPoint & Word
Role Play
New
Rating: 5.0 out of 5(24 ratings)
36 students
Created byLucas Dourado
Last updated 5/2026
English

What you'll learn

  • Set up Claude Code in VS Code, connect it to a Claude Pro account, and configure your first project
  • Use Plan Mode and CLAUDE md to give Claude structured context for complex, multi-file projects
  • Build and deploy a landing page with HTML, CSS, and JavaScript — live on GitHub Pages
  • Create a Python desktop application using PyWebView and SQLite, packaged as a standalone .exe with PyInstaller
  • Build and deploy a Flask web application with user authentication, a PostgreSQL database (Neon), and automatic CI/CD through Vercel
  • Use Claude inside Excel to clean data, build formulas, run analyses, create financial models, and generate charts
  • Create and improve PowerPoint presentations with Claude, including a multi-agent workflow that reads live data from an open Excel file
  • Summarize contracts, create study guides, and translate documents in Word
  • Connect Claude Desktop to Power BI via MCP to generate DAX measures, fix relationships, and receive dashboard recommendations
  • Use Claude Code in VS Code to directly edit Power BI PBIP files and generate a complete dashboard

Course content

7 sections47 lectures2h 34m total length
  • What We Will Build in This Course0:56
  • Before We Start: About the Course Audio0:50
  • What is Claude Code?3:12
  • What is MCP?3:35
  • What are skills?2:34
  • What are plugins?2:18
  • What are hooks?1:30
  • Subagent and agent teams2:27

Requirements

  • Basic computer skills — ability to install software and follow step-by-step instructions

Description

This course contains the use of artificial intelligence


Claude Code is Anthropic's AI coding agent that works directly inside VS Code. Instead of copying and pasting between a chat window and your editor, Claude Code reads your files, writes code, runs commands, and iterates — all from a single interface. This course walks you through exactly how to use it, from initial setup to deploying real applications and automating your Microsoft 365 workflows.


What makes this course different: you will follow six complete, working modules — each building a real output. You will not just watch someone prompt an AI. You will understand what Claude Code is doing, why it does it, and how to guide it when it goes off track.


  • Module 2 — Setup: Install and configure Claude Code from scratch: Anthropic account, Pro plan, Git, Node.js, Python, VS Code, and the Claude Code extension. Build your first project — a working calculator — in minutes.


  • Module 3 — Landing Page Project: Build a complete SaaS landing page for a fictional product called Clarity. Learn how to write an effective CLAUDE md, manage Git from within Claude Code, add scroll animations, a modal, a pricing toggle, and publish the result live on GitHub Pages.


  • Module 4 — Desktop App Project: Create a Python inventory control system with a graphical interface (PyWebView), a SQLite database, stock transaction history, and CSV export. Package it into a standalone .exe file using PyInstaller — no Python installation needed to run it.


  • Module 5 — Web App Project: Build a medical appointment scheduling platform with Flask, htmx, and a cloud PostgreSQL database (Neon). Handle user roles (doctor/patient/clinic), availability rules, appointment confirmation, and deploy the entire system to Vercel with automatic deploys on every GitHub push.


  • Module 6 — Claude with Excel, PowerPoint & Word: Use Claude's official add-ins for Microsoft 365. Clean messy data, write complex formulas, build financial models and charts in Excel. Create presentations from scratch and improve existing ones in PowerPoint — including a multi-agent demo where Claude in PowerPoint pulls live data from an open Excel file. In Word, generate a structured study guide, summarize a contract into an executive brief, and translate a financial memo while preserving technical terminology.


  • Module 7 — Claude with Power BI: Connect Claude Desktop to Power BI using the MCP (Model Context Protocol) architecture. Import a sales dataset, let Claude create 25 DAX measures and fix table relationships automatically. Then switch to Claude Code in VS Code, install a Power BI skill, and generate a full single-page dashboard by editing PBIP JSON files directly — no manual drag-and-drop required.

Who this course is for:

  • Anyone who has heard about Claude Code and wants to understand what it can actually do — without the hype