Python for Accountants: Automation and Analysis
Python basics for reading, cleaning and analysing accounting files, and automating repetitive tasks.
Course contents
- 1Python basics
- 2The pandas library for reading Excel files
- 3Cleaning and merging data
- 4Automated reports
- 5Writing code with AI assistance
- 6Building a small Python accounting program with AI: an entries database and ledger reports
- 7Developing a simple point-of-sale system with AI assistants: items, stock, invoices and the daily sales report
What you gain from the course
You can write simple scripts that automate your repetitive tasks and analyse large files.
Other courses in the same track
Excel and data
AI in Excel for Accountants
The AI tools available in and alongside Excel, and using them for an accountant’s tasks.
Writing Formulas and Macros with AI Assistance
Describing what is needed in words and getting the formula or macro, then testing it before relying on it.
Analysing Financial Data without Programming
Analysing financial data and drawing conclusions with tools that need no code.
Power BI and AI in Financial Reporting
Building interactive financial reports in Power BI and using its AI features for analysis.
Smart Financial Dashboards
Dashboards that present financial indicators and flag unusual changes.