Udemy - Control Excel with Python & OpenPyXL

seeders: 29
leechers: 24
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 269
  • Language: English

Files

Control Excel with Python & OpenPyXL [TutsNode.com] - Control Excel with Python & OpenPyXL 06 Formatting and Filtering
  • 029 Formatting cells, fonts, colors, cell type (date, text etc).mp4 (278.5 MB)
  • 028 Formatting & filtering introduction.en.srt (0.7 KB)
  • 028 Formatting & filtering introduction.mp4 (15.1 MB)
  • 029 6.1-Cell-formatting.py (3.2 KB)
  • 029 Formatting cells, fonts, colors, cell type (date, text etc).en.srt (17.4 KB)
  • 030 6.2-Copying-formatting.py (1.6 KB)
  • 030 Copying cell formatting.en.srt (3.1 KB)
  • 030 Copying cell formatting.mp4 (54.5 MB)
  • 031 6.3-Merge-cells.py (1.1 KB)
  • 031 Merge and unmerge cells.en.srt (5.1 KB)
  • 031 Merge and unmerge cells.mp4 (84.3 MB)
  • 032 6.4-Autofilter.py (1.1 KB)
  • 032 6.4-resources.py (0.4 KB)
  • 032 Autofilter.en.srt (5.4 KB)
  • 032 Autofilter.mp4 (91.7 MB)
  • 033 6.5-Freeze-panes.py (0.7 KB)
  • 033 Freeze panes.en.srt (3.0 KB)
  • 033 Freeze panes.mp4 (54.6 MB)
  • 034 6.6-Page-setup.py (1.2 KB)
  • 034 fittToWidth-Height-Page.txt (0.6 KB)
  • 034 Page setup.en.srt (7.4 KB)
  • 034 Page setup.mp4 (105.5 MB)
  • 035 6.7-Fold-outline.py (0.4 KB)
  • 035 Fold.en.srt (4.2 KB)
  • 035 Fold.mp4 (74.7 MB)
01 Introduction
  • 001 Welcome to the course!.en.srt (2.3 KB)
  • 001 Welcome to the course!.mp4 (47.9 MB)
  • 002 Getting started.en.srt (0.6 KB)
  • 002 Getting started.mp4 (13.4 MB)
  • 003 Installing OpenPyXL.en.srt (2.0 KB)
  • 003 Installing OpenPyXL.mp4 (27.5 MB)
  • 004 Reading the documentation.en.srt (1.8 KB)
  • 004 Reading the documentation.mp4 (24.7 MB)
  • 005 Be careful with your workbooks, always backup!.en.srt (1.1 KB)
  • 005 Be careful with your workbooks, always backup!.mp4 (16.5 MB)
  • external-assets-links.txt (0.1 KB)
02 Using OpenPyXL, Workbooks and Sheets
  • 006 Workbooks and Sheets introduction.en.srt (0.7 KB)
  • 006 Workbooks and Sheets introduction.mp4 (11.8 MB)
  • 007 2.1-Creating-workbooks.py (0.3 KB)
  • 007 Creating Workbooks.en.srt (1.0 KB)
  • 007 Creating Workbooks.mp4 (19.0 MB)
  • 008 2.2-Opening-workbooks.py (0.3 KB)
  • 008 Opening Workbooks.en.srt (1.4 KB)
  • 008 Opening Workbooks.mp4 (23.8 MB)
  • 009 2.3-Writing-and-saving-to-sheets.py (1.0 KB)
  • 009 Writing and saving to Sheets, Creating and Deleting Sheets.en.srt (4.6 KB)
  • 009 Writing and saving to Sheets, Creating and Deleting Sheets.mp4 (75.0 MB)
  • 010 2.4-Copying-sheets.py (0.6 KB)
  • 010 Copying Sheets.en.srt (2.4 KB)
  • 010 Copying Sheets.mp4 (46.9 MB)
  • 011 2.5-Get-sheet-by-index-or-name.py (0.8 KB)
  • 011 Getting sheet by index and name.en.srt (2.8 KB)
  • 011 Getting sheet by index and name.mp4 (53.7 MB)
  • 012 2.6-Summary-functions.py (1.7 KB)
  • 012 Workbooks and Sheets Summary.en.srt (4.5 KB)
  • 012 Workbooks and Sheets Summary.mp4 (82.4 MB)
03 Reading data from Cells
  • 013 Reading cells introduction.en.srt (0.9 KB)
  • 013 Reading cells introduction.mp4 (22.1 MB)
  • 014 3.1-Absolute-relative-referencing.py (1.2 KB)
  • 014 Reading Cells with absolute and relative referencing.en.srt (5.6 KB)
  • 014 Reading Cells with absolute and relative referencing.mp4 (109.7 MB)
  • 015 3.2-Offset.py (1.0 KB)
  • 015 Offset.en.srt (4.6 KB)
  • 015 Offset.mp4 (86.2 MB)
  • 016 3.3-Reading-a-range-of-cells.py (1.4 KB)
  • 016 Reading a Range of Cells.en.srt (2.9 KB)
  • 016 Reading a Range of Cells.mp4 (43.4 MB)
