Python Automation: Automate Mundane Tasks with Python [Video]

More Information
  • Learn how to import Excel workbooks in Python
  • Learn how to create and delete worksheets
  • Read and write individual Shells in worksheets
  • Manipulate the Excel functionality with automation
  • Add images, formulas, and charts in Excel through programming
  • Manipulate Microsoft Word files with the docx-python module and read, parse, and write PDF files from Python PyPDF2
  • Delve into web scraping with the Python Beautiful Soup library
  • Understand how to read and write file and file path

Be it at your workplace or home, you end up spending a considerable amount of time every day on mundane and repetitive tasks. Imagine all the time you’d be saving if these tasks were automated. This course will help you do just that!

With this course, you’ll learn how to automate your Excel, Word, and PDF tasks using different Python programming scripts. You’ll explore the openpyxl library, python-docx, and the PyPDF2 library with practical demonstrations.

By the end of the course, you'll have developed an understanding of how automation works and be skilled to automate your tasks confidently.

All code and supporting files are available at

  • Get to grips with Python Excel to automate your Excel tasks using the openpyxl library
  • Create new workbooks and worksheets and learn how to add charts, formulas, and images to Excel sheets
  • Manipulate Microsoft Word and PDF files using the python-docx and PyPDF2 libraries
Course Length 6 hours 58 minutes
ISBN 9781800200845
Date Of Publication 28 Feb 2020


Ankit Mistry

Ankit Mistry has completed his Master's in machine learning and artificial intelligence from IIT Kharagpur and is now working as a software developer, big data engineer at one of the leading private investment banks.