Python in Excel Quick Start

Focused View

Joe Marini

1:40:31

1,874 View

01 - Introduction

01 - Two great technologies together at last.mp4

00:42

02 - What you should know.mp4

01:01

03 - Getting set up.mp4

01:38

02 - 1. The Basics

01 - A simple example.mp4

07:50

02 - Python vs. Excel data types.mp4

07:00

03 - The xl() function.mp4

06:10

04 - Understanding row-order execution.mp4

04:22

05 - Debugging.mp4

05:14

06 - Challenge Basics.mp4

01:30

07 - Solution Basics.mp4

03:01

03 - 2. Working with Data

01 - Introduction to DataFrames.mp4

02:30

02 - Exploring DataFrame content.mp4

08:12

03 - Manipulating DataFrames.mp4

09:38

04 - Interoperating with Python.mp4

07:30

05 - Challenge DataFrames.mp4

02:36

06 - Solution DataFrames.mp4

03:31

04 - 3. Practical Python-in-Excel Examples

01 - Fixing dates with dateutil.mp4

04:51

02 - Generate a random sequence.mp4

04:09

03 - Scatter plot with Seaborn.mp4

04:49

04 - Create a Gantt chart.mp4

08:01

05 - Extract data with regular expressions.mp4

05:43

05 - Conclusion

01 - Next steps.mp4

00:33

Description

Are you looking to take a deeper dive into the key features and functions of Python in Excel? This hands-on course covers the basics of working with data using Python in Excel including data structures, DataFrames, functions, and more. Join instructor and industry expert Joe Marini as he prepares you to get more out of these two leading technologies by wielding their respective strengths in tandem. Along the way, test out your new skills and technical know-how in the exercise challenges at the end of each section. Throughout the course, Joe highlights a handful of practical Python-in-Excel examples such as fixing dates with dateutil, generating a random sequence, creating a scatter plot with Seaborn, creating a Gantt chart, and extracting data using regular expressions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Excel

Joe Marini

Instructor's Courses

Seasoned software industry veteran with 30 years of experience creating developer platforms and APIs, managing strategic partners, leading high-performing teams, driving developer-focused initiatives, crafting product strategy, and advocating for great technology. Deep experience delivering both technical and business presentations to large audiences. Senior Author for LinkedIn Learning with over 50 published titles, covering subjects such as Python programming, Android Development, XML and JSON data processing, Mobile Development, jQuery, and HTML5. Specialties: Strategic Partner Management; Mobile Applications; Web standards, architecture, and development; product strategy; program management; partner marketing; SDK development; writing and speaking; developer platform API development

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.