TGx:Udemy - Control Excel with Python & OpenPyXL

Hot Picks

New TV

First Cam

New Movies

1080p x265

Misc

Torrent details for "Udemy - Control Excel with Python & OpenPyXL" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Udemy - Control Excel with Python & OpenPyXL

Controls:

Report Torrent

Torrent verified by tutsnode

Category:

Other > Training

Language:

English

Total Size:

2.91 GB

Info Hash:

9e0aea716e3aa179ad0bc65e99f2c2a0387d92a5

Added By:

tutsnode

Added:

11-12-2020 04:21

Views:

632

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

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

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