04 Iterating over Cells
  • 017 Iterating over Cells introduction.en.srt (0.6 KB)
  • 017 Iterating over Cells introduction.mp4 (13.2 MB)
  • 018 4.1-Looping-over-cells.py (0.5 KB)
  • 018 Looping over Cells.en.srt (1.9 KB)
  • 018 Looping over Cells.mp4 (31.7 MB)
  • 019 4.2-Iter-row-iter-cols.py (1.0 KB)
  • 019 iter_rows and iter_cols.en.srt (4.8 KB)
  • 019 iter_rows and iter_cols.mp4 (75.6 MB)
  • 020 4.3-max-row-max-column.py (0.9 KB)
  • 020 max_row and max_col.en.srt (3.8 KB)
  • 020 max_row and max_col.mp4 (65.2 MB)
05 Manipulating Cells
  • 021 Manipulating Cells introduction.en.srt (0.4 KB)
  • 021 Manipulating Cells introduction.mp4 (9.7 MB)
  • 022 5.1-Deleting-inserting-rows-cols.py (1.6 KB)
  • 022 Deleting and inserting rows and columns.en.srt (7.7 KB)
  • 022 Deleting and inserting rows and columns.mp4 (118.3 MB)
  • 023 5.2-Append-rows.py (1.0 KB)
  • 023 The append method for rows.en.srt (4.0 KB)
  • 023 The append method for rows.mp4 (66.2 MB)
  • 024 5.3-Moving-ranges-of-cells.py (1.6 KB)
  • 024 Moving and copying Ranges of Cells.en.srt (7.1 KB)
  • 024 Moving and copying Ranges of Cells.mp4 (122.0 MB)
  • 025 5.4-Inserting-formulas.py (1.4 KB)
  • 025 Inserting formulas.en.srt (4.9 KB)
  • 025 Inserting formulas.mp4 (90.1 MB)
  • 026 5.5-Creating-tables.py (1.4 KB)
  • 026 Tables.en.srt (4.6 KB)
  • 026 Tables.mp4 (86.6 MB)
  • 027 Halfway through!.en.srt (0.6 KB)
  • 027 Halfway through!.mp4 (10.9 MB)
07 Visuals
  • 036 Visuals introduction.en.srt (0.5 KB)
  • 036 Visuals introduction.mp4 (9.8 MB)
  • 037 7.1-Charts.py (2.7 KB)
  • 037 Creating charts.en.srt (12.5 KB)
  • 037 Creating charts.mp4 (205.8 MB)
  • 038 7.2-Chartsheets.py (1.1 KB)
  • 038 Chartsheets.en.srt (4.8 KB)
  • 038 Chartsheets.mp4 (90.8 MB)
  • 039 7.3-Inserting-images.py (0.5 KB)
  • 039 Inserting Images.en.srt (1.8 KB)
  • 039 Inserting Images.mp4 (33.0 MB)
  • 039 logo.png

Description


Description

Become an Excel Power User – Learn how to control & automate Excel with Python and OpenPyXL

Do you have a bunch of Excel files that you need to format or put some value in a cell on each page? Do you need to create Charts on your spreadsheets or insert formulas? Maybe you just want to show off at the office! Whatever your needs, you can expect a comprehensive guide going through the nuts and bolts of how automating Excel works. The course dives straight into OpenPyXL, so you will be up and running creating and manipulating spreadsheets in no-time.

I have had so much use of OpenPyXL when dealing with spreadsheets. You can create advanced sorts and filters, insert and delete rows, copy cells, set custom formatting and much more. I even got a job based on my OpenPyXL knowledge. I am sure you will benefit from learning OpenPyXL if you have even the slightest interest in making your everyday life easier.

After taking this course you will:

Know how to create and manipulate Workbooks and Sheets
Read cell data with absolute and relative references
Iterate over cells and perform actions on each cell
Know how to delete rows and columns
Insert formulas and tables
Format your spreadsheets with fonts, colors and cell types
Understand how you could apply this knowledge to your own work
Create files and folders
Interact with open and save file dialogs

Whether it’s gaming, business, engineering, or data you’re passionate about, this course will give you everything you need for working on spreadsheets with Python. Take this course today, and begin your journey to having a full-fledged career as an Excel Power User!

Who this course is for:

Anyone interested in controlling and automating Excel with Python – with or without coding experience. People who want to get rid of manually editing hundreds of spreadsheets by hand
Especially suitable for those who would like to extract or add data on multiple spreadsheets or automate the creation of spreadsheets from input data
People who would like to know more about solving Excel problems with Python
People who would like to start consulting services by automating Excel tasks

Who this course is for:

Beginner and Intermediate Python users who want to automate Excel
Users who want to become an Excel Power User

Requirements

Basic Python Knowledge
Some kind of .xlsx viewer, like Excel or OpenOffice

Last Updated 11/2020



Download torrent
2.9 GB
seeders:29
leechers:24
Udemy - Control Excel with Python & OpenPyXL

Trackers

tracker name
udp://inferno.demonoid.pw:3391/announce
udp://tracker.openbittorrent.com:80/announce
udp://tracker.opentrackr.org:1337/announce
udp://torrent.gresille.org:80/announce
udp://glotorrents.pw:6969/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://tracker.pirateparty.gr:6969/announce
udp://tracker.coppersurfer.tk:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://9.rarbg.to:2710/announce
udp://shadowshq.yi.org:6969/announce
udp://tracker.zer0day.to:1337/announce
µTorrent compatible trackers list

Download torrent
2.9 GB
seeders:29
leechers:24
Udemy - Control Excel with Python & OpenPyXL

Torrent hash: 9E0AEA716E3AA179AD0BC65E99F2C2A0387D92A5