Claude Code & Cowork Masterclass 2026: Build AI Apps, Autonomous Agents & Business Automation with Skills, Plugins & MCP

0 of 118 lessons completed

1 Masterclass Introduction, Outcomes & Workspace Setup

Why Claude Code & Cowork Will Reshape Your 2026 Workflow 9m Course Roadmap: How the 8 Sections Build on Each Other 7m

Success Habits to Get the Most From This Masterclass

Download Course Resources, Datasets & Workspace Files

2 Claude Cowork, Skills & Plugins for Workflow Automation

What Is Claude Cowork? Concepts & Real-World Use Cases 11m

Cowork Architecture: How the Desktop Agent Operates Safely

Hands-On Demo: File Organization & Excel Skill Walkthrough

Model Context Protocol (MCP) & Connectors Explained

Hands-On Demo: Connect Gmail to Cowork & Send Smart Replies

Tokens & Context Windows: The Cost-of-Thinking Mental Model

Practice Question: Estimate Tokens for a Real Workflow

Practice Solution: Walking Through the Token Estimate

Agent Skills Deep Dive: Anatomy of a SKILL.md File

Practical Demo: Build a LinkedIn Post Skill End-to-End

Claude Plugins: Marketplaces, Install Flow & Sandboxing 7m

Data Cleaning Plugin Build — Part 1: Plugin Scaffold

Data Cleaning Plugin Build — Part 2: Pandas Steps & Validation

Data Cleaning Plugin Build — Part 3: Reports & Edge Cases

Practice Question: Pick the Right Visualization for the Data

Practice Solution: Choosing Charts for the Data Story

Data Plugin — Part 4: Statistical Analysis & PowerPoint Output

Financial Forecasting in Cowork Using Skills 14m

Build a Finance Plugin — Part 1: Inputs & Assumptions

Build a Finance Plugin — Part 2: DCF Engine & Sensitivities

Build a Finance Plugin — Part 3: Reports, Tests & Packaging

Connect Slack & Salesforce to Cowork via MCP for Cross-Tool Automation

Section Recap: Your Cowork Operator Cheat Sheet

3 Claude Chat Mastery: Research, Writing & Prompt Engineering

Research + Charts in Pure Chat: A Repeatable Pipeline

Prompt Engineering Fundamentals: Role, Goal, Constraints

Advanced Prompt Patterns: CoT, ReAct & Self-Critique

Deep Research Mode: When to Use It & How to Steer It

Long-Form Creative Writing Without the Generic AI Tone

Brainstorming Frameworks That Beat "Give Me Ideas"

Front-End Design Skill: Dashboard from a One-Line Brief

PDF → Excel + PowerPoint Financial Extraction Walkthrough

One-Pager Financial Summary with the PPTX Skill 6m

Learning Mode: Master Any Topic Faster with Claude Chat

Coding in Chat: When Chat Wins Over the IDE

Writing Workflows: Drafts, Edits & Style Locking

Image Generation: Claude vs. Gemini — Honest Comparison

4 Claude in Microsoft Excel: Data Analysis & Wall Street Modeling

Module Intro & Learning Objectives: Claude in Excel 5m

Installing & Authorizing the Claude Excel Add-In

Generating Data Insights from Raw Sheets

Statistical Summaries & Conditional Row Filters

In-Sheet Data Visualization with Claude

Sort Datasets Like a Pro Using Natural Language

Filter Datasets with Free-Form Claude Prompts

Conditional Formatting & Color-Coding via Claude

Imputing Missing Values Without Breaking the Distribution

Build Wall Street-Style Models with Cowork + Excel 11m

Discounted Cash Flow Modeling Intuition Refresher

Build a DCF in Claude Step-By-Step

Leveraged Buyout (LBO) Concepts Explained Plainly

Build an LBO Financial Model in Claude

Practice Question: Excel Data Analysis Scenario

Practice Solution: Walking Through the Analysis

5 Claude in PowerPoint: Branded Decks & Executive Reports

Module Goals & Installing the Claude PowerPoint Add-In

Generate Branded Decks from a Single Prompt

Auto-Add Speaker Notes for Every Slide

Slide Design Polish: Layout, Hierarchy & Color

Source Online Content & Re-Tone Slide Copy

Convert Long PDFs into Executive-Ready Decks

Summarize & Re-Order Existing PPTX Files

Generate Decks from a Locked Brand Template

Practice Coaching: Claude Reviews Your Delivery

Claude vs. Copilot vs. NotebookLM for Decks

6 Claude Code Foundations: Setup, Slash Commands, Skills, Hooks & Plugins

Method 1: Claude Code in the Desktop App

Method 2: Claude Code Inside VS Code (Full Setup)

Quick Reference: Mac & Windows Install Commands

The Claude Code Mental Model: The Agentic Terminal Loop

Project 1 — Landing Page with Pure Claude Code (Part A)

Skills in Claude Code: Front-End Design Skill Tour

Installing & Verifying the Front-End Design Skill

Project 1 — Landing Page Powered by Front-End Skill (Part B)

Project Skills vs. .claude Skills: Which Wins & Why

Practice Question: Pet Grooming Landing Page Brief

Practice Solution: Building the Pet Grooming Page

Slash Commands: Anatomy & Reusable Workflows 12m

Project 2 — Build a Brand Slash Command (Part 1)

Project 2 — Slash Command Logic & Arguments (Part 2)

Project 2 — Slash Command Polish & Distribution (Part 3) 15m

Practice Question: Author a Slash Command for Your Brand

Practice Solution: Slash Command Walkthrough

Claude Code Plugins: Install, Build & Share

Hooks: Automating Pre and Post Tool-Use Events

CLAUDE.md Project Memory: What Belongs There

MCP Servers in Claude Code (Local & Remote)

Subagents: Parallel Specialists for Complex Tasks

Foundations Recap & Personal Cheat Sheet

7 Claude Code for Building Full-Stack Apps

Writing a CLAUDE.md That Actually Works

Context Window Tactics: Compaction, /clear & /compact

Calorie Tracker — Phase 1: Project Init & Gemini API Key

Calorie Tracker — Phase 1: First-Run App Build

Calorie Tracker — Phase 2: Gemini AI Integration

Calorie Tracker — Phase 2: API Routes Plan

Calorie Tracker — Phase 2: API Routes Implementation

Calorie Tracker — Phase 3: Ralph Loop Plan for Quality

Calorie Tracker — Phase 3: Ralph Loop Implementation

8 Claude Code for Building Autonomous AI Agents & Multi-Agent Teams

The 2026 State of AI Agents: Where We Actually Are

Agent Anatomy 101: Loop, Tools, Memory & Goals

End-to-End Walkthrough: An Agent Doing Real Work

MCP 101 for Agent Builders: The Programmatic View

Agentic Frameworks Compared: SDKs, LangGraph, CrewAI, Direct

OpenAI Agents SDK 101: Core Primitives

Run Your First Agent with the OpenAI Agents SDK

Personal Finance Agent — Architecture Overview

Personal Finance Agent (No Memory) — Code Walkthrough

Personal Finance Agent (With Memory) — Code Walkthrough

Auto-Build Agents with Claude Code + Agents SDK — Part 1

Auto-Build Agents with Claude Code + Agents SDK — Part 2

Auto-Build Agents with Claude Code + Agents SDK — Part 3

Auto-Build Agents with Claude Code + Agents SDK — Part 4

Designing a Team of AI Agents: Roles & Handoffs

Agent Team with OpenAI SDK — Part 1: Roles & Skeleton

Agent Team with OpenAI SDK — Part 2: Tools & Knowledge

Agent Team with OpenAI SDK — Part 3: Handoffs & Routing

Agent Team with OpenAI SDK — Part 4: Orchestration & Memory

Agent Team with OpenAI SDK — Part 5: Ship, Monitor & Iterate

Back to Overview

Chapter 4 Claude in Microsoft Excel: Data Analysis & Wall Street Modeling

Build Wall Street-Style Models with Cowork + Excel

11 min read Lesson 50 / 118 Preview

Hands-on lesson covering: Build Wall Street-Style Models with Cowork + Excel. Includes a guided walkthrough, key takeaways and a downloadable resource.

← Previous → Next

Build Wall Street-Style Models with Cowork + Excel

Ready to Transform

Your Ideas?

Engr Mejba Ahmed

Hey there!

Get Full Access

Engr Mejba Ahmed

Hey there!