DevCourseWeb com Udemy Mastering Formulas and Functions Excel | EA840D4DAE6EDBB7F96D27F385D2C6CB39BC4CE3

DevCourseWeb com Udemy Mastering Formulas and Functions Excel

Name	[ DevCourseWeb.com ] Udemy - Mastering Formulas and Functions Excel	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	107
Last Seen	2024-07-22 00:14
Hash	EA840D4DAE6EDBB7F96D27F385D2C6CB39BC4CE3

/
Get Bonus Downloads Here.url	0.2 KB
/1. Introduction/
1. Introduction.mp4	11.9 MB
Formulas And Function.pptx	47.8 KB
/.../Ch-1 Formulas 101/
1) Formulas and Function.xlsx	9.4 KB
2) Two more ways to create formulas.xlsx	9.3 KB
3) Operators.xlsx	11.2 KB
4) Copy formulas and values + Relative referencing.xlsx	11.2 KB
5) Absolute refernecing.xlsx	9.7 KB
6) Edit formula in Excel.xlsx	9.0 KB
7) Named Range.xlsx	9.1 KB
8) Getting help in Excel.xlsx	8.7 KB
/.../Ch-7 Text functions/
1) Find, Search and Mid.xlsx	8.7 KB
2) Left Right.xlsx	9.1 KB
3) Concat, ampersand and textjoin.xlsx	9.6 KB
4) Trim, upper, lower and proper.xlsx	8.9 KB
5) replace, substitute.xlsx	10.1 KB
6) text before after.xlsx	9.5 KB
7) rept, len, value fn.xlsx	9.1 KB
/.../ch-2 Statistics and Math function/
1) Summarizing Data.xlsx	9.7 KB
10) MOD function.xlsx	10.0 KB
11) Aggregate function.xlsx	14.3 KB
2) auto sum.xlsx	9.6 KB
3) Rank without sorting.xlsx	9.8 KB
4) tabulate values using LArge and Small.xlsx	9.8 KB
5) Counting Students Who Missed the Exam with COUNTBLANK.xlsx	9.5 KB
6) Count, Counta and Status Bar.xlsx	9.6 KB
7 Rand and Randbetween.xlsx	10.3 KB
8) Round, Roundup rounddown.xlsx	8.9 KB
9) Mround, Ceiling, Floor.xlsx	9.1 KB
/.../ch-3 Welcome to the world of If functions/
1) IF function.xlsx	13.0 KB
2) Nested if func.xlsx	12.8 KB
3 ) Compound Logical Operators.xlsx	11.2 KB
4) IFS fn.xlsx	13.1 KB
/.../ch-4 Summarize data using conditional fn/
1) Countif, Sumif, Averageif.xlsx	12.9 KB
2) Countifs, Sumifs and averageifs.xlsx	13.4 KB
3) maxifs , minifs.xlsx	12.6 KB
4) Subtotal.xlsx	13.0 KB
/.../ch-5 lookup and reference function/
1) VLOOKUP AND HLOOKUP.xlsx	10.4 KB
2) Choose function.xlsx	10.8 KB
3) Match Index.xlsx	11.3 KB
4) Two way lookup.xlsx	9.1 KB
5) Transpose.xlsx	8.9 KB
6) Offset Function.xlsx	10.4 KB
7) Xlookup.xlsx	18.5 KB
9) UNIQUE FN.xlsx	10.2 KB
/.../ch-6 Date and time functions/
1) Understandig Dates and Times.xlsx	10.7 KB
2) DATE AND TIME FUNCTIONS.xlsx	9.7 KB
3) today, now and datevalue.xlsx	9.2 KB
4) WORKDAYS, NETWORKDAYS, DATEDIF.xlsx	13.0 KB
5) EDATE, EOMONTH.xlsx	8.7 KB
/1. Introduction/H.W file/ch 4/
Unique.xlsx	10.0 KB
/1. Introduction/H.W file/ch-2/
3) Rank.xlsx	9.0 KB
/1. Introduction/H.W file/ch-3/
1) IF func.xlsx	9.1 KB
/1. Introduction/H.W file/ch-5/
1) countif, sumif, averageif.xlsx	13.1 KB
2) countifs, sumifs and averageifs.xlsx	19.8 KB
/2. Basics/
1. Formulas and Functions 101.mp4	16.4 MB
2. More ways to create formulas.mp4	7.2 MB
3. Operators in Excel.mp4	26.4 MB
4. Copy formulas and values.mp4	39.0 MB
5. Absolute referencing in Excel.mp4	15.8 MB
6. What is Named Range .mp4	8.0 MB
7. How to get help in Excel .mp4	6.6 MB
8. Section 2 QUIZ.html	0.1 KB
/.../3. Basic Statistical and Maths Function/
1. Summarzing Data.mp4	34.6 MB
10. How does MOD function work .mp4	31.4 MB
11. Aggregate function.mp4	33.2 MB
12. Section 3 QUIZ.html	0.1 KB
2. Auto sum and Quick analysis tool.mp4	19.9 MB
3. Rank Function.mp4	11.0 MB
4. Large and small functions.mp4	12.5 MB
5. How does countblank function work .mp4	13.2 MB
6. What's the difference between Count and counta function.mp4	17.9 MB
7. Generate random numbers.mp4	32.0 MB
8. Rounding off functions.mp4	19.2 MB
9. What is mround function .mp4	22.2 MB
/.../4. Welcome to the world of IF functions/
1. Nested If function.mp4	31.7 MB
2. If function.mp4	28.4 MB
3. AND OR Function.mp4	37.4 MB
4. IFS function.mp4	21.2 MB
5. Section 4 QUIZ.html	0.1 KB
/.../5. Summarize data using Conditional Function/
1. Countif, Sumif & Averageif.mp4	65.7 MB
2. Countifs, Sumifs & Averageifs.mp4	78.7 MB
3. Maxifs and Minifs.mp4	29.2 MB
4. Subtotal.mp4	39.2 MB
5. Section 5QUIZ.html	0.1 KB
/.../6. Lookup and reference Functions/
1. VLOOKUP.mp4	30.7 MB
2. Choose and switch function.mp4	35.7 MB
3. Match and Index function.mp4	42.8 MB
4. Two way lookup.mp4	20.2 MB
5. XLOOKUP.mp4	20.6 MB
6. Offset function.mp4	29.1 MB
/.../7. Date and time functions/
1. Understanding date and time function.mp4	38.5 MB
2. DATETIME Function.mp4	20.6 MB
3. Today , Now & Datevalue.mp4	13.9 MB
4. Workday and Networkday function.mp4	15.3 MB
5. Datedif function.mp4	21.3 MB
6. EDATE & EOMONTH.mp4	8.0 MB
7. Section 7 QUIZ.html	0.1 KB
/8. TEXT functions/
1. Find , Search and Mid function.mp4	16.0 MB
2. Left , Right and Flash fill.mp4	26.3 MB
3. Merge data.mp4	22.9 MB
4. Text formatting.mp4	22.8 MB
5. Replace and Substitute.mp4	28.8 MB
6. Textafter, Textbefore and Textsplit.mp4	11.5 MB
7. Section 8QUIZ.html	0.1 KB
/9. CONCLUSION/
1. WHAT NEXT.mp4	1.9 MB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 107