|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/python-for-accountants-iii-the-practical-approach/
课程评论：没有评论
课程名称：Python For Accountants III - The Practical Approach 概述：本课程是“会计师的Python”系列的第三部分。在前两门课程中，我们学习了Python的基础知识，而在本课程中，我们将开始看到Python在实际会计和商业情境中的应用。整个课程基于一个大型销售文件，学生将通过与商业相关的示例进行学习。 课程内容包括： 1. 拓展之前课程中学习的Python库的知识。 2. 介绍数据获取的多种方式，以及Python在这一方面的高效性，相较于传统方法的优势。 3. 本课程将介绍两个最常用的Python库NumPy和Pandas，这些库与会计最相关。 4. 将花费更多时间在Pandas上，因为学习它需要时间。 5. 提及Pandas有可能替代Excel的潜在观点。 6. 学习Pandas中与Excel相似的各种功能。 7. 通过几个迷你项目来展示Python的实际应用。 8. 使用Matplotlib包进行数据可视化。 迷你项目包括： 1. 计算未来现金流的净现值。 2. 将大型销售Excel文件拆分为按产品分类的Excel文件。 3. 自动化上市投资审计，并创建Excel工作底稿。 课程中使用的文件将被分享给学员，以便进行实践和技能发展。 先决条件： 本课程适合所有水平的学生，但需要具备基本的Python理解，包括： - 对代码编辑器/集成开发环境（尤其是Jupyter Notebook）的熟悉。 - 能够运行Python代码。 - 理解变量和数据类型的概念。 - 数据结构（如列表、字典、数据框等）的基本理解。 - 理解函数和方法。 - 能够创建自己的函数。 - 理解条件语句和循环。 如果您对上述内容不太熟悉，请先通过我的前两门课程《会计师的Python I》和《会计师的Python II》来提升这些基本技能，这两门课程目前是免费的。
This is the third course in the series of Python for Accountants. In the first two courses, we learn the basics of python; in this course, we will start to see the application of python in real-life accounting and business situations.The entire course is based on a large sales file so that students will learn through business-related examples.What we will cover in this Course.1. We will extend the knowledge of Python Libraries which we learn in previous courses.2. Various ways to acquire data and how it is efficient in python rather than traditional methods.3. Course will introduce the two most common Python libraries NumPy and Pandas, which are most relevant to accounting.4. We will spend more time on Pandas as it takes time to learn5. We will touch on the underlying belief that Pandas will replace Excel6. We will learn various functions in Pandas that are similar to Excel6. Few Mini Projects to see Python in Action7. Visualisation using Matplotlib package.Mini Projects:1. Calculating Net Present Value of future cash flows2. Splitting large sales excel files into product excel files.3. Automating listed investments audit and creating excel work paper.The files used in the course are shared so you can practice and develop this skill.Pre-requisites Though the course is designed for all levels however some basic understanding of python is required, such as- Familiarity with code editor / IDE specially Jupyter notebook - Running a python code - Understanding of the concept of variables and data types- Data structures such as List, Dictionaries, Data Frames etc.- Understanding of Functions and Methods- Creating your own function- Understanding of If/else statements and LoopsIf you are not comfortable with the above, please develop these basic skills from my two courses 1. Python for Accountants I2. Python for Accountants IIBoth courses are free at the moment.
