MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (3h 8m) | Size: 1.67 GB
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
Password/解压密码www.tbtos.com
转载请注明：0daytown » Python For Accountants 2022