Python in Excel

Focused View

Scott Simpson

30:18

87 View

01 - Introduction

01 - Python in Excel.mp4

00:48

02 - Use cases and workflow impact.mp4

02:50

03 - How it works.mp4

03:21

02 - 1. Using Python in Excel

01 - Using Python in Excel.mp4

05:16

02 - Fixing errors and troubleshooting.mp4

03:37

03 - Using your data in Python.mp4

03:34

04 - Excel values and Python objects.mp4

02:33

05 - Using pandas DataFrames in Excel.mp4

03:19

06 - Plotting data with matplotlib and seaborn.mp4

04:29

03 - Conclusion

01 - Next steps.mp4

00:31

Description

If you work with data, you know that Excel is one of the most popular and powerful tools at your disposal. Depending on your industry or field, you may also use Python for data analysis, forecasting, running machine learning models, and more. For many people who deal with data, it’s common to use both tools in the same workflow, and moving your data between the two can be a hassle. Good news! In the new public preview of Excel, you can now use Python directly in Excel, eliminating the need to move your data between the tools. In this course, Scott Simpson explores the Python features launched in the public preview, showing you how to manage your entire data workflow directly inside an Excel worksheet. Join Scott to learn about exciting and powerful features—referencing Excel values in Python, using pandas to analyze data in an Excel worksheet, using Python plotting modules, and more—and see how you can leverage the power of Python in your Excel sheets to gain insights from your data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Excel

Scott Simpson

Instructor's Courses

I write and record video courses on Linux, Open Source, and IT topics. As an educational content producer and author with a strong technology background, I enjoy using my experience to teach others and to advance my own learning with technical projects. I strive to speak to beginner, intermediate, and advanced audiences in an engaging and informative way.

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.