Udemy - Control Excel with Python & OpenPyXL

To download this torrent, you need a BitTorrent client: Vuze or BTGuard

Download this torrent
Download using Magnet Link

Health:

Seeds: 13
Leechers: 3
Completed: 240
Last Checked: 08-12-2021 14:09:40

Uploader Reputation points : 7860

Thanks By

Write a Review for the Uploader:	15	Say Thanks with one good review:

Share on Facebook

Details

Name:	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
YouTube Video:
Category:	Tutorials
Language:	English
Total Size:	2.91 GB
Info Hash:	9E0AEA716E3AA179AD0BC65E99F2C2A0387D92A5
Added By:	tutsnode
Date Added:	2020-12-11 12:20:57
Torrent Status:	Torrent Verified

Ratings:

Not Yet Rated (Log in to rate it)

Tracker:
udp://inferno.demonoid.pw:3391/announce

This Torrent also has backup trackers

URL	Seeders	Leechers	Completed
udp://inferno.demonoid.pw:3391/announce	0	0	0
udp://tracker.openbittorrent.com:80/announce	4	1	10
udp://tracker.opentrackr.org:1337/announce	9	1	230
udp://torrent.gresille.org:80/announce	0	0	0
udp://glotorrents.pw:6969/announce	0	0	0
udp://tracker.leechers-paradise.org:6969/announce	0	0	0
udp://tracker.pirateparty.gr:6969/announce	0	0	0
udp://tracker.coppersurfer.tk:6969/announce	0	0	0
udp://ipv4.tracker.harry.lu:80/announce	0	1	0
udp://9.rarbg.to:2710/announce	0	0	0
udp://shadowshq.yi.org:6969/announce	0	0	0
udp://tracker.zer0day.to:1337/announce	0	0	0

File List:

