Python For Accountants 2022: Automate 4 Financial Projects!

Learn Python to automate: Excel reports, stock & crypto analysis, and stock price alerts to your phone!

This is a beginners Python Accounting Course that explains how to automate 4 Financial projects:

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.

Course Content

  • Introduction –> 1 lecture • 3min.
  • Python Basics / Fundamentals –> 19 lectures • 1hr 26min.
  • Jupyter Notebook –> 1 lecture • 13min.
  • Data Analytics (Pandas) –> 12 lectures • 56min.
  • APIs –> 7 lectures • 29min.
  • Outro –> 1 lecture • 1min.

Auto Draft

Requirements

  • Basic computer skills.
  • No programming experience required.
  • Basic Microsoft Excel skills ideal, but not required.

This is a beginners Python Accounting Course that explains how to automate 4 Financial projects:

  1. Streamline stock market analysis by automating stock data extraction,
  2. Automate an Excel sales report & data cleansing report using common Data Analytics techniques,
  3. Automate cryptocurrency data extraction from Binance, and
  4. Automate stock or 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 🙂

 

Please watch the Course Preview to find out more and get started!

——————–

Below is an overview of each chapter:

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.

Get Tutorial