Excel files with Python

Use Excel spreadsheets with Python

4.36 (217 reviews)
Udemy
platform
English
language
Data Science
category
Frank Anemaet
instructor
Excel files with Python
34,853
students
31 mins
content
Jul 2021
last update
$27.99
regular price

What you will learn

How to use Excel files with Python

Read/Write Excel files with code

Create charts from code

Why take this course?

Excel a widely available program belonging to the Microsoft Office software suite, used for creating and plotting spreadsheets. The format used by Excel is xls or xlsx. As office suite you can use Excel, LibreOffice, Google Sheets or any of the other office programs. The focus of this course is on Python with Excel, not on the office suite. This works on any platform including Apple Mac OS X, Microsoft Windows and Linux. 

In this course you will learn how to use Python for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files. It allows to read and write the whole essense of Excel files without limitation. Reading Excel files (both .xlsx and the legacy .xls format); writing Excel files in both legacy .xls format or the new .xlsx format; reading cell values;

After completing this course you can create Excel files from code, read Excel files with Python, add images to your Excel file from code, create all kinds of charts and more.

This is an intermediate level course that teaches you how to work with Excel in Python (openpyxl). You should already know the basics of the Python programming language before starting this course.

You should use the latest Python version, version Python 3.9.5 is used in the course.

Screenshots

Excel files with Python - Screenshot_01Excel files with Python - Screenshot_02Excel files with Python - Screenshot_03Excel files with Python - Screenshot_04

Reviews

Conde
February 17, 2023
Breve, específico y deja lo necesario para practicar por uno mismo, a mi me aburren los cursos que exigen las practicas con un problema en particular e igual es necesario buscar documentación extra, aquí tengo la libertad de aplicar lo aprendido en proyectos del trabajo o practicas de capacitación, con temas que me interesan pero conociendo las bases.
Paul
December 29, 2022
Missed an opportunity to use some more practical real world examples rather than just demonstrating how each command works.
David
September 8, 2022
The close caption is sometimes confusing, but the course is easy and practical. It's encouraging to learn more :)
Badr-eddine
August 29, 2022
tbh honnest i hoped to learn how i could not overwrite but add data ,also how to handle big excel tables, on the bright side it gives you an idea how to exploit excel files for beginners and how to create simple charts which is beneficial
Hrishikesh
August 24, 2022
Good introductory tutorials for beginners while working with excel. Nicely explained along with actual hands on material.
Luis
July 16, 2022
Muy buen curso, resolvio varias dudas que tenia, aunque podria aumentar un poco el contenido porque esta muy corto.
Elvis
April 13, 2022
Excellent course of Excel with Python, the videos are short but contain the most important element to use.

Charts

Price

Excel files with Python - Price chart

Rating

Excel files with Python - Ratings chart

Enrollment distribution

Excel files with Python - Distribution chart

Related Topics

Python
4178604
udemy ID
7/11/2021
course created date
7/16/2021
course indexed date
Bot
course submited by