FreeCourseSite com Udemy Microsoft Excel Advanced Excel Formulas Functions

FreeCourseSite com Udemy Microsoft Excel Advanced Excel Formulas Functions

Name	[FreeCourseSite.com] Udemy - Microsoft Excel - Advanced Excel Formulas & Functions	DOWNLOAD Copy Link
Total Size	1.6 GB
Total Files	227
Last Seen	2024-11-09 23:24
Hash	805C5709EE5AA85C01F2B1AE19900C9602D4BB96

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