| 1 - Introduction.mp4 | 30.2 MB | ||
| 10 - The Ribbon.mp4 | 32.3 MB | ||
| 11 - Rows and Columns.mp4 | 24.4 MB | ||
| 12 - Enter Edit Delete in Excel.mp4 | 36.6 MB | ||
| 13 - Excel basic formatting border font color.mp4 | 25.4 MB | ||
| 14 - Align Left Right Center.mp4 | 10.9 MB | ||
| 15 - Arithmetic operations.mp4 | 19.9 MB | ||
| 16 - Excel formulas introduction.mp4 | 41.4 MB | ||
| 17 - Copy and Paste.mp4 | 18.9 MB | ||
| 18 - Formatting cell.mp4 | 42 MB | ||
| 19 - Formatting worksheet.mp4 | 18.9 MB | ||
| 2 - Python vs Excel.mp4 | 10.1 MB | ||
| 20 - Moving and selecting contents in Excel sheets.mp4 | 53.4 MB | ||
| 21 - IMPORTANT Fixing cell references.mp4 | 63.2 MB | ||
| 22 - ALTENTER.mp4 | 12.9 MB | ||
| 23 - Text to Column.mp4 | 29.7 MB | ||
| 24 - Wrap Text.mp4 | 8 MB | ||
| 25 - Select special.mp4 | 36.8 MB | ||
| 26 - Dynamic Naming.mp4 | 18.7 MB | ||
| 27 - Custom Formatting 1.mp4 | 88.7 MB | ||
| 28 - Custom Formatting 2.mp4 | 83.1 MB | ||
| 29 - Multiple Formats.mp4 | 17.8 MB | ||
| 3 - Limitation of Excel.mp4 | 6.2 MB | ||
| 30 - Macros.mp4 | 37.5 MB | ||
| 31 - Data Validation.mp4 | 47.5 MB | ||
| 32 - Sort and Filter.mp4 | 24.6 MB | ||
| 33 - Hyperlinks.mp4 | 15.6 MB | ||
| 34 - Freeze Panes.mp4 | 27.1 MB | ||
| 35 - Tell me what you want to do.mp4 | 21.5 MB | ||
| 36 - Keyboard Shortcuts.mp4 | 84.1 MB | ||
| 37 - Count countif and countifs.mp4 | 68.7 MB | ||
| 38 - Sum sumif and sumifs.mp4 | 46 MB | ||
| 39 - average and averageif.mp4 | 25 MB | ||
| 4 - Python.mp4 | 17.5 MB | ||
| 40 - Text functions.mp4 | 44.1 MB | ||
| 41 - max and min functions.mp4 | 11.8 MB | ||
| 42 - round function.mp4 | 12.7 MB | ||
| 43 - vlookup function IMPORTANT.mp4 | 90.9 MB | ||
| 44 - hlookup function.mp4 | 27.7 MB | ||
| 45 - index and match function.mp4 | 64.3 MB | ||
| 46 - iferror function.mp4 | 19.5 MB | ||
| 47 - pivot tables.mp4 | 43.1 MB | ||
| 48 - data tables.mp4 | 14.7 MB | ||
| 49 - Excel charts.mp4 | 22.5 MB | ||
| 5 - who can benefit from learning Python.mp4 | 5.5 MB | ||
| 50 - Basic formatting for charts.mp4 | 48.9 MB | ||
| 51 - Designing charts.mp4 | 31.4 MB | ||
| 52 - Bridge charts.mp4 | 6.6 MB | ||
| 53 - Treemap.mp4 | 9.9 MB | ||
| 54 - Spark Lines.mp4 | 28.1 MB | ||
| 55 - Introduction to data.mp4 | 29.3 MB | ||
| 55 - case-study.xlsm | 48.3 KB | ||
| 56 - Preprocessing data.mp4 | 23.5 MB | ||
| 56 - case-study.xlsm | 48.3 KB | ||
| 57 - Create unique code primary key.mp4 | 36.7 MB | ||
| 57 - case-study.xlsm | 48.3 KB | ||
| 58 - Creating database.mp4 | 52.6 MB | ||
| 58 - case-study.xlsm | 48.3 KB | ||
| 59 - Populate database 1.mp4 | 143.4 MB | ||
| 59 - case-study.xlsm | 48.3 KB | ||
| 6 - What makes Python a better option than Excel.mp4 | 29.2 MB | ||
| 60 - Populate database 2.mp4 | 64.7 MB | ||
| 60 - case-study.xlsm | 48.3 KB | ||
| 61 - Mapping each row to category.mp4 | 47 MB | ||
| 61 - case-study.xlsm | 48.3 KB | ||
| 62 - Income statement.mp4 | 29.8 MB | ||
| 62 - case-study.xlsm | 48.3 KB | ||
| 63 - Format statement.mp4 | 47.7 MB | ||
| 64 - Format statement more.mp4 | 13.1 MB | ||
| 65 - Populate Income PL statement.mp4 | 47.7 MB | ||
| 65 - case-study.xlsm | 48.3 KB | ||
| 66 - vlookup function in excel.mp4 | 110.5 MB | ||
| 67 - Implement vlookup functionality in Python.mp4 | 150.3 MB | ||
| 67 - vlookup.ipynb | 53 KB | ||
| 68 - Pivot tables in excel.mp4 | 28.3 MB | ||
| 68 - sales-data.xlsx | 1.3 MB | ||
| 69 - Implement pivot tables functionality in Python.mp4 | 86.3 MB | ||
| 69 - pivot-tables.ipynb | 23.5 KB | ||
| 7 - Excel vs Python Who wins.mp4 | 11 MB | ||
| 70 - Pivot tables using pandas.mp4 | 23.1 MB | ||
| 70 - povot-tables2.ipynb | 22.9 KB | ||
| 71 - IF function in Excel.mp4 | 67.8 MB | ||
| 72 - IF functionalities in python.mp4 | 50.8 MB | ||
| 72 - IF-condition.ipynb | 50.1 KB | ||
| 73 - Text manipulation in Excel.mp4 | 210.3 MB | ||
| 74 - String-Manipulation.ipynb | 25.1 KB | ||
| 74 - Text manipulation in Python.mp4 | 76.6 MB | ||
| 75 - count countif countifs sum sumif sumifs.mp4 | 107.3 MB | ||
| 76 - count countif countifs sum sumif sumifs in Python.mp4 | 78.2 MB | ||
| 76 - sumif-and-countif.ipynb | 30 KB | ||
| 77 - pivot charts in Excel.mp4 | 72.3 MB | ||
| 77 - sales-data.xlsx | 1.3 MB | ||
| 78 - Python pandas visualization.mp4 | 51.6 MB | ||
| 78 - plots-pandas.ipynb | 227 KB | ||
| 79 - Matplotlib.mp4 | 97.8 MB | ||
| 79 - Matplotlib1.ipynb | 81.4 KB | ||
| 8 - Download Excel Lecture content.html | 204.8 B | ||
| 8 - content.xlsx | 2.1 MB | ||
| 80 - Formatting charts.mp4 | 40 MB | ||
| 80 - Matplotlib2.ipynb | 162.3 KB | ||
| 81 - Matplotlib3.ipynb | 193.3 KB | ||
| 81 - More on matplotlib.mp4 | 83.1 MB | ||
| 82 - Pandas-and-Matplotlib.ipynb | 280.4 KB | ||
| 82 - matplotlib and pandas together.mp4 | 80 MB | ||
| 9 - Structure of Excel sheets.mp4 | 21.6 MB | ||
| 9 - content.xlsx | 2.1 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| sales_data.xlsx | 1.3 MB | ||
| zipcode_income.csv | 4.8 MB | ||
| ▲ 110 total files | |||
Data Science 101: Python Plus Excel
https://DevCourseWeb.com
Published 5/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.56 GB | Duration: 8h 15m
Learn excel and python with real world case study.
What you'll learn
Write excel advanced conditional, text, and lookup functions
Excel automation using python
Learn Microsoft Excel 2016 and many of its advanced features
Learn data science skills using Python and Excel
Excel features using numpy and pandas
Visualization using Excel and Python
Requirements
Python basics (data types, loops, functions etc.)
Install Microsoft 2016, 2013 or 2010
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 274.1 MB | freecoursewb | 1 week | 17 | 1 | |
| 1.1 GB | freecoursewb | 1 week | 5 | 7 | |
| 2.9 GB | freecoursewb | 1 week | 2 | 19 | |
|
Udemy - Revit Ideate - BIM Automation, Data Management and Documents Posted by
freecoursewb in Other
|
2.4 GB | freecoursewb | 1 week | 11 | 10 |
| 952.8 MB | freecoursewb | 2 weeks | 45 | 16 |
All Comments