New Microsoft Excel management based on Python (OPENPYXL)

The course is available for all software versions (2010, 2013, 2016, 2019, O365).

The course is designed for advanced Excel users who want to automate their regularly repetitive Excel tasks, add their own functions to existing ones, or are looking to learn the basics of machine learning, deep learning and data analysis.

Before we get started

• Python and setting up the development environment
• basic concepts needed

Python basics

• Python console - Dialogue mode
• The inevitable Hello world program.
• basic operations
• simple variables and types
• branching
• loops
• complex types (array, set, list)

Excel management

• Accessing and saving workbooks
• Reading data from an Excel workbook
• Managing worksheets (create, move, rename, delete)
• Operations with workbook data
• Writing and modifying formulas
• Managing formatting properties
• Conditional formatting
• Creating diagrams
• Display (PivotTable)
• Managing images (only if the Pillow library is available)

Overview, additional options

• Where to go in Python?
• Other Excel management libraries
• Data analysis library description
• machine learning libraries

The Computer Management and Windows course. Recommended previous MS Excel experience and at least intermediate knowledge (Excel concepts, functions, range names, spreadsheets, charting and reporting, conditional formatting, filtering). Previous experience in any programming language is a great advantage but not required.

Required software:

• Excel 2010, 2013, 2016, 2019, Office 365
• Python 3.x (3.10 or latest stable version recommended)
• OpenPyXL 3.x (3.0.9 or latest stable version recommended)
• PyCharm 2021.x (2021.3.1 or latest stable version recommended)

Also recommended:

• Pillow 9.x (9.0.0 or latest stable version recommended)
• NotePad++ 8.x (8.2 or latest stable version recommended)