Duration: 3h 5m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 1.43 GBGenre: eLearning | Language: English

Welcome to Python For Accountants 2022!

This is a ~3 hour bners 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 & ing 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.




DOWNLOAD
uploadgig.com