Python in Excel for Financial Professionals

Focused View

Christian Martinez

48:59

28 View

01 - Introduction

01 - Welcome to Python in Excel.mp4

00:55

02 - What you should know.mp4

00:44

03 - Introduction to Python in Excel.mp4

01:25

02 - 1. Getting Started with Python in Excel

01 - Integration of Python in Excel.mp4

02:22

02 - Installation.mp4

02:09

03 - Introduction to basic Python functions.mp4

03:18

04 - How to use your data with Python in Excel.mp4

02:38

05 - Challenge Load three financial statements.mp4

01:17

06 - Solution Load three financial statements.mp4

01:04

03 - 2. Financial Modeling

01 - Discounted cash flow, part 1.mp4

01:42

02 - Discounted cash flow, part 2.mp4

02:54

03 - Forecasting.mp4

04:22

04 - Budgeting.mp4

02:38

05 - Other financial models.mp4

02:29

06 - Challenge Forecast sales for Company ABC.mp4

01:06

07 - Solution Forecast sales for Company ABC.mp4

01:06

04 - 3. Automation

01 - Automate consolidation of data.mp4

03:10

02 - Automate cleaning data.mp4

02:02

03 - Challenge Automation.mp4

00:38

04 - Solution Automation.mp4

01:17

05 - 4. Data Visualization

01 - Basic charts and graphs for finance.mp4

03:06

02 - Advanced charts and graphs for finance.mp4

02:46

03 - Challenge Create five graphs.mp4

00:58

04 - Solution Create five graphs.mp4

01:22

06 - Conclusion

01 - Next steps.mp4

01:31

Description

Now that Microsoft announced the integration of Python within Excel, finance professionals need to learn how to leverage this integration for data analytics, automation, and ways to improve their work. In this course, finance analytics manager Christian Martinez guides you through ways to use data analytics to enhance your analytical and modeling abilities.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Excel

Christian Martinez

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.