Udemy Microsoft Excel Advanced Excel Formulas Functions | 54CDAB223D496E1599C28AF448AD7758636E3619

Udemy Microsoft Excel Advanced Excel Formulas Functions

Name	Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions	DOWNLOAD Copy Link
Total Size	1.6 GB
Total Files	224
Hash	54CDAB223D496E1599C28AF448AD7758636E3619

/5. LookupReference Functions/
3. ROWROWS & COLUMNCOLUMNS.vtt	0.0 KB
17. LookupReference Functions.html	0.1 KB
1. Introduction.vtt	1.8 KB
9. The INDEX Function.vtt	2.8 KB
14. The OFFSET Function.vtt	2.9 KB
10. The MATCH Function.vtt	3.1 KB
2. Working with Named Arrays.vtt	4.3 KB
18. HOMEWORK LookupReference Functions.vtt	4.8 KB
12. Combining MATCH with VLOOKUP.vtt	6.0 KB
8. NEW Fuzzy Match Lookups.vtt	6.7 KB
4. VLOOKUPHLOOKUP.vtt	7.4 KB
7. VLOOKUP Reference Array Options.vtt	7.4 KB
5. Joining Data with VLOOKUP.vtt	7.6 KB
11. Using INDEX & MATCH together.vtt	7.8 KB
16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.vtt	12.3 KB
15. Combining OFFSET with COUNTA to return a variable list.vtt	15.1 KB
6. Fixing Errors with IFERROR & VLOOKUP.vtt	22.3 KB
13. UPDATE VLOOKUP Correction.vtt	24.8 KB
1.2 Excel For Analysts Lookup Reference Functions.pdf.pdf	416.8 KB
1.1 Section_5_Lookup_Reference.xlsx.xlsx	818.4 KB
1. Introduction.mp4	2.2 MB
18. HOMEWORK LookupReference Functions.mp4	2.6 MB
9. The INDEX Function.mp4	6.5 MB
14. The OFFSET Function.mp4	7.3 MB
15. Combining OFFSET with COUNTA to return a variable list.mp4	7.3 MB
10. The MATCH Function.mp4	9.7 MB
3. ROWROWS & COLUMNCOLUMNS.mp4	10.0 MB
2. Working with Named Arrays.mp4	11.9 MB
13. UPDATE VLOOKUP Correction.mp4	15.6 MB
6. Fixing Errors with IFERROR & VLOOKUP.mp4	15.9 MB
4. VLOOKUPHLOOKUP.mp4	22.2 MB
11. Using INDEX & MATCH together.mp4	24.9 MB
12. Combining MATCH with VLOOKUP.mp4	27.9 MB
16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.mp4	31.8 MB
5. Joining Data with VLOOKUP.mp4	39.6 MB
7. VLOOKUP Reference Array Options.mp4	42.1 MB
8. NEW Fuzzy Match Lookups.mp4	48.7 MB
/6. Text Functions/
4. LEFTMIDRIGHT & LEN.vtt	0.0 KB
10. Text Functions.html	0.1 KB
1. Introduction.vtt	1.4 KB
3. The CONCATENATE Function (&).vtt	4.0 KB
2. UPPERLOWERPROPER & TRIM.vtt	4.2 KB
5. TEXTVALUE.vtt	5.0 KB
11. HOMEWORK Text Functions.vtt	5.2 KB
6. SEARCHFIND.vtt	6.3 KB
7. Categorizing Data with IF(ISNUMBER(SEARCH)).vtt	6.7 KB
8. Combining RIGHT, LEN, and SEARCH.vtt	7.0 KB
9. BONUS The SUBSTITUTE Function.vtt	11.5 KB
1.2 Section 6 Text Functions.xlsx	65.9 KB
1.1 Excel For Analysts Text Functions.pdf	345.2 KB
1. Introduction.mp4	1.2 MB
11. HOMEWORK Text Functions.mp4	2.4 MB
9. BONUS The SUBSTITUTE Function.mp4	8.4 MB
4. LEFTMIDRIGHT & LEN.mp4	17.8 MB
2. UPPERLOWERPROPER & TRIM.mp4	22.2 MB
3. The CONCATENATE Function (&).mp4	24.8 MB
6. SEARCHFIND.mp4	32.6 MB
7. Categorizing Data with IF(ISNUMBER(SEARCH)).mp4	35.2 MB
8. Combining RIGHT, LEN, and SEARCH.mp4	43.9 MB
5. TEXTVALUE.mp4	58.1 MB
/.../8. Formula-Based Formatting/
7. Formula-Based Formatting.html	0.1 KB
1. Introduction.vtt	2.0 KB
8. HOMEWORK Formula-Based Formatting.vtt	2.7 KB
4. Formatting Cells Based on the Value of Another Cell.vtt	4.2 KB
3. Highlighting Every Other Row Using the MOD function.vtt	4.8 KB
5. Formatting Cells Using Statistical Functions.vtt	5.9 KB
6. Formatting Cells Using Text Functions & Logical Operators.vtt	6.1 KB
2. Creating, Editing & Managing Formula-Based Rules.vtt	6.1 KB
1.1 Section8_Formula_Formatting.xlsx.xlsx	13.7 KB
1.2 Excel For Analysts Formula Formatting.pdf	186.1 KB
8. HOMEWORK Formula-Based Formatting.mp4	1.6 MB
1. Introduction.mp4	2.9 MB
4. Formatting Cells Based on the Value of Another Cell.mp4	10.6 MB
2. Creating, Editing & Managing Formula-Based Rules.mp4	12.7 MB
3. Highlighting Every Other Row Using the MOD function.mp4	15.7 MB
6. Formatting Cells Using Text Functions & Logical Operators.mp4	21.6 MB
5. Formatting Cells Using Statistical Functions.mp4	25.5 MB
/9. Array Formulas/
14. Array Formulas.html	0.1 KB
1. Introduction.vtt	2.0 KB
10. Counting Characters Across Cells.vtt	2.1 KB
8. Linking Data Between Sheets Array vs. Non-Array Comparison.vtt	3.0 KB
3. Pros & Cons of Array Functions.vtt	3.1 KB
9. Returning the X Largest Values in a Range.vtt	3.4 KB
11. Creating a MAX IF Array Formula.vtt	3.8 KB
2. Rules of Array Functions.vtt	4.2 KB
5. Using Array Constants in Formulas.vtt	4.3 KB
6. Named Array Constants.vtt	5.0 KB
7. The Transpose Function.vtt	5.5 KB
4. Vertical, Horizontal, and 2-Dimensional Array Constants.vtt	7.5 KB
1.1 Section 9 Array Formulas.xlsx	9.5 KB
15. HOMEWORK Array Functions.vtt	10.9 KB
13. BONUS Using the Double Unary Operator (--).vtt	16.9 KB
12. BONUS MAX IF with Multiple Criteria.vtt	31.7 KB
1.2 Excel For Analysts Array Formulas.pdf	360.9 KB
1. Introduction.mp4	2.1 MB
3. Pros & Cons of Array Functions.mp4	5.4 MB
10. Counting Characters Across Cells.mp4	5.8 MB
15. HOMEWORK Array Functions.mp4	6.2 MB
5. Using Array Constants in Formulas.mp4	7.5 MB
2. Rules of Array Functions.mp4	9.2 MB
8. Linking Data Between Sheets Array vs. Non-Array Comparison.mp4	9.5 MB
11. Creating a MAX IF Array Formula.mp4	9.7 MB
6. Named Array Constants.mp4	10.4 MB
13. BONUS Using the Double Unary Operator (--).mp4	11.1 MB
9. Returning the X Largest Values in a Range.mp4	11.3 MB
4. Vertical, Horizontal, and 2-Dimensional Array Constants.mp4	13.3 MB
7. The Transpose Function.mp4	14.2 MB
12. BONUS MAX IF with Multiple Criteria.mp4	18.3 MB
/4. Statistical Functions/
10. Statistical Functions.html	0.1 KB
11. HOMEWORK Statistical Functions.vtt	1.0 KB
1. Introduction.vtt	1.6 KB
4. RAND() & RANDBETWEEN.vtt	2.6 KB
5. The SUMPRODUCT Function.vtt	4.8 KB
7. COUNTIFSSUMIFSAVERAGEIFS.vtt	5.8 KB
6. NEW SUMPRODUCT Demo.vtt	6.5 KB
2. Basic Statistical Functions.vtt	6.6 KB
3. SMALLLARGE & RANKPERCENTRANK.vtt	7.6 KB
8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.vtt	9.4 KB
9. NEW Combining COUNTIF & SUMPRODUCT.vtt	10.1 KB
1.2 Section4_Statistical_Functions.xlsx.xlsx	149.8 KB
1.1 Excel For Analysts Statistical Functions.pdf.pdf	267.7 KB
11. HOMEWORK Statistical Functions.mp4	1.6 MB
1. Introduction.mp4	1.9 MB
4. RAND() & RANDBETWEEN.mp4	6.6 MB
5. The SUMPRODUCT Function.mp4	11.1 MB
7. COUNTIFSSUMIFSAVERAGEIFS.mp4	14.8 MB
2. Basic Statistical Functions.mp4	15.5 MB
3. SMALLLARGE & RANKPERCENTRANK.mp4	22.1 MB
8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4	24.7 MB
6. NEW SUMPRODUCT Demo.mp4	32.8 MB
9. NEW Combining COUNTIF & SUMPRODUCT.mp4	76.7 MB
/.../7. Date & Time Functions/
11. DateTime Functions.html	0.1 KB
7. The YEARFRAC Function.vtt	2.9 KB
1. Introduction.vtt	2.9 KB
4. TODAY()NOW().vtt	3.0 KB
12. HOMEWORK Date & Time Functions.vtt	3.2 KB
5. YEARMONTHDAY & HOURMINUTESECOND.vtt	3.7 KB
3. Date Formatting & Fill Series.vtt	4.5 KB
9. The DATEDIF Function.vtt	5.2 KB
2. DATEVALUE Your New BFF.vtt	5.8 KB
6. The EOMONTH Function.vtt	7.9 KB
8. WEEKDAY, WORKDAY & NETWORKDAYS.vtt	8.4 KB
10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.vtt	13.6 KB
1.2 Section 7 Date Time Functions.xlsx	19.8 KB
1.1 Excel For Analysts Date Time Functions.pdf.pdf	454.6 KB
12. HOMEWORK Date & Time Functions.mp4	1.3 MB
1. Introduction.mp4	3.4 MB
4. TODAY()NOW().mp4	5.7 MB
7. The YEARFRAC Function.mp4	6.0 MB
5. YEARMONTHDAY & HOURMINUTESECOND.mp4	8.3 MB
3. Date Formatting & Fill Series.mp4	9.1 MB
9. The DATEDIF Function.mp4	10.6 MB
6. The EOMONTH Function.mp4	13.7 MB
2. DATEVALUE Your New BFF.mp4	14.6 MB
8. WEEKDAY, WORKDAY & NETWORKDAYS.mp4	20.0 MB
10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.mp4	27.4 MB
/.../3. Conditional Statements & Logical Operators/
8. Logical Operators.html	0.1 KB
1. Introduction.vtt	1.8 KB
5. NOT vs. .vtt	3.9 KB
9. HOMEWORK Logical Operators.vtt	4.0 KB
7. Common IS Statements.vtt	4.6 KB
6. Fixing Errors with IFERROR.vtt	5.0 KB
2. Anatomy of the IF Statement.vtt	5.0 KB
3. Nested IF Statements.vtt	6.1 KB
4. ANDOR Operators.vtt	10.1 KB
1.2 Section 3 Logical Operators.xlsx	66.9 KB
1.1 Excel For Analysts Logical Operators.pdf	377.3 KB
9. HOMEWORK Logical Operators.mp4	1.8 MB
1. Introduction.mp4	2.6 MB
5. NOT vs. .mp4	11.9 MB
3. Nested IF Statements.mp4	16.8 MB
2. Anatomy of the IF Statement.mp4	17.7 MB
6. Fixing Errors with IFERROR.mp4	21.1 MB
7. Common IS Statements.mp4	21.9 MB
4. ANDOR Operators.mp4	29.6 MB
/.../2. Excel Formulas 101/
11. Formulas 101.html	0.1 KB
1. Introduction.vtt	1.6 KB
8. BONUS Shortcuts for Mac Users.vtt	2.7 KB
9. Creating Custom Data Validation Rules.vtt	4.1 KB
10. Fixed vs. Volatile Functions.vtt	4.1 KB
4. Basic Formula Syntax.vtt	4.2 KB
12. HOMEWORK Formulas 101.vtt	4.5 KB
5. Fixed, Relative, & Mixed References.vtt	5.8 KB
2. The Formula Library & Auditing Tools.vtt	6.0 KB
3. DEMO Evaluate Formula (not available for mac).vtt	7.6 KB
7. Function, CTRL & ALT Shortcuts.vtt	7.7 KB
1.1 Section 2 Fixed Relative References.xlsx	8.4 KB
6. Common Errors & the IFERROR statement.vtt	9.8 KB
8.1 Mac_Shortcuts.pdf.pdf	38.8 KB
1.2 Excel For Analysts Formulas 101.pdf	566.8 KB
12. HOMEWORK Formulas 101.mp4	1.9 MB
1. Introduction.mp4	2.4 MB
3. DEMO Evaluate Formula (not available for mac).mp4	4.4 MB
10. Fixed vs. Volatile Functions.mp4	7.9 MB
4. Basic Formula Syntax.mp4	8.2 MB
8. BONUS Shortcuts for Mac Users.mp4	8.2 MB
9. Creating Custom Data Validation Rules.mp4	9.6 MB
2. The Formula Library & Auditing Tools.mp4	12.9 MB
5. Fixed, Relative, & Mixed References.mp4	15.5 MB
7. Function, CTRL & ALT Shortcuts.mp4	20.0 MB
6. Common Errors & the IFERROR statement.mp4	20.0 MB
/.../10. Badass Bonus Functions/
6. Bonus Functions.html	0.1 KB
1. Introduction.vtt	2.3 KB
3. HYPERLINK as Awesome as it Sounds.vtt	7.1 KB
4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.vtt	9.1 KB
5. NEW Open Weather Map WEBSERVICE Demo.vtt	11.8 KB
2. The INDIRECT Function.vtt	12.7 KB
1.1 Excel For Analysts Bonus Functions.pdf	193.6 KB
1.2 Section10_Bonus_Functions.xlsx.xlsx	1.7 MB
1. Introduction.mp4	2.7 MB
3. HYPERLINK as Awesome as it Sounds.mp4	14.9 MB
2. The INDIRECT Function.mp4	31.6 MB
4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.mp4	75.3 MB
5. NEW Open Weather Map WEBSERVICE Demo.mp4	96.7 MB
/.../11. Wrapping Up/
1. Conclusion & Next Steps.vtt	1.1 KB
2. Bonus Lecture More from Excel Maven.html	2.6 KB
1. Conclusion & Next Steps.mp4	694.5 KB
/1. Getting Started/
3. BONUS Extra Homework Exercises.vtt	2.6 KB
2. Important Notes for New Students.html	3.9 KB
1. Course Structure & Outline.vtt	5.9 KB
3.2 Excel_Homework_Exercises.xlsx.xlsx	69.4 KB
3.1 Excel_Homework_Exercises_ANSWERS.xlsx.xlsx	87.9 KB
3. BONUS Extra Homework Exercises.mp4	5.9 MB
1. Course Structure & Outline.mp4	12.9 MB
Total files 224