|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-for-accountants/
课程评论：没有评论
课程名称：Python会计师：自动化会计！ 课程概述：这是一个面向初学者的Python会计师课程，旨在教会学员如何自动化四个会计项目：通过自动提取股票数据优化股票市场分析、使用常见的数据分析技术自动生成Excel销售报告和数据清洗报告、从Binance自动提取加密货币数据，以及通过API和推送通知自动接收股票或加密货币价格提醒。该课程适合希望以简单易懂方式学习Python的会计师，课程避免了初学者可能感到困惑的技术术语。学员将在四个真实的金融项目中练习所学技能，从而理解Python的相关性。课程的内容总结了我在四大会计师事务所工作超过10年的经验，持续时间为3小时，相信你会喜欢，因为我在工作中使用的所有内容都包含在课程中！请观看课程预览了解更多信息并开始学习！ 章节概述： 第一章：快速介绍我自己以及课程内容。 第二章：讲解Python的基本语法和基础知识。例如，如果你喜欢阅读小说并想写一本书，那么在写作之前你需要学习语法、句法和风格指南，编程也是如此。本章包括：Python安装与课程文件下载、使用代码编辑器（IDLE）与打印函数、算术运算符、比较运算符、变量与数据类型、代码文档、条件语句、F-字符串、列表、for循环、文件的打开与保存、自定义函数、标准库、while循环、第三方库以及安装Pandas。之后，我们将应用所学知识解决第一个真实案例：Python股票分析，主要是使用Yahoo Finance/YFinance库将股票市场数据提取到电子表格中。 第三章：介绍Jupyter Notebooks。我们将代码编辑器升级到功能更强大的Jupyter Notebook。 第四章：使用Pandas库教授基本的数据分析技术，这对每位会计师而言至关重要。这一章是Excel自动化的核心。你将学习诸如：添加和删除列、数据排序、数据筛选、去重、格式化、数据透视表、导出为CSV和Excel，以及定位/条件函数等技术。随后，我们将通过自动化两个案例来巩固学习：超市销售报告——将大量销售数据聚合到数据透视表中只需几行代码，以及数据清洗案例，即修复不良数据。 第五章：API的一般概述。我将解释什么是API，如何连接API，以及Get请求和Post请求之间的区别。我们将以Binance API为示例，通过该API学习如何自动提取加密货币价格到Python脚本或Excel电子表格中。最后，我们将通过一个综合案例来结束这一章，该案例结合了课程中学到的所有知识——使用Telegram应用程序（Android/iOS）和Telegram API将股票市场提醒、消息和推送通知发送到我们的手机上。
This is 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, andAutomate 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 1A quick introduction about me, and what this course covers.Chapter 2Explains 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 3An 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 4Teaches 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 5A 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.
