Workbook, worksheet, range, chart, formula, pivot table, conditional formatting, etc.

What you'll learn

OpenPyXL: Excel Object Model
OpenPyXL: Data analysis
OpenPyXL: Excel charts, conditional formatting
OpenPyXL: Pivot table

Requirements

Know python

Description

This course will teach you many things about OpenPyXL that the website of OpenPyXL, Google and ChatGPT can't tell you.Applications, workbooks, worksheets and cell rangesFormulas and functionsChartsPivot TablesConditional Formatting...OpenPyXL does not rely on Excel, suitable for software development. Lightweight and flexible, supports object models, powerful functionality, cross-platform.. The general process of using OpenPyXL includes three steps: import OpenPyXL package, data processing and quit the application.In OpenPyXL object model, the main objects include Workbook, Worksheet and Range, many related operations introduced in the course. Formulas and functions can be used with OpenPyXL easily. You can input general formulas and array formulas in the worksheet, most of the worksheet functions can be used in the forumlas.And also, OpenPyXL can be used to create many different types of charts in Excel worksheet. Please note that, these charts are Created by: Excel graphing engine, but not Matplotlib graphing engine, so, these charts can be editted easily by Excel.OpenPyXL can be used to refresh and edit existing pivot tables. Few people know these operations, and also Google and ChatGPT.OpenPyXL can also be used to create and edit conditional formattings such as data bars, color scales, icon sets, etc.

Who this course is for

Excel users, python users, etc.
Homepage:

https://www.udemy.com/course/excelpython-openpyxl-for-data-analysis-and-visualization/