Automate Excel with Python using OpenPyXL

Focused View

Andrei Dumitrescu

52:00

781 View

01 Welcome.mp4

01:19

02 Setup the Environment. Installing OpenPyXL.mp4

04:22

03 Excel Basics.mp4

02:29

04 Reading Excel Files.mp4

08:43

05 Reading Data in a Cell Range.mp4

06:18

06 Writing Excel Files.mp4

04:48

07 Creating New Excel Files.mp4

02:54

08 Using Excel Formulas.mp4

04:23

09 Sheets Operations.mp4

06:18

10 Working with Styles.mp4

10:26

salaries.xlsx.zip

store.xlsx.zip

Description

009a68fd

In this course you'll get the skills to automate Excel with the Power of Python!

Using OpenPyXL module you will learn how to read and write Excel Files, work with sheets and styles.

Since this is intermediate Python you are required to already master the basics of Python before enrolling into this class. My advice is to first check my other classes on Python published here on SkillShare; they will help you build a strong foundation of Python Programming Language.

In this course we'll get the skills to get ahead!

Major topics of this Python and Excel course:

Setup the Environment. Installing OpenPyXL
Excel Basics
Reading Excel Documents
Reading Data in a Cell Range
Writing Excel Files
Creating New Excel Files
Using Excel Formulas
Sheets Operations
Working with Styles

and more!

Excel file used in the course: https://drive.google.com/open?id=1NANQ_sVqWK1d-JvE9B3Zd9ZKxpQxAG8K

What You'll Learn?

Technology
Python
Excel
Microsoft Excel
Data Science
Development Tools
Basic Reading

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Automation

Excel

Andrei Dumitrescu

Instructor's Courses

I've been a Network and Software Engineer for over 15 years, the typical profile of a DevOps Engineer.

I've cofounded Crystal Mind Academy, a Cisco Academy and professional training center in Romania, that focuses on teaching cutting-edge technologies to students.

I have contributed to education in areas of programming, information security and operating systems. During the last 12 years more than 20,000 thousand students have participated in-person or online training programs at Crystal Mind Academy.

I have developed documentation, labs and case studies for many training programs such as Cisco CCNA, CCNA Security, CCNP, Linux Administration, Information Security, Python Programming, Network Automation with Python or Blockchain Programming (Ethereum/Solidity) which have been successfully attended by thousands over the years.

When I'm not working, I crossfit, read a good book, enjoy a good time or travel with my wife and children.

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.