Accounting & Auditing AI Efficiency Master Course: Python Toolbox Development, Excel VBA Add-ins & Smart Agent Implementation

Course Introduction
This AI practical course for accounting and auditing professionals is tailored for finance and audit practitioners, focusing on three core skills: AI collaborative programming, Python audit tools, and Excel VBA add-ins. The course covers environment setup, script development, document processing, and data scraping from scratch, teaching you to build custom PDF, Excel, and Word audit toolboxes, packaged as desktop apps and web apps. Deep dive into Claude, Codex AI model integration, smart Agent development, skill optimization, and knowledge base building. Also systematically covers VBA macro development, ribbon customization, code encryption, and batch office automation, solving tedious repetitive accounting and auditing tasks, greatly improving work efficiency and professional competitiveness.
1.Preface
2.Install Environment
3.First PDF Script
4.Simulated AI - Command Line
5.Dependencies, Virtual Environment
6.GUI Interface
7.JSON Persistent Config
8.Git, README
9.PDF Toolbox
10.Package to EXE
11.Install Claude Code, Connect DS
12.Two Modes of Excel Processing
13.Understanding AI Excel Workflow
14.Excel Processing Support Case - Console App
15.Excel Toolbox - 1
16.Excel Toolbox - 2
17.Intro to Skill, Optimize UI with Skill
18.Install Codex App, Connect DS
19.AGENTS.md & CLAUDE.md Work Rules
20.Word Processing Methods
21.Word Toolbox Integration
22.Intro to API, Get Exchange Rate Data
23.AKS Get Report Data
24.Markdown Overview
25.Mineru Document Parsing via API
26.Beautify UI as Web Page
27.Publish Tool as Website
28.Review Full Workflow
29.Practice - Build a Web App from Scratch
30.Connect AI - AI Contract Extractor
31.Agent
32.CPAH Agent Tool Design
33.VBA Intro, VBA vs Python Choice
34.VBA Basics, How Add-in Buttons Work
35.VBA Practice - Run AI Code in Two Ways
36.Excel Ribbon Design Overview
37.Ribbon Button Implementation Principle
38.AI Implements Ribbon Buttons
39.Put Buttons in Menu
40.Save State with Dropdown Menu
41.Input Box & Checkbox Interaction Logic
42.Make Add-in Work on All Workbooks
43.Features into VBA Form
44.VBA Encrypt - Protect Your Code
45.Add-in Practice 1 - Round, Extract Chars, Clear Non-formulas
46.Add-in Practice 2 - Relative to Absolute, Batch Replace Links
47.Add-in Practice 3 - Generate TOC, Save Sheet As
48.Add-in Practice 4 - Break Link Delete Sheet, Show/Hide Sheet
49.Add-in Practice 5 - Rename, Split Workbook
50.Add-in Practice 6 - One-Click Format
51.Add-in Practice 7 - Merge Buttons into Split Button
52.Add-in Practice 8 - Batch Rename, Package & Publish Add-in
53.Agent Intro Overview
54.What is SKILL, How to Use & Write
55.Excel Agent Assistant Usage
56.How to Make AI Generate Report Slides (HTML)
57.Why Does Hello Agent Cost Tens of Thousands of Tokens?
58.How to Choose Agent Software
59.Agent Takes Over Browser - Xiaohongshu
60.Agent Knowledge Base Organization (1)