Accounting Audit Exclusive AI Practical Training Camp - Updated: Python+Claude Code+VBA, Excel/PDF/Word Automation Full Process

Course Introduction

This course systematically explains the full process of AI automation application development in the financial audit field. The course covers environment installation, PDF scripts, command line simulation, dependencies and virtual environment, GUI interface, JSON persistence, Git and README, PDF toolbox, packaging exe, Claude Code connecting DeepSeek, Excel processing two modes (AI operating Excel/console application/Excel toolbox), Skill optimizing UI interface, Codex App connecting DS, AGENTS.md and CLAUDE.md work rules, Word processing and toolbox integration, API getting exchange rate and report data, Markdown, Mineru document parsing, webpage beautification and website publishing, AI contract extraction tool, Agent tools and fixed code boundaries, VBA basics (macro/ribbon design/button implementation/dropdown menu/input box/checkbox/VBA form/code encryption) and 15 add-on practices (Round format/extract characters/clear non-formula/relative to absolute/generate catalog/break link delete sheet/show hide sheet/rename/split workbook/one-click format/merge split button/batch rename/package release), Agent introduction, Skill writing, Excel Agent assistant usage, AI generated report slides HTML version. From Python to VBA, from desktop application to website publishing, one-stop master financial audit AI automation.

Suitable Learners

1. Finance/audit practitioners wanting to use AI to improve work efficiency
2. Workplace people needing automated Excel/PDF/Word processing
3. Zero-base newcomers wanting to learn AI programming and Agent applications
4. Tech enthusiasts hoping to develop financial audit automation tools
5. Developers wanting to systematically master AI implementation from Python to VBA

Learning Outcomes

1. Master Python environment setup and PDF/Excel/Word automation processing
2. Learn Claude Code and Codex App connecting DeepSeek
3. Master Skill writing and Agent tool design
4. Master VBA add-on development and 15 practical functions
5. Independently develop website applications and AI contract extraction tools

Course Catalog:
01. Preface
02. Install Environment
03. First PDF Script
04. Simulate AI - Command Line
05. Dependencies, Virtual Environment
06. GUI Interface
07. JSON Persistence Configuration
08. Understand Git, README
09. PDF Toolbox
10. Package exe
11. Install Claude Code, Connect DS
12. Excel Processing Two Modes
13. Understand AI Operating Excel Process
14. An Excel Processing Support Case - Console Application
15. Excel Toolbox - 1
16. Excel Toolbox - 2
17. Skill Introduction, Use Skill to Optimize UI Interface
18. Install Codex App, Connect DS
19. AGENTS.md and CLAUDE.md Establish Work Rules
20. Word Processing Methods
21. Word Toolbox Integration
22. Understand API, Get Exchange Rate Data
23. AKS Get Report Data
24. Understand Markdown
25. Parse Document via API Calling Mineru
26. Beautify Interface in Webpage Form
27. Publish Tool as Website
28. Review Full Process
29. Review - Build a Web Application from Scratch
30. Connect AI Capability - AI Contract Extraction Tool
31. Agent Tools and Fixed Code Boundaries
32. CPAH Agent Tool Design
33. VBA Intro Course, How to Choose Between VBA and Python
34. VBA Introduction, How Macro Buttons Run
35. VBA Basics Practice - Two Ways to Run AI-written Code
36. Excel Ribbon Design Overview
37. Ribbon Button Implementation Principle
38. AI Completes Ribbon Button Implementation
39. Put Buttons into Menu
40. Use Dropdown Menu to Save State
41. Input Box and Checkbox Add Interaction Logic
42. Make Add-on Effective for All Workbooks
43. Functions into VBA Form
44. VBA Encryption - Protect Your Code
45. Add-on Practice 1 - Round Format, Extract Characters, Clear Non-formula
46. Add-on Practice 2 - Relative to Absolute, Batch Replace Links
47. Add-on Practice 3 - Generate Catalog, Save As Sheet
48. Add-on Practice 4 - Break Link Delete Sheet, Show Hide Sheet
49. Add-on Practice 5 - Rename, Split Workbook
50. Add-on Practice 6 - One-click Format
51. Add-on Practice 7 - Merge Buttons into Split Button
52. Add-on Practice 8 - Batch Rename, Package Release Add-on
53. Agent Introduction Overview
54. What is SKILL, How to Use and Write
55. Excel Agent Assistant Usage
56. How to Make AI Generate Report Slides (HTML Version)
57. Why Does "Hello" Also Cost Tens of Thousands of Tokens for Agent?
58. How to Choose Agent Software
59. Agent Takes Over Browser to Operate Xiaohongshu
60. Use Agent to Build First Local Knowledge Base
61. LLM-Wiki Build Your Own AI Knowledge Base