
What this course covers, how the sections are organized by type of work, and which parts need the free or paid Claude plan.
Set your preferences in Claude so its answers match how you work, then start your first real conversations.
Use Claude to prepare for an exam with dynamic questionnaires that adapt to what you get right and wrong.
Set up a Claude Project for interview preparation and practice answering questions out loud in voice call mode.
Build an interactive dashboard as an artifact inside Claude Chat on the free plan.
Create a quiz as an artifact and share it with others through a link.
Give Claude examples of captions that worked before so it writes new captions in your style.
What the paid Claude plan adds and which features the rest of the course depends on.
Turn a report-building conversation into a reusable Claude Skill.
Import an existing Skill into Claude, edit it and update it as your needs change.
Open a SKILL md file to see how a Skill is built, and review a Skill before you import it.
Use Skills published by Anthropic and Skills built by other people in your own work.
Record a Skill from a task you do, so Claude can repeat it later.
When to use a Skill, a plain prompt or a Project, with examples of each.
What connectors are, why they matter, and how they differ from Skills, prompts and Projects.
Reach files on your computer from the Claude web and mobile apps.
Draft an email with Claude and send it through the Gmail connector.
Use Slack and Google Drive as context for Claude while planning an event.
Use an in-chat connector such as TripAdvisor without leaving the conversation.
Use the Claude in Chrome extension to take actions on websites.
Connect Claude to Google Sheets and Notion and work with the data in them.
Connect Claude to Google Slides and Gamma to build presentations from your content.
Install Claude in Excel and get it ready for the analytics project.
Introduction to the marketing analytics project and the dataset you'll work with.
Ask Claude in Excel a simple business question and check how it reaches the answer.
Fix inconsistent formatting and incorrect values in the dataset with Claude.
Build your first simple dashboard with Claude in Excel.
Create metrics and helper columns with Claude in Excel for the analysis that follows.
Carry context and workflows from one task to the next in Claude in Excel.
Build a complex dashboard with several visuals and improve its design.
Work with multiple files in Claude in Excel and build a simple data model that joins them.
Build positive and negative bar charts with Claude in Excel.
Calculate conversions and build visuals that show them, using Claude.
Ask Claude business-critical questions, let it make a call, and judge whether the answer holds up.
Find and fix data quality issues so the analysis can be trusted.
Build a final dashboard that tells a clear story with Claude.
Download the answer file and compare it with your own work on the analytics exercises.
A customer analytics use case with Claude, built around real-time data.
Create a chart of accounts with Claude.
Build a ledger with Claude and clear the entries sitting in the suspense account.
Reconcile data downloaded from government filing portals against your books, shown with a GST reconciliation.
Work with income tax return (ITR) reporting and files using Claude.
Set up a vendor onboarding process with Claude that stays dynamic and compliant.
Build a complete accounts receivable system with Claude.
Create dynamic financial statements and CFO-style reports with Claude.
Design a single slide with Claude Design.
Build a pitch deck with Claude, part 1.
Build a pitch deck with Claude, part 2, taking it to finished slides.
Manipulate data and generate synthetic datasets with Claude.
Work with more than 50 files at once to generate dynamic reports.
Kick off a product in a Claude Project and set up its memory so context carries across conversations.
Form a clear problem statement with the Double Diamond framework.
Use a power-interest grid, CATWOE and MoSCoW with Claude to shape the product vision.
Write a project brief with assumption-evidence mapping.
Set success criteria and metrics with the HEART framework.
Use screenshots as input so Claude can suggest user experience improvements, part 1.
Use screenshots as input so Claude can suggest user experience improvements, part 2.
Build personas that are backed by evidence rather than guesswork.
An overview of Claude's newer native video editing capabilities.
Create a numerical graphics system for your videos with Claude.
Add graphics and creatives and build a repeatable editing system.
Create a sound effects system for your creative assets.
Add a label asset, fix bugs and update the editing Skill.
Bring the assets together and complete the edit.
Add trend graphics to the asset.
Create a timeline asset for your video.
Improve the timeline animations.
Create a masked text layer.
Mix the audio for the final video.
Most people use Claude AI like a search box. They type a question, copy the answer, and close the tab. Meanwhile the weekly Excel report still gets rebuilt by hand, the ledger still doesn't match, and the raw footage from last Tuesday is still sitting in a folder.
This course is about the other way to use Claude: handing it the actual work and checking what comes back. Every section takes one kind of job, runs it start to finish on screen, and shows you what I typed, what Claude produced, where it went wrong and how I fixed it.
It covers Claude Chat, Claude Skills, Connectors, Claude in Excel, Claude Design, the Claude desktop app with Cowork, and Claude Code. You won't find a tour of every menu here. You'll find around 20 hours of real tasks, grouped by the kind of work you already do, so you can jump straight to your own field.
Here is what you'll work through.
Claude Chat on the free plan. You'll set your preferences so Claude answers the way you work, use it to prepare for exams with dynamic questionnaires, practise interviews inside a Claude Project using voice mode, and build two artifacts: an interactive dashboard and a quiz you can share with anyone through a link. You'll also teach Claude to write captions in your style by feeding it examples that already worked.
Claude Skills. This is where repetitive work stops being repetitive. You'll turn a report-building chat into a Skill, import and edit Skills, record a Skill, and use the ones Anthropic and other people publish. You'll open a SKILL md file and read it before importing anything, because you should know what you're asking Claude to run. The section ends with a plain answer to a question most people get wrong: when to use a Skill, a prompt or a Project.
Connectors. You'll reach files on your computer from the web and mobile apps, draft and send email through Gmail, plan an event with context from Slack and Google Drive, use an in-chat connector like TripAdvisor, take actions on websites with Claude in Chrome, and work with Google Sheets, Notion, Google Slides and Gamma.
Claude for analytics in Excel. The longest section in the course. You'll install Claude in Excel and work a marketing analytics project from a simple business question to a polished dashboard. Along the way you'll fix bad formatting and wrong values, build metrics and helper columns, join several files into a small data model, build positive and negative bar charts, calculate conversions, and catch data quality problems before they reach a chart. You'll also ask Claude business-critical questions and judge whether its answers hold up. A customer analytics use case and an answer file for the exercises are included. A separate section covers generating synthetic data and building dynamic reports from more than 50 files.
Claude for finance and accounting. You'll build a chart of accounts, create a ledger and clear the suspense account, reconcile data downloaded from government tax filing portals (shown with India's GST and ITR filings), set up a vendor onboarding process, build an accounts receivable system, and produce financial statements and CFO-style reports. The point is output you can inspect line by line, not numbers you have to take on trust.
Claude for presentations. You'll design a single slide in Claude Design, then build a pitch deck across a two-part workflow.
Claude for product managers. You'll set up a Claude Project with memory for a new product, form a problem statement with the Double Diamond framework, shape the product vision with a power-interest grid, CATWOE and MoSCoW, write a project brief with assumption-evidence mapping, set success metrics with the HEART framework, use screenshots as input for UX improvements, and build personas backed by evidence.
Claude for video editors. Two sections here. In the first you build a reusable editing system with Claude: a numerical graphics system, creative assets, a sound effects system, labels, trend graphics, timeline animations, a masked text layer and an audio mix, fixing bugs and updating the Skill as you go. In the second you edit with the Claude desktop app alone: raw footage to a final cut in 45 minutes, adding graphics, resizing for other formats, handling an hour-long video, adding motion graphics, and generating sound effects and background music in-house.
Claude Code for non-developers. You'll build a LinkedIn post scheduler with Claude Code and then test it properly, without writing the code yourself.
How it's taught. Each lecture is one task done on screen at a normal working pace. When Claude gets something wrong, the mistake stays in the video along with the fix, because that's the part you'll need on your own work. Where a section uses data, the files are included so you can follow along.
Who it's for. Analysts, marketers, finance and accounting staff, product managers, designers, presenters and video editors who already have real work on their desk and want Claude to take a share of it. It also suits non-programmers who want a first, practical look at Claude Code.
Who it isn't for. This isn't an introduction to artificial intelligence, and it isn't a software engineering course. If you want API work, model theory or advanced agent architecture, look elsewhere.
What you need. A Claude account (the free plan covers the Chat section; Skills and everything after it need a paid plan), Microsoft Excel for the analytics and finance sections, and basic comfort with files and spreadsheets. No coding.
About me. I'm KD. I've worked with data for more than 13 years, I teach data analytics and AI courses, and I run KultureHire, an education company in India that helps freshers get job-ready through job simulations. I teach the way I work: do the task on screen, say why I'm doing each step, and show what happens when things don't go to plan.
The preview lectures are open, so you can watch a few and decide whether this way of working fits you. Pick a task you repeat every week and bring it with you.