Data Analysis Functions and Techniques in Microsoft Excel
大小
191.59 MB
文件数
20
Info Hash:
91C298C0AEC2BEE87A53A6EB7DABF4256F6CF209
收录时间
2025-12-13 04:47:29
更新时间
2025-12-21 05:40:45
文件列表 (20)
01. Logical and Conditional Functions/01. Microsoft Excel Data Analysis Functions Techniques.mp4
1.21 MB
01. Logical and Conditional Functions/02. Demo- The IF and IFS Logical Functions.mp4
14.63 MB
01. Logical and Conditional Functions/03. Demo- The SUMIF and COUNTIF Functions.mp4
11.31 MB
01. Logical and Conditional Functions/04. Demo- The Logical AND and OR Functions.mp4
10.74 MB
02. Lookup and Reference Functions/01. Demo- VLOOKUP in a Single Sheet.mp4
8.61 MB
02. Lookup and Reference Functions/02. Demo- VLOOKUP with Multiple Sheets and Named Ranges.mp4
13.37 MB
02. Lookup and Reference Functions/03. Demo- HLOOKUP for Row-wise Lookups.mp4
4.94 MB
02. Lookup and Reference Functions/04. Demo- Limitations of VLOOKUP.mp4
9.38 MB
02. Lookup and Reference Functions/05. Demo- Lookup Cells with INDEX.mp4
9.04 MB
02. Lookup and Reference Functions/06. Demo- Dynamic Lookup with INDEX and MATCH.mp4
9.57 MB
02. Lookup and Reference Functions/07. Demo- Multicriteria INDEX and MATCH.mp4
11.42 MB
02. Lookup and Reference Functions/08. Demo- Performing Lookups and Handling Errors with XLOOKUP.mp4
13.44 MB
02. Lookup and Reference Functions/09. Demo- Partial Matches and Row-wise Lookups with XLOOKUP.mp4
11.37 MB
02. Lookup and Reference Functions/10. Demo- Dynamic Multicriteria Lookups with Nested XLOOKUP.mp4
12.01 MB
03. Scenarios and What-if Analysis/01. Demo- Goal Seek for Break Even Analysis.mp4
6.78 MB
03. Scenarios and What-if Analysis/02. Demo- Using the Scenario Manager for What-if Analysis.mp4
10.44 MB
03. Scenarios and What-if Analysis/03. Demo- Sensitivity Analysis with Data Table.mp4
7.18 MB
04. Data Visualizations with Sparklines/01. Demo- Line and Column Sparklines.mp4
12.49 MB
04. Data Visualizations with Sparklines/02. Demo- Win-Loss Sparklines.mp4
4.89 MB
microsoft-excel-data-analysis-functions-techniques.zip
8.76 MB