course content

Course Content

Excel Mastery with Python: Unleashing the Power of Openpyxl

1. Openpyxl

IntroductionCreate WorkbookSaveLoad WorkbookCell Valuesiter_rows()Open, Edit and SaveFiltersFormulasOpenpyxl and PandasCharts

Excel Mastery with Python: Unleashing the Power of Openpyxl

FormulasFormulas

Formulas are mathematical expressions or equations that can be used to perform calculations on data in Excel worksheets. The openpyxl library in Python provides methods for creating and manipulating formulas in Excel files, allowing you to automate complex calculations and data analysis tasks using Python.

Task

  1. Add a formula in cell "P2" that will calculate the average from cell "H2" to "H100" ("=AVERAGE");
  2. Save the workbook.

Everything was clear?

Section 1. Chapter 9

Start learning today and achieve
coding mastery

  • Master Python, SQL, JavaScript & more.
  • Learn with Step-by-Step Lessons.
  • Get Ready for Real-World Projects.
  • Earn a Certificate Upon Completion.