Using Python with Excel

Focused View

George Mount and Madecraft

56:41

127 View

01 - Introduction

01 - Managing Excel with Python.mp4

00:56

02 - 1. Python and pandas

01 - Jupyter Notebooks basics.mp4

02:32

02 - Introducing the Python pandas library.mp4

01:56

03 - Loading and saving data with pandas.mp4

03:08

04 - Viewing and inspecting data with pandas.mp4

02:38

05 - Manipulating data with pandas.mp4

03:42

06 - Working with dates and times in pandas.mp4

04:48

03 - 2. openpyxl

01 - Using openpyxl with Workbooks.mp4

03:20

02 - Selecting cells, rows, and columns.mp4

03:15

03 - Adding workbook formatting.mp4

03:38

04 - Creating names, ranges, and tables.mp4

04:28

04 - 3. Working with Reports

01 - Managing multiple sheets.mp4

04:05

02 - Working with large worksheets.mp4

04:45

03 - Conditional formatting.mp4

04:02

04 - Creating Excel plots in Python.mp4

04:29

05 - Exporting Python plots to Excel.mp4

03:47

05 - Conclusion

01 - Next steps.mp4

01:12

Description

Python is one of the world's most widely used object-oriented programming languages. It's a powerful tool that can help you streamline workflows as a developer and a data scientist. In this course, join instructor George Mount to learn how to combine the power of the Python language with the data analysis and reporting tools built into Microsoft Excel.

Discover how to leverage the pandas and openpyxl libraries to inspect, filter, clean, and convert data and how to build solid reports that help businesses take action. Learn how to work with large amounts of data that would be unmanageable in Excel alone, managing and manipulating data sets like a pro. By the end of this course, you’ll be prepared to use Python with Excel to start leading your business to better insights than ever before.

This course was created by Madecraft. We are pleased to host this training in our library.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Excel

George Mount and Madecraft

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.