https://www.skillshare.com/classes/Automate-Excel-with-Python-using-OpenPyXL/196256383
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
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.