数据科学 101-Python 和 Excel
上次更新时间：2024-10-29
课程售价: 2.9 元
联系右侧微信客服充值或购买课程
课程内容
1 - Introduction
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
5 - Excel Functions
6 - Excel Visualizations
7 - Excel Case Study
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
课程内容
8个章节 , 81个讲座
1 - Introduction
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
5 - Excel Functions
6 - Excel Visualizations
7 - Excel Case Study
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