Claude AI Masterclass: Automation, Excel, Claude Code & More

Name: Claude AI Masterclass: Automation, Excel, Claude Code & More
Rating: 4.8 (23 reviews)

Master Claude AI Cowork, Claude Code & automations for Google Workspace, Windows, Excel, Canva, websites & Skills

Created byAccountech Training & Solutions

Last updated 10/2026

English

English [Auto],

What you'll learn

Set up Claude AI and connect it with Gmail, Google Drive, Google Sheets and Canva using Claude connectors
Create editable Canva designs with Claude and turn any inspirational design into an editable Canva template
Automate Gmail with Claude: bulk sort and filter emails, draft personalized replies, bulk delete and download attachments
Compile important email information into Google Sheets automatically with Claude AI
Connect Google Drive to Claude and automatically manage, rearrange and organize your Drive files
Use Claude AI for Windows automation to auto arrange, rename, consolidate and organize files and folders
Convert Google Docs to designed PDFs and auto create invoices, receipts and certificates with Claude AI
Use Claude in Excel to auto correct formulas and formatting, clean web data, fix green errors and create formulas
Build KPI reports, charts, forecasts and fully interactive Excel dashboards automatically with Claude AI
Automate accounting in Excel with Claude: bank reconciliation, payroll, expense sheets and budget variance reports
Create inventory management sheets, client follow up trackers, product summaries and Excel table of contents with AI
Send bulk personalized emails with invoices and automated payment reminders using Claude and Excel data
Set up Claude Code in VS Code and build a professional, responsive AI website using Plan Mode, motion and sticky scroll
Deploy your website on a domain with Hostinger or free hosting, and run a Claude website self audit
Master Claude Projects with files and knowledge context to automate emails, reminders and YouTube content
Use Claude Artifacts, Claude Design and Claude Skills to build tools, designs and repeatable workflows faster

Course content

1 section • 63 lectures • 6h 14m total length

Setting Up Claude Account3:12
Set up the Claude cloud account and desktop app by signing in with Google, downloading and installing the Windows client, and exploring chats, projects, and artifacts from the home screen.
How to Connect Claude to Canva to Generate Editable Designs4:55
Make Any Inspirational Design Editable in Canva With Claude3:37
Claude Can Do Everything in Excel4:56
Claude Can Do Everything in Excel - Auto Correct Formulas and Formatting7:48
How to Format and Clean Data You Copied From Web Using Claude4:20
Gmail Automation Using Claude For Bulk Sorting and Filtering Jobs8:00
Drafting Personalized Gmail Replies With Product Knowledge Using Claude10:03
How to Compile All Important Email Info to Google Sheets5:54
How to Connect Google Drive to Claude AI4:18
How to Automatically Manage and Rearrange Google Drive With Claude5:40
How to Get Claude AI Pro Version - Full Guide4:15
Google Drive Automation With Claude Chrome Extensions9:14
Windows Automation Using Claude - Auto Data Arrangement8:30
Automatic Data Consolidation with Windows Automation Using Claude AI6:09
Rearrange and Rename Files Automatically with Claude6:29
Google Docs to PDF Automation With Designing in Claude7:17
Auto Creation of Invoices Receipts and Certificates Using Claude6:09
Introduction of Using Claude in Excel2:05
Data Cleaning in Excel Using Claude10:21
How To Remove Green Errors in Data MS Excel1:49
Creating KPI Reports With Charts and Insights Automatically in Claude7:41
Advanced Prompts and Forecasting With Claude7:21
Creating Fully Functional Interactive Dashboard in Excel Using Claude6:41
Append Data in Excel Using Claude AI4:53
Automate Excel Formula Creation in Claude AI4:36
Bulk Personalized Emailing With Invoices in Claude Excel8:12
Consolidating Multiple Excel Workbooks into a Multi-Sheet File via Claude2:32
Automatically Build a Table of Contents in Excel with Claude AI2:31
Creating Product Summary Sheets in Excel Using Claude2:41
Automatic Bank Reconciliation Using Claude7:40
Payroll Automation With Claude12:20
Expense Sheet Management With Claude2:50
Inventory Management Using Claude2:50
Inventory Management Using Claude - Part 27:52
Create Client Followup Tracker Using Claude5:02
Budget Variance Report Using Claude2:24
Setup Claude Code in VS Code6:37
Make Unrecognizable AI Website7:30
Plan the Website in Plan Mode Using Claude Code13:24
Adding Motion to the Website8:50
Batch Image Generation and Auto Application in Claude Website9:20
Adding Sticky Scroll Effect for Gallery Images on Website3:09
Make the Website Responsive4:14
Claude Website Self Audit and Scoring4:00
Watch This Before Buying Domain and Hosting1:12
Register a New Hosting and Domain For Your Website4:29
Connect Hostinger to Claude Code4:24
Installation of Node JS1:16
Complete Process to Connect Hostinger to Claude Code1:30
Deploying Website on Domain2:13
How to Get Free Domain and Hosting to Deploy Your Website7:46
Conclusion of Claude Code Web Development0:18
Introduction to Claude Project1:19
Setting up Claude Project7:43
Using Files and Documents in Claude Project for Context Reference5:27
Claude Project in Action - Send Personalized Emails From Database8:04
Automated Payment Reminder System Using Claude Project8:02
Create Youtube Thumbnails titles and Everything With Claude Project8:28
Claude Projects Conclusion1:00
Using Claude Skills to Do the Job Faster12:25
Working on Claude Artifacts7:59
Working With Claude Design20:55

