Python For Accountants 2022

Learn Python to automate: Excel reports, stock & crypto data extraction, and send it to your phone via Push Notification
What you'll learn
Accounting Data Analytics (Data Cleansing & Spreadsheet Automation)
Stock Data Extraction
Use APIs to Extract Cryptocurrency Data
Use APIs to Send Price Alerts (Stock & Crypto) To Your Phone
Python Basics & Fundamentals
Requirements
Basic computer skills
No programming experience required
Basic Microsoft Excel skills ideal, but not required
Description
Welcome to Python For Accountants 2022!
This is a ~3 hour beginners Python Accounting Course that covers
Chapter 1
A quick introduction about me, and what this course covers.
Chapter 2
Explains basic Python syntax and fundamentals - for example, you might love reading novels and want to write a book, but before you write it, you have to learn grammar, syntax, and style guides - same thing goes with coding, and that's what this chapter is about - learning the grammar, syntax, and style guides of Python. This chapter will go through the following
- Installing Python & downloading course files,
- Using the code editor (IDLE) & print function
- Arithmetic operators,
- Comparison operators,
- Variables & datatypes,
- Code documentation,
- If statements,
- F-String,
- Lists,
- For loops,
- Opening & saving text files,
- Custom functions,
- Standard libraries,
- While loops,
- Third party libraries, and
- Installing Pandas.
We'll then apply what you've learnt in the basics to solve your first real world case study - Python stock analysis - specifically, extracting stock market data to a spreadsheet using the Yahoo Finance / YFinance library.
Chapter 3
An introduction to Jupyter Notebooks. We upgrade our code editor to Jupyter Notebook which is more powerful than IDLE (the default code editor that comes with Python).
Chapter 4
Teaches fundamental Data Analytics techniques using the Pandas library which is important for every Accountant to know. This is THE chapter for Excel automation. You'll learn techniques like
- Adding & removing columns,
- Sorting data,
- Filtering,
- Removing duplicates,
- Formatting,
- Pivot tables,
- Exporting to CSV & Excel, and
- Location / If Function.
We'll then apply those learnings by automating 2 case studies
- Supermarket sales report - we'll aggregate loads of sales data into a pivot table with just a few lines of code.
- Data Cleaning / Data Wrangling case study which is about fixing bad data.
Chapter 5
A general overview of APIs. I'll explain what is an API, how to connect to APIs, and the difference between a Get and Post Request.
We'll be using the Binance API as an example as I go through the API explanation which means you'll learn how to automatically extract cryptocurrency prices to your Python script or to an Excel spreadsheet.
We'll then finish this chapter with a case study which combines EVERYTHING we've learnt in this course - we'll use the Telegram App (Android / iOS) and Telegram API to send stock market alerts, messages, and push notifications to our phone.
Who this course is for
Accountants who want to automate: repetitive computer tasks (e.g., Excel reports), data analytics, and stock & crypto data extraction.
Accountants who are new to coding / programming
Accountants who want to learn Python quickly
Accountants who want an easy to understand Python course
Homepage