File	Size
TutsNode.com.txt	63.00 B
[TGx]Downloaded from torrentgalaxy.to .txt	585.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/001 Welcome to the course!.en.srt	2.28 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/001 Welcome to the course!.mp4	47.91 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/002 Getting started.en.srt	586.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/002 Getting started.mp4	13.36 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/003 Installing OpenPyXL.en.srt	2.04 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/003 Installing OpenPyXL.mp4	27.53 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/004 Reading the documentation.en.srt	1.76 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/004 Reading the documentation.mp4	24.66 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/005 Be careful with your workbooks, always backup!.en.srt	1.15 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/005 Be careful with your workbooks, always backup!.mp4	16.51 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/01 Introduction/external-assets-links.txt	118.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/006 Workbooks and Sheets introduction.en.srt	672.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/006 Workbooks and Sheets introduction.mp4	11.80 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/007 2.1-Creating-workbooks.py	350.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/007 Creating Workbooks.en.srt	1.02 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/007 Creating Workbooks.mp4	19.01 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/008 2.2-Opening-workbooks.py	339.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/008 Opening Workbooks.en.srt	1.37 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/008 Opening Workbooks.mp4	23.79 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/009 2.3-Writing-and-saving-to-sheets.py	1.01 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/009 Writing and saving to Sheets, Creating and Deleting Sheets.en.srt	4.61 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/009 Writing and saving to Sheets, Creating and Deleting Sheets.mp4	75.03 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/010 2.4-Copying-sheets.py	603.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/010 Copying Sheets.en.srt	2.40 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/010 Copying Sheets.mp4	46.93 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/011 2.5-Get-sheet-by-index-or-name.py	801.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/011 Getting sheet by index and name.en.srt	2.81 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/011 Getting sheet by index and name.mp4	53.67 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/012 2.6-Summary-functions.py	1.71 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/012 Workbooks and Sheets Summary.en.srt	4.52 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/02 Using OpenPyXL, Workbooks and Sheets/012 Workbooks and Sheets Summary.mp4	82.41 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/013 Reading cells introduction.en.srt	901.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/013 Reading cells introduction.mp4	22.09 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/014 3.1-Absolute-relative-referencing.py	1.19 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/014 Reading Cells with absolute and relative referencing.en.srt	5.58 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/014 Reading Cells with absolute and relative referencing.mp4	109.72 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/015 3.2-Offset.py	1,023.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/015 Offset.en.srt	4.58 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/015 Offset.mp4	86.20 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/016 3.3-Reading-a-range-of-cells.py	1.41 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/016 Reading a Range of Cells.en.srt	2.94 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/03 Reading data from Cells/016 Reading a Range of Cells.mp4	43.41 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/017 Iterating over Cells introduction.en.srt	602.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/017 Iterating over Cells introduction.mp4	13.21 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/018 4.1-Looping-over-cells.py	499.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/018 Looping over Cells.en.srt	1.86 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/018 Looping over Cells.mp4	31.67 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/019 4.2-Iter-row-iter-cols.py	1.00 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/019 iter_rows and iter_cols.en.srt	4.80 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/019 iter_rows and iter_cols.mp4	75.55 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/020 4.3-max-row-max-column.py	887.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/020 max_row and max_col.en.srt	3.81 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/04 Iterating over Cells/020 max_row and max_col.mp4	65.17 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/021 Manipulating Cells introduction.en.srt	403.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/021 Manipulating Cells introduction.mp4	9.74 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/022 5.1-Deleting-inserting-rows-cols.py	1.63 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/022 Deleting and inserting rows and columns.en.srt	7.66 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/022 Deleting and inserting rows and columns.mp4	118.33 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/023 5.2-Append-rows.py	1.02 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/023 The append method for rows.en.srt	4.02 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/023 The append method for rows.mp4	66.16 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/024 5.3-Moving-ranges-of-cells.py	1.63 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/024 Moving and copying Ranges of Cells.en.srt	7.13 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/024 Moving and copying Ranges of Cells.mp4	121.96 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/025 5.4-Inserting-formulas.py	1.42 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/025 Inserting formulas.en.srt	4.86 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/025 Inserting formulas.mp4	90.14 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/026 5.5-Creating-tables.py	1.44 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/026 Tables.en.srt	4.65 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/026 Tables.mp4	86.60 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/027 Halfway through!.en.srt	630.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/05 Manipulating Cells/027 Halfway through!.mp4	10.88 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/028 Formatting & filtering introduction.en.srt	765.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/028 Formatting & filtering introduction.mp4	15.07 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/029 6.1-Cell-formatting.py	3.15 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/029 Formatting cells, fonts, colors, cell type (date, text etc).en.srt	17.44 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/029 Formatting cells, fonts, colors, cell type (date, text etc).mp4	278.54 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/030 6.2-Copying-formatting.py	1.63 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/030 Copying cell formatting.en.srt	3.11 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/030 Copying cell formatting.mp4	54.52 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/031 6.3-Merge-cells.py	1.06 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/031 Merge and unmerge cells.en.srt	5.06 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/031 Merge and unmerge cells.mp4	84.35 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/032 6.4-Autofilter.py	1.11 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/032 6.4-resources.py	423.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/032 Autofilter.en.srt	5.43 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/032 Autofilter.mp4	91.69 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/033 6.5-Freeze-panes.py	750.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/033 Freeze panes.en.srt	3.01 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/033 Freeze panes.mp4	54.58 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/034 6.6-Page-setup.py	1.18 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/034 fittToWidth-Height-Page.txt	639.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/034 Page setup.en.srt	7.38 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/034 Page setup.mp4	105.46 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/035 6.7-Fold-outline.py	376.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/035 Fold.en.srt	4.22 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/06 Formatting and Filtering/035 Fold.mp4	74.70 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/036 Visuals introduction.en.srt	490.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/036 Visuals introduction.mp4	9.83 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/037 7.1-Charts.py	2.70 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/037 Creating charts.en.srt	12.50 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/037 Creating charts.mp4	205.77 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/038 7.2-Chartsheets.py	1.05 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/038 Chartsheets.en.srt	4.81 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/038 Chartsheets.mp4	90.78 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/039 7.3-Inserting-images.py	537.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/039 Inserting Images.en.srt	1.77 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/039 Inserting Images.mp4	32.99 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/07 Visuals/039 logo.png	5.38 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/040 Useful Python code introduction.en.srt	719.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/040 Useful Python code introduction.mp4	15.46 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/041 8.1-Tkinter-filedialogs.py	1.27 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/041 Tkinter file dialogs.en.srt	8.54 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/041 Tkinter file dialogs.mp4	131.19 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/042 8.2-Create-files-folders.py	689.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/042 Creating files and folders.en.srt	5.62 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/042 Creating files and folders.mp4	83.92 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/043 8.3-Get-file-paths.py	795.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/043 Getting file path and name.en.srt	4.96 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/043 Getting file path and name.mp4	75.67 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/044 8.4-Open-multiple-files.py	335.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/044 Opening multiple files.en.srt	4.29 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/044 Opening multiple files.mp4	64.78 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/045 8.5-Timing-scripts.py	308.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/045 Timing your scripts.en.srt	3.70 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/045 Timing your scripts.mp4	57.60 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/046 8.6-Start-Excel-for-viewing.py	222.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/046 Start Excel for viewing your work.en.srt	2.33 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/046 Start Excel for viewing your work.mp4	32.88 MB
[TutsNode.com] - Control Excel with Python & OpenPyXL/08 Useful Python code with OpenPyXL/external-assets-links.txt	130.00 B
[TutsNode.com] - Control Excel with Python & OpenPyXL/09 Conclusion/047 Your next steps.en.srt	1.64 kB
[TutsNode.com] - Control Excel with Python & OpenPyXL/09 Conclusion/047 Your next steps.mp4	31.17 MB

Comments
No comments still posted

MOVIES

TV

SOFTWARES / APPS

MUSIC

GAMES

BOOKS

ANIME

MOBILE APPS / GAMES

VIDEO

PICTURES

TV / MOVIE PACKS

Udemy - Control Excel with Python & OpenPyXL