Course Trailer
Course Overview
A beginners Python Accountants course that explains how to automate 4 Accounting projects:
- Streamline stock market analysis by automating stock data extraction,
- Automate an Excel sales report & data cleansing report using common Data Analytics techniques,
- Automate cryptocurrency data extraction from Binance, and
- Automate stock & crypto price alerts to your phone via APIs & Push notifications
This course is for Accountants who want to learn Python in an easy to follow, and straight to the point manner, whilst skipping unncessary technical jargon that can be intimidating for beginners.
Students will also be able to understand the relevance of Python by practicing their skills on 4 real-world Financial projects.
I've condensed over 10 years of my experience as a Consultant at a Big 4 into this 3 hour course which I know you'll love because I use everything in this course to automate my job 😀
Curriculum
If you'd like to try before you buy, I've made 8 videos free to give you a feel and flavour of the course.
Please click the "Preview" buttons below.
1.0 Introduction
Available in
days
days
after you enroll
2.0 Python Basics
Available in
days
days
after you enroll
- 2.1 Install Python & Download Course Files (1:42)
- 2.2 Open Code Editor & Print (2:57)
- 2.3 Arithmetic Operators (1:32)
- 2.4 Comparison Operators (1:43)
- 2.5 Variables & Datatypes (6:45)
- 2.6 Code Documentation (2:02)
- 2.7 If Statements (6:17)
- 2.8 F-String (2:13)
- 2.9 Lists (4:05)
- 2.10 For Loops (5:07)
- 2.11 Files (4:21)
- 2.12 Custom Functions (10:02)
- 2.13 Standard Libraries (5:11)
- 2.14 While Loops (4:20)
- 2.15 Third Party Libraries (4:31)
- 2.16 Install Pandas (3:29)
- 2.17 Yahoo Finance - Download Stock Data (9:51)
- 2.18 Dictionaries (5:51)
- 2.19 Debugging (3:38)
3.0 Jupyter Notebook
Available in
days
days
after you enroll
4.0 Data Analytics (Pandas)
Available in
days
days
after you enroll
- 4.1 Pandas Introduction (8:47)
- 4.2 Add & Remove Columns (2:22)
- 4.3 Filters (2:03)
- 4.4 Sort (2:50)
- 4.5 Remove Duplicates (2:30)
- 4.6 Replace (0:50)
- 4.7 Formatting (2:54)
- 4.8 Pivot Table (3:41)
- 4.9 Export To CSV & Excel (2:00)
- 4.10 Case Study 1 - Supermarket Sales Report (12:18)
- 4.11 Location Function - If Condition (5:44)
- 4.12 Case Study 2 - Data Cleansing (9:56)
5.0 APIs
Available in
days
days
after you enroll
- 5.1 API Introduction (3:23)
- 5.2 How To Find API Endpoints (3:47)
- 5.3 Use API Endpoint in our Python Script (4:44)
- 5.4 Get vs Post Requests (3:18)
- 5.5 Case Study 3 Pt 1- Stock Price Alerts via Telegram (1:01)
- 5.6 Case Study 3 Pt 2 - Stock Price Alerts via Telegram (9:06)
- 5.7 Case Study 3 Pt 3 - Stock Price Alerts via Telegram (3:51)
6.0 Outro
Available in
days
days
after you enroll