Skillshare - Automate Excel with Python using OpenPyXL

seeders: 2
leechers: 0
Added 3 years ago by freecoursewb in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Skillshare - Automate Excel with Python using OpenPyXL (Size: 436.3 MB)
  01 Welcome.de.srt 1.7 KB
  01 Welcome.de.vtt 1.7 KB
  01 Welcome.en-US.srt 1.5 KB
  01 Welcome.en-US.vtt 1.5 KB
  01 Welcome.es-MX.srt 1.6 KB
  01 Welcome.es-MX.vtt 1.6 KB
  01 Welcome.fr.srt 1.7 KB
  01 Welcome.fr.vtt 1.7 KB
  01 Welcome.mp4 9.8 MB
  01 Welcome.pt.srt 1.6 KB
  01 Welcome.pt.vtt 1.6 KB
  02 Setup the Environment. Installing OpenPyXL.de.srt 5.7 KB
  02 Setup the Environment. Installing OpenPyXL.de.vtt 5.6 KB
  02 Setup the Environment. Installing OpenPyXL.en-US.srt 5.1 KB
  02 Setup the Environment. Installing OpenPyXL.en-US.vtt 5 KB
  02 Setup the Environment. Installing OpenPyXL.es-MX.srt 5.5 KB
  02 Setup the Environment. Installing OpenPyXL.es-MX.vtt 5.4 KB
  02 Setup the Environment. Installing OpenPyXL.fr.srt 5.9 KB
  02 Setup the Environment. Installing OpenPyXL.fr.vtt 5.7 KB
  02 Setup the Environment. Installing OpenPyXL.mp4 43.1 MB
  02 Setup the Environment. Installing OpenPyXL.pt.srt 5.4 KB
  02 Setup the Environment. Installing OpenPyXL.pt.vtt 5.3 KB
  03 Excel Basics.de.srt 3.4 KB
  03 Excel Basics.de.vtt 3.3 KB
  03 Excel Basics.en-US.srt 3 KB
  03 Excel Basics.en-US.vtt 3 KB
  03 Excel Basics.es-MX.srt 3.4 KB
  03 Excel Basics.es-MX.vtt 3.3 KB
  03 Excel Basics.fr.srt 3.5 KB
  03 Excel Basics.fr.vtt 3.4 KB
  03 Excel Basics.mp4 8.7 MB
  03 Excel Basics.pt.srt 3.4 KB
  03 Excel Basics.pt.vtt 3.3 KB
  04 Reading Excel Files.de.srt 9.2 KB
  04 Reading Excel Files.de.vtt 9 KB
  04 Reading Excel Files.en-US.srt 8.3 KB
  04 Reading Excel Files.en-US.vtt 8 KB
  04 Reading Excel Files.es-MX.srt 9 KB
  04 Reading Excel Files.es-MX.vtt 8.8 KB
  04 Reading Excel Files.fr.srt 9.3 KB
  04 Reading Excel Files.fr.vtt 9 KB
  04 Reading Excel Files.mp4 87 MB
  04 Reading Excel Files.pt.srt 8.7 KB
  04 Reading Excel Files.pt.vtt 8.5 KB
  05 Reading Data in a Cell Range.de.srt 6 KB
  05 Reading Data in a Cell Range.de.vtt 5.9 KB
  05 Reading Data in a Cell Range.en-US.srt 5.4 KB
  05 Reading Data in a Cell Range.en-US.vtt 5.2 KB
  05 Reading Data in a Cell Range.es-MX.srt 5.8 KB
  05 Reading Data in a Cell Range.es-MX.vtt 5.7 KB
  05 Reading Data in a Cell Range.fr.srt 6.1 KB
  05 Reading Data in a Cell Range.fr.vtt 6 KB
  05 Reading Data in a Cell Range.mp4 23.3 MB
  05 Reading Data in a Cell Range.pt.srt 5.7 KB
  05 Reading Data in a Cell Range.pt.vtt 5.6 KB
  06 Writing Excel Files.de.srt 5.3 KB
  06 Writing Excel Files.de.vtt 5.2 KB
  06 Writing Excel Files.en-US.srt 4.8 KB
  06 Writing Excel Files.en-US.vtt 4.7 KB
  06 Writing Excel Files.es-MX.srt 5.2 KB
  06 Writing Excel Files.es-MX.vtt 5.1 KB
  06 Writing Excel Files.fr.srt 5.4 KB
  06 Writing Excel Files.fr.vtt 5.3 KB
  06 Writing Excel Files.mp4 17 MB
  06 Writing Excel Files.pt.srt 5 KB
  06 Writing Excel Files.pt.vtt 4.9 KB
  07 Creating New Excel Files.de.srt 2.8 KB
  07 Creating New Excel Files.de.vtt 2.8 KB
  07 Creating New Excel Files.en-US.srt 2.6 KB
  07 Creating New Excel Files.en-US.vtt 2.5 KB
  07 Creating New Excel Files.es-MX.srt 2.8 KB
  07 Creating New Excel Files.es-MX.vtt 2.8 KB
  07 Creating New Excel Files.fr.srt 2.9 KB
  07 Creating New Excel Files.fr.vtt 2.8 KB
  07 Creating New Excel Files.mp4 27.1 MB
  07 Creating New Excel Files.pt.srt 2.7 KB
  07 Creating New Excel Files.pt.vtt 2.7 KB
  08 Using Excel Formulas.de.srt 4.7 KB
  08 Using Excel Formulas.de.vtt 4.6 KB
  08 Using Excel Formulas.en-US.srt 4.2 KB
  08 Using Excel Formulas.en-US.vtt 4.1 KB
  08 Using Excel Formulas.es-MX.srt 4.5 KB
  08 Using Excel Formulas.es-MX.vtt 4.4 KB
  08 Using Excel Formulas.fr.srt 4.8 KB
  08 Using Excel Formulas.fr.vtt 4.7 KB
  08 Using Excel Formulas.mp4 16.4 MB
  08 Using Excel Formulas.pt.srt 4.5 KB
  08 Using Excel Formulas.pt.vtt 4.4 KB
  09 Sheets Operations.de.srt 6 KB
  09 Sheets Operations.de.vtt 5.8 KB
  09 Sheets Operations.en-US.srt 5.4 KB
  09 Sheets Operations.en-US.vtt 5.2 KB
  09 Sheets Operations.es-MX.srt 5.7 KB
  09 Sheets Operations.es-MX.vtt 5.6 KB
  09 Sheets Operations.fr.srt 6 KB
  09 Sheets Operations.fr.vtt 5.9 KB
  09 Sheets Operations.mp4 78.8 MB
  09 Sheets Operations.pt.srt 5.7 KB
  09 Sheets Operations.pt.vtt 5.6 KB
  10 Working with Styles.de.srt 2.8 KB
  10 Working with Styles.de.vtt 9.9 KB
  10 Working with Styles.en-US.srt 9.3 KB
  10 Working with Styles.en-US.vtt 9 KB
  10 Working with Styles.es-MX.srt 10.1 KB
  10 Working with Styles.es-MX.vtt 9.8 KB
  10 Working with Styles.fr.srt 10.6 KB
  10 Working with Styles.fr.vtt 10.3 KB
  10 Working with Styles.mp4 124.7 MB
  10 Working with Styles.pt.srt 10.1 KB
  10 Working with Styles.pt.vtt 9.8 KB
  Bonus Resources.txt 409.6 B
  Get Bonus Downloads Here.url 204.8 B
  salaries.xlsx 5.1 KB
  store.xlsx 7.2 KB
  ▲ 114 total files

Description


Automate Excel with Python using OpenPyXL
https://CourseBoat.com

Duration: 52m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 436 MB
Genre: eLearning | Language: English

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