Python For Accountants III – The Practical Approach

Python For Accountants III – The Practical Approach, available at $39.99, has an average rating of 4.5, with 21 lectures, 6 quizzes, based on 10 reviews, and has 84 subscribers.

You will learn about Students will Learn Python Students will learn python libraries Students will learn how to use excel like functionality using Python Students will learn visualisation using Python This course is ideal for individuals who are Beginner level Python Learner, Accounting Students and Professionals working in various domains in accounting. It is particularly useful for Beginner level Python Learner, Accounting Students and Professionals working in various domains in accounting.

Enroll now: Python For Accountants III – The Practical Approach

Summary

Title: Python For Accountants III – The Practical Approach

Price: $39.99

Average Rating: 4.5

Number of Lectures: 21

Number of Quizzes: 6

Number of Published Lectures: 21

Number of Published Quizzes: 6

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Students will Learn Python

Students will learn python libraries

Students will learn how to use excel like functionality using Python

Students will learn visualisation using Python

Who Should Attend

Beginner level Python Learner, Accounting Students and Professionals working in various domains in accounting.

Target Audiences

Beginner level Python Learner, Accounting Students and Professionals working in various domains in accounting.

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 learn

5. We will touch on the underlying belief that Pandas will replace Excel

6. We will learn various functions in Pandas that are similar to Excel

6. Few Mini Projects to see Python in Action

7. Visualisation using Matplotlib package.

Mini Projects:

1. Calculating Net Present Value of future cash flows

2. 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 Loops

If you are not comfortable with the above, please develop these basic skills from my two courses

1. Python for Accountants I

2. Python for Accountants II

Both courses are free at the moment.

 

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Introduction to Python Libraries

Lecture 3: Data Acquisition

Chapter 2: Introduction to Pandas and NumPy

Lecture 1: Introduction to Pandas and NumPy

Lecture 2: Pandas Series

Chapter 3: Is Pandas the New Excel ?

Lecture 1: Is Pandas the New Excel ? – Introduction

Lecture 2: Is Pandas the New Excel ? – Filters

Lecture 3: Is Pandas the New Excel ? – Pivot Tables

Lecture 4: Is Pandas the New Excel ? – VLOOKUP

Chapter 4: Mini Projects

Lecture 1: Cash Flow Projections

Lecture 2: Spliting Excel File for Products

Lecture 3: Auditing Listed Investment Valuation – Introduction

Lecture 4: Auditing Listed Investment Valuation

Chapter 5: Visualisation

Lecture 1: Matplotlib Introduction

Lecture 2: Prepare the Data

Lecture 3: Question 1

Lecture 4: Question 2

Lecture 5: Question 3

Lecture 6: Question 4

Lecture 7: Question 5

Lecture 8: Question 6

Instructors

Rizwan Ahmed
Experienced Finance Professional with Data Analytics Skills

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 2 votes

4 stars: 3 votes

5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!