Requirements

No coding or programming experience needed - everything is taught step by step from scratch
A computer (Windows or Mac) with an internet connection
A free Claude AI account (a Claude Pro plan is recommended for advanced features and is explained in the course)
Basic familiarity with Gmail, Google Drive and Microsoft Excel is helpful but not required

Description

Learn Claude AI from scratch and use it to automate real work: Gmail, Google Drive, Google Sheets, Canva, Windows files, Microsoft Excel, website building with Claude Code, Claude Projects, Artifacts, Claude Design and Claude Skills. All in one practical, step by step course.

This Complete Claude AI Masterclass is made for everyone. You don't need any coding experience. Every lecture is a hands-on project you can reuse in your own job or business, from bulk emailing with invoices to building and deploying a professional website on your own domain.

What you will learn in this Claude AI course:

Getting started with Claude: set up your Claude account, download Claude for desktop and learn how to get Claude Pro.
Canva with Claude: connect Claude to Canva to generate editable designs and turn any inspirational design into an editable Canva template.
Gmail and Google Drive automation: connect Claude with Gmail and Google Drive, bulk sort and filter emails, draft personalized replies with product knowledge, compile email info into Google Sheets, bulk delete emails, bulk download attachments and automatically manage and rearrange Google Drive.
Google Drive automation with the Claude in Chrome extension: organize and manage Drive files automatically.
Windows automation with Claude: auto arrange, rename and consolidate files and data on your computer.
Document automation: Google Docs to designed PDFs, plus automatic invoices, receipts and certificates.
Claude in Excel: auto correct formulas and formatting, clean and format data copied from the web, data cleaning, removing green errors, appending data, automatic Excel formulas, KPI reports with charts and insights, forecasting with advanced prompts and fully interactive Excel dashboards.
Accounting and business automation in Excel: bank reconciliation, payroll, expense sheets, inventory management, client follow up trackers, budget variance reports, product summary sheets, table of contents and consolidating multiple workbooks.
Bulk personalized emailing: send personalized emails with invoices and automated payment reminders.
Claude Code web development: set up Claude Code in VS Code, plan in Plan Mode, build an AI website that doesn't look AI-made, add motion and sticky scroll effects, batch generate images, make the site responsive and run a Claude self audit with scoring.
Website deployment: choose domain and hosting, connect Hostinger to Claude Code, install Node.js, deploy on your domain, and learn how to get free domain and hosting.
Claude Projects: use files and documents as context, send personalized emails from a database, build a payment reminder system and create YouTube thumbnails, titles and descriptions.
Claude Artifacts, Claude Design and Claude Skills: build interactive tools and designs, and use Skills to do repeated jobs faster.

Why take this course?

Most AI courses only teach prompting. This masterclass shows you how to use Anthropic's Claude AI as a real productivity and automation assistant. You'll save hours every week on email, files, spreadsheets, reports and content, and you'll finish with ready-to-use prompts, practice files and templates for every section.

Who is this course for? Beginners, office professionals, accountants, freelancers, business owners, content creators and anyone who wants to master Claude AI for automation and productivity.

Who this course is for:

Beginners who want to learn Claude AI from scratch and use it for real work automation
Office workers, accountants, bookkeepers and admins who want to automate Excel, Gmail and Google Drive tasks
Freelancers, entrepreneurs and small business owners who want to save hours with AI automation
Non programmers who want to build and deploy a website with Claude Code without writing code manually
Content creators and marketers who want to use Claude Projects, Artifacts, Design and Skills for faster output
Anyone moving from ChatGPT or other AI tools who wants to master Anthropic's Claude AI for productivity