Python Excel (OpenPyXL) Programming with Coding Exercises

Course Overview

• Course Title: Python Excel (OpenPyXL) Programming with Coding Exercises
• Instructor: Dr Python
• Target Audience: Professionals across various industries, data analysts, financial professionals, programmers
• Prerequisites:
  • Basic understanding of Python programming
  • Familiarity with Excel and its basic functionalities

Curriculum Highlights

• Key Topics Covered:
  • Introduction to the openpyxl library and its functionalities
  • Creating and manipulating Excel workbooks, sheets, and cells
  • Automating data entry and calculations
  • Formatting Excel sheets, including styling cells, rows, and columns
  • Handling complex Excel functions and formulas with Python
  • Reading and writing data from/to Excel files
  • Generating dynamic reports with Python automation
• Key Skills Learned:
  • How to use the openpyxl library to automate Excel tasks efficiently
  • Techniques for creating, modifying, and formatting Excel files with Python
  • Methods for automating data entry, calculations, and report generation
  • Practical skills in handling complex Excel functions and integrating them with Python

Course Format

• Duration:
  • 2.5 hours on-demand video
  • 2 practice tests
  • Assignments
  • 10 articles
  • 1 downloadable resource
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion