数据科学 101-Python 和 Excel
- 1 - Introduction
- 1 - Introduction
- 2 - Python vs Excel
- 3 - Limitation of Excel
- 4 - Python
- 5 - who can benefit from learning Python
- 6 - What makes Python a better option than Excel
- 7 - Excel vs Python Who wins
- 3 - Introduction to Basics of Excel
- 9 - Structure of Excel sheets
- 10 - The Ribbon
- 11 - Rows and Columns
- 12 - Enter Edit Delete in Excel
- 13 - Excel basic formatting border font color
- 14 - Align Left Right Center
- 15 - Arithmetic operations
- 16 - Excel formulas introduction
- 17 - Copy and Paste
- 18 - Formatting cell
- 19 - Formatting worksheet
- 20 - Moving and selecting contents in Excel sheets
- 21 - IMPORTANT Fixing cell references
- 22 - ALTENTER
- 23 - Text to Column
- 24 - Wrap Text
- 25 - Select special
- 26 - Dynamic Naming
- 27 - Custom Formatting 1
- 28 - Custom Formatting 2
- 29 - Multiple Formats
- 4 - Excel Tools and Tips
- 30 - Macros
- 31 - Data Validation
- 32 - Sort and Filter
- 33 - Hyperlinks
- 34 - Freeze Panes
- 35 - Tell me what you want to do
- 36 - Keyboard Shortcuts
- 5 - Excel Functions
- 37 - Count countif and countifs
- 38 - Sum sumif and sumifs
- 39 - average and averageif
- 40 - Text functions
- 41 - max and min functions
- 42 - round function
- 43 - vlookup function IMPORTANT
- 44 - hlookup function
- 45 - index and match function
- 46 - iferror function
- 47 - pivot tables
- 48 - data tables
- 6 - Excel Visualizations
- 49 - Excel charts
- 50 - Basic formatting for charts
- 51 - Designing charts
- 52 - Bridge charts
- 53 - Treemap
- 54 - Spark Lines
- 7 - Excel Case Study
- 55 - Introduction to data
- 56 - Preprocessing data
- 57 - Create unique code primary key
- 58 - Creating database
- 59 - Populate database 1
- 60 - Populate database 2
- 61 - Mapping each row to category
- 62 - Income statement
- 63 - Format statement
- 64 - Format statement more
- 65 - Populate Income PL statement
- 8 - Excel Functions in Python
- 66 - vlookup function in excel
- 67 - Implement vlookup functionality in Python
- 68 - Pivot tables in excel
- 69 - Implement pivot tables functionality in Python
- 70 - Pivot tables using pandas
- 71 - IF function in Excel
- 72 - IF functionalities in python
- 73 - Text manipulation in Excel
- 74 - Text manipulation in Python
- 75 - count countif countifs sum sumif sumifs
- 76 - count countif countifs sum sumif sumifs in Python
- 9 - Python Visualizations
- 77 - pivot charts in Excel
- 78 - Python pandas visualization
- 79 - Matplotlib
- 80 - Formatting charts
- 81 - More on matplotlib
- 82 - matplotlib and pandas together