Excel Report Automation with Python

Learn to build end to end scripts for turning data into convenient excel reports
Excel Report Automation with Python
File Size :
796.72 MB
Total length :
1h 27m



Sean McOwen


Last update




Excel Report Automation with Python

What you’ll learn

Manipulate Excel data programmatically with Python: filter, sort, summarize, select cells/ranges
Automate the curation of economic data in preparation of reporting
Create scripts that facilitate automatic building of beautiful excel reports for a flexible range of inputs
Apply best design practices for python including using type hints, error checking, and more

Excel Report Automation with Python


Basic-Intermediate Experience with Python
Basic-Intermediate Experience with Pandas
No excel knowledge necessary


Welcome to the Excel Report Automation with Python course! This course is meant to be a more advanced course taken after some of the basic FinanceAndPython courses are complete. Within this course, you will learn exactly how to build scripts to automatically parse data into excel reports. Before beginning, please down the course files through github. The notebooks are also there as well if you want to follow along through them.Throughout the course, you will work on a real world project of producing an economic report on the real estate and treasury markets automatically. This project will give you hands-on experience with all the concepts and tools covered in the course, and help you develop a better understanding of how to apply them in practice. There are many industries with which this kind of skill can be applied, but especially so in the world of finance.By the end of this course, you will have a strong understanding of how to automate Excel report generation with Python, and be able to apply this knowledge to your own projects and workflows. So let’s get started and dive into the world of Excel report automation with Python! You’ll be amazed at what you can build!


Section 1: Introduction

Lecture 1 Introduction

Section 2: Yield Curve Data

Lecture 2 Treasury Curve Data Introduction

Lecture 3 Handling Dates

Lecture 4 Yield Table Creation

Lecture 5 Visualization

Section 3: Treasury Curve Report

Lecture 6 Creating our Table Writing Function

Lecture 7 Treasury Curve Report

Lecture 8 More Modifications for Our Excel Worksheet

Lecture 9 Borders and Images

Section 4: Real Estate Data

Lecture 10 Data Processing

Lecture 11 Index Operations

Lecture 12 Plotting the Real Estate Data

Lecture 13 Adjusting for Inflation

Section 5: Real Estate Report

Lecture 14 Writing the First Report Versions

Lecture 15 Adding Color Mapping

Section 6: Final Report

Lecture 16 Getting Started

Lecture 17 Data Creation

Lecture 18 Data Processing

Lecture 19 Finalizing the Report

Business Analysts looking to automate their workflow,Quants trying to build reports from their models,Hobbyists who want to be able to build excel reports

Course Information:

Udemy | English | 1h 27m | 796.72 MB
Created by: Sean McOwen

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top