Udemy - Control Excel with Python & OpenPyXL
movies, software, shows...
Files
| TutsNode.com.txt | 63 B | ||
| [TGx]Downloaded from torrentgalaxy.to .txt | 585 B | ||
| [TutsNode.com] - Control Excel with Python & OpenPyXL | |||
| 01 Introduction | |||
| 001 Welcome to the course!.en.srt | 2.28 KB | ||
| 001 Welcome to the course!.mp4 | 47.91 MB | ||
| 002 Getting started.en.srt | 586 B | ||
| 002 Getting started.mp4 | 13.36 MB | ||
| 003 Installing OpenPyXL.en.srt | 2.04 KB | ||
| 003 Installing OpenPyXL.mp4 | 27.53 MB | ||
| 004 Reading the documentation.en.srt | 1.76 KB | ||
| 004 Reading the documentation.mp4 | 24.66 MB | ||
| 005 Be careful with your workbooks, always backup!.en.srt | 1.15 KB | ||
| 005 Be careful with your workbooks, always backup!.mp4 | 16.51 MB | ||
| external-assets-links.txt | 118 B | ||
| 02 Using OpenPyXL, Workbooks and Sheets | |||
| 006 Workbooks and Sheets introduction.en.srt | 672 B | ||
| 006 Workbooks and Sheets introduction.mp4 | 11.8 MB | ||
| 007 2.1-Creating-workbooks.py | 350 B | ||
| 007 Creating Workbooks.en.srt | 1.02 KB | ||
| 007 Creating Workbooks.mp4 | 19.01 MB | ||
| 008 2.2-Opening-workbooks.py | 339 B | ||
| 008 Opening Workbooks.en.srt | 1.37 KB | ||
| 008 Opening Workbooks.mp4 | 23.79 MB | ||
| 009 2.3-Writing-and-saving-to-sheets.py | 1.01 KB | ||
| 009 Writing and saving to Sheets, Creating and Deleting Sheets.en.srt | 4.61 KB | ||
| 009 Writing and saving to Sheets, Creating and Deleting Sheets.mp4 | 75.03 MB | ||
| 010 2.4-Copying-sheets.py | 603 B | ||
| 010 Copying Sheets.en.srt | 2.4 KB | ||
| 010 Copying Sheets.mp4 | 46.93 MB | ||
| 011 2.5-Get-sheet-by-index-or-name.py | 801 B | ||
| 011 Getting sheet by index and name.en.srt | 2.81 KB | ||
| 011 Getting sheet by index and name.mp4 | 53.67 MB | ||
| 012 2.6-Summary-functions.py | 1.71 KB | ||
| 012 Workbooks and Sheets Summary.en.srt | 4.52 KB | ||
| 012 Workbooks and Sheets Summary.mp4 | 82.41 MB | ||
| 03 Reading data from Cells | |||
| 013 Reading cells introduction.en.srt | 901 B | ||
| 013 Reading cells introduction.mp4 | 22.09 MB | ||
| 014 3.1-Absolute-relative-referencing.py | 1.19 KB | ||
| 014 Reading Cells with absolute and relative referencing.en.srt | 5.58 KB | ||
| 014 Reading Cells with absolute and relative referencing.mp4 | 109.72 MB | ||
| 015 3.2-Offset.py | 1023 B | ||
| 015 Offset.en.srt | 4.58 KB | ||
| 015 Offset.mp4 | 86.2 MB | ||
| 016 3.3-Reading-a-range-of-cells.py | 1.41 KB | ||
| 016 Reading a Range of Cells.en.srt | 2.94 KB | ||
| 016 Reading a Range of Cells.mp4 | 43.41 MB | ||
| 04 Iterating over Cells | |||
| 017 Iterating over Cells introduction.en.srt | 602 B | ||
| 017 Iterating over Cells introduction.mp4 | 13.21 MB | ||
| 018 4.1-Looping-over-cells.py | 499 B | ||
| 018 Looping over Cells.en.srt | 1.86 KB | ||
| 018 Looping over Cells.mp4 | 31.67 MB | ||
| 019 4.2-Iter-row-iter-cols.py | 1 KB | ||
| 019 iter_rows and iter_cols.en.srt | 4.8 KB | ||
| 019 iter_rows and iter_cols.mp4 | 75.55 MB | ||
| 020 4.3-max-row-max-column.py | 887 B | ||
| 020 max_row and max_col.en.srt | 3.81 KB | ||
| 020 max_row and max_col.mp4 | 65.17 MB | ||
| 05 Manipulating Cells | |||
| 021 Manipulating Cells introduction.en.srt | 403 B | ||
| 021 Manipulating Cells introduction.mp4 | 9.74 MB | ||
| 022 5.1-Deleting-inserting-rows-cols.py | 1.63 KB | ||
| 022 Deleting and inserting rows and columns.en.srt | 7.66 KB | ||
| 022 Deleting and inserting rows and columns.mp4 | 118.33 MB | ||
| 023 5.2-Append-rows.py | 1.02 KB | ||
| 023 The append method for rows.en.srt | 4.02 KB | ||
| 023 The append method for rows.mp4 | 66.16 MB | ||
| 024 5.3-Moving-ranges-of-cells.py | 1.63 KB | ||
| 024 Moving and copying Ranges of Cells.en.srt | 7.13 KB | ||
| 024 Moving and copying Ranges of Cells.mp4 | 121.96 MB | ||
| 025 5.4-Inserting-formulas.py | 1.42 KB | ||
| 025 Inserting formulas.en.srt | 4.86 KB | ||
| 025 Inserting formulas.mp4 | 90.14 MB | ||
| 026 5.5-Creating-tables.py | 1.44 KB | ||
| 026 Tables.en.srt | 4.65 KB | ||
| 026 Tables.mp4 | 86.6 MB | ||
| 027 Halfway through!.en.srt | 630 B | ||
| 027 Halfway through!.mp4 | 10.88 MB | ||
| 06 Formatting and Filtering | |||
| 028 Formatting & filtering introduction.en.srt | 765 B | ||
| 028 Formatting & filtering introduction.mp4 | 15.07 MB | ||
| 029 6.1-Cell-formatting.py | 3.15 KB | ||
| 029 Formatting cells, fonts, colors, cell type (date, text etc).en.srt | 17.44 KB | ||
| 029 Formatting cells, fonts, colors, cell type (date, text etc).mp4 | 278.54 MB | ||
| 030 6.2-Copying-formatting.py | 1.63 KB | ||
| 030 Copying cell formatting.en.srt | 3.11 KB | ||
| 030 Copying cell formatting.mp4 | 54.52 MB | ||
| 031 6.3-Merge-cells.py | 1.06 KB | ||
| 031 Merge and unmerge cells.en.srt | 5.06 KB | ||
| 031 Merge and unmerge cells.mp4 | 84.35 MB | ||
| 032 6.4-Autofilter.py | 1.11 KB | ||
| 032 6.4-resources.py | 423 B | ||
| 032 Autofilter.en.srt | 5.43 KB | ||
| 032 Autofilter.mp4 | 91.69 MB | ||
| 033 6.5-Freeze-panes.py | 750 B | ||
| 033 Freeze panes.en.srt | 3.01 KB | ||
| 033 Freeze panes.mp4 | 54.58 MB | ||
| 034 6.6-Page-setup.py | 1.18 KB | ||
| 034 Page setup.en.srt | 7.38 KB | ||
| 034 Page setup.mp4 | 105.46 MB | ||
| 034 fittToWidth-Height-Page.txt | 639 B | ||
| 035 6.7-Fold-outline.py | 376 B | ||
| 035 Fold.en.srt | 4.22 KB | ||
| 035 Fold.mp4 | 74.7 MB | ||
| 07 Visuals | |||
| 036 Visuals introduction.en.srt | 490 B | ||
| 036 Visuals introduction.mp4 | 9.83 MB | ||
| 037 7.1-Charts.py | 2.7 KB | ||
| 037 Creating charts.en.srt | 12.5 KB | ||
| 037 Creating charts.mp4 | 205.77 MB | ||
| 038 7.2-Chartsheets.py | 1.05 KB | ||
| 038 Chartsheets.en.srt | 4.81 KB | ||
| 038 Chartsheets.mp4 | 90.78 MB | ||
| 039 7.3-Inserting-images.py | 537 B | ||
| 039 Inserting Images.en.srt | 1.77 KB | ||
| 039 Inserting Images.mp4 | 32.99 MB | ||
| 039 logo.png | 5.38 KB | ||
| 08 Useful Python code with OpenPyXL | |||
| 040 Useful Python code introduction.en.srt | 719 B | ||
| 040 Useful Python code introduction.mp4 | 15.46 MB | ||
| 041 8.1-Tkinter-filedialogs.py | 1.27 KB | ||
| 041 Tkinter file dialogs.en.srt | 8.54 KB | ||
| 041 Tkinter file dialogs.mp4 | 131.19 MB | ||
| 042 8.2-Create-files-folders.py | 689 B | ||
| 042 Creating files and folders.en.srt | 5.62 KB | ||
| 042 Creating files and folders.mp4 | 83.92 MB | ||
| 043 8.3-Get-file-paths.py | 795 B | ||
| 043 Getting file path and name.en.srt | 4.96 KB | ||
| 043 Getting file path and name.mp4 | 75.67 MB | ||
| 044 8.4-Open-multiple-files.py | 335 B | ||
| 044 Opening multiple files.en.srt | 4.29 KB | ||
| 044 Opening multiple files.mp4 | 64.78 MB | ||
| 045 8.5-Timing-scripts.py | 308 B | ||
| 045 Timing your scripts.en.srt | 3.7 KB | ||
| 045 Timing your scripts.mp4 | 57.6 MB | ||
| 046 8.6-Start-Excel-for-viewing.py | 222 B | ||
| 046 Start Excel for viewing your work.en.srt | 2.33 KB | ||
| 046 Start Excel for viewing your work.mp4 | 32.88 MB | ||
| external-assets-links.txt | 130 B | ||
| 09 Conclusion | |||
| 047 Your next steps.en.srt | 1.64 KB | ||
| 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
Related Torrents
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.3 GB | freecoursewb | 1 week | 7 | 5 | |
| 592.8 MB | freecoursewb | 2 weeks | 0 | 0 | |
| 759.2 MB | freecoursewb | 3 weeks | 18 | 3 | |
| 867.9 MB | freecoursewb | 3 weeks | 15 | 2 | |
| 495 MB | freecoursewb | 3 weeks | 14 | 2 |
All Comments