Download Udemy - Control Excel with Python & OpenPyXL torrent

Udemy - Control Excel with Python & OpenPyXL

Torrent:	Udemy - Control Excel with Python & OpenPyXL
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
Downloads:	269
Category:	Other /Tutorials
Size:	2.9 GB
Show 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 files
Added:	2020-12-12 11:03:50
Language:	English
Peers:	Seeders : 29 , Leechers : 24
Release name:	Udemy - Control Excel with Python & OpenPyXL
Trackers:	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