[ DevCourseWeb.com ] Udemy - Mastering Formulas and Functions Excel

File Name

Size

Get Bonus Downloads Here.url

182 B

~Get Your Files Here !/1. Introduction/1. Introduction.mp4

11 MB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/1) Formulas and Function.xlsx

9.2 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/2) Two more ways to create formulas.xlsx

9.1 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/3) Operators.xlsx

11 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/4) Copy formulas and values + Relative referencing.xlsx

11 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/5) Absolute refernecing.xlsx

9.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/6) Edit formula in Excel.xlsx

8.8 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/7) Named Range.xlsx

8.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-1 Formulas 101/8) Getting help in Excel.xlsx

8.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/1) Find, Search and Mid.xlsx

8.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/2) Left Right.xlsx

8.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/3) Concat, ampersand and textjoin.xlsx

9.4 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/4) Trim, upper, lower and proper.xlsx

8.7 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/5) replace, substitute.xlsx

9.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/6) text before after.xlsx

9.3 kB

~Get Your Files Here !/1. Introduction/Exercise Files/Ch-7 Text functions/7) rept, len, value fn.xlsx

8.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/1) Summarizing Data.xlsx

9.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/10) MOD function.xlsx

9.7 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/11) Aggregate function.xlsx

14 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/2) auto sum.xlsx

9.4 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/3) Rank without sorting.xlsx

9.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/4) tabulate values using LArge and Small.xlsx

9.6 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/5) Counting Students Who Missed the Exam with COUNTBLANK.xlsx

9.3 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/6) Count, Counta and Status Bar.xlsx

9.4 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/7 Rand and Randbetween.xlsx

10 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/8) Round, Roundup rounddown.xlsx

8.7 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-2 Statistics and Math function/9) Mround, Ceiling, Floor.xlsx

8.8 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-3 Welcome to the world of If functions/1) IF function.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-3 Welcome to the world of If functions/2) Nested if func.xlsx

12 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-3 Welcome to the world of If functions/3 ) Compound Logical Operators.xlsx

11 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-3 Welcome to the world of If functions/4) IFS fn.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-4 Summarize data using conditional fn/1) Countif, Sumif, Averageif.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-4 Summarize data using conditional fn/2) Countifs, Sumifs and averageifs.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-4 Summarize data using conditional fn/3) maxifs , minifs.xlsx

12 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-4 Summarize data using conditional fn/4) Subtotal.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/1) VLOOKUP AND HLOOKUP.xlsx

10 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/2) Choose function.xlsx

11 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/3) Match Index.xlsx

11 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/4) Two way lookup.xlsx

8.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/5) Transpose.xlsx

8.7 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/6) Offset Function.xlsx

10 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/7) Xlookup.xlsx

18 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-5 lookup and reference function/9) UNIQUE FN.xlsx

9.9 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-6 Date and time functions/1) Understandig Dates and Times.xlsx

10 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-6 Date and time functions/2) DATE AND TIME FUNCTIONS.xlsx

9.5 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-6 Date and time functions/3) today, now and datevalue.xlsx

9.0 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-6 Date and time functions/4) WORKDAYS, NETWORKDAYS, DATEDIF.xlsx

13 kB

~Get Your Files Here !/1. Introduction/Exercise Files/ch-6 Date and time functions/5) EDATE, EOMONTH.xlsx

8.5 kB

~Get Your Files Here !/1. Introduction/Formulas And Function.pptx

47 kB

~Get Your Files Here !/1. Introduction/H.W file/ch 4/Unique.xlsx

9.8 kB

~Get Your Files Here !/1. Introduction/H.W file/ch-2/3) Rank.xlsx

8.8 kB

~Get Your Files Here !/1. Introduction/H.W file/ch-3/1) IF func.xlsx

8.9 kB

~Get Your Files Here !/1. Introduction/H.W file/ch-5/1) countif, sumif, averageif.xlsx

13 kB

~Get Your Files Here !/1. Introduction/H.W file/ch-5/2) countifs, sumifs and averageifs.xlsx

19 kB

~Get Your Files Here !/2. Basics/1. Formulas and Functions 101.mp4

16 MB

~Get Your Files Here !/2. Basics/2. More ways to create formulas.mp4

6.8 MB

~Get Your Files Here !/2. Basics/3. Operators in Excel.mp4

25 MB

~Get Your Files Here !/2. Basics/4. Copy formulas and values.mp4

37 MB

~Get Your Files Here !/2. Basics/5. Absolute referencing in Excel.mp4

15 MB

~Get Your Files Here !/2. Basics/6. What is Named Range .mp4

7.6 MB

~Get Your Files Here !/2. Basics/7. How to get help in Excel .mp4

6.3 MB

~Get Your Files Here !/2. Basics/8. Section 2 QUIZ.html

149 B

~Get Your Files Here !/3. Basic Statistical and Maths Function/1. Summarzing Data.mp4

33 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/10. How does MOD function work .mp4

30 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/11. Aggregate function.mp4

32 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/12. Section 3 QUIZ.html

149 B

~Get Your Files Here !/3. Basic Statistical and Maths Function/2. Auto sum and Quick analysis tool.mp4

19 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/3. Rank Function.mp4

10 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/4. Large and small functions.mp4

12 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/5. How does countblank function work .mp4

12 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/6. What's the difference between Count and counta function.mp4

17 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/7. Generate random numbers.mp4

30 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/8. Rounding off functions.mp4

18 MB

~Get Your Files Here !/3. Basic Statistical and Maths Function/9. What is mround function .mp4

21 MB

~Get Your Files Here !/4. Welcome to the world of IF functions/1. Nested If function.mp4

30 MB

~Get Your Files Here !/4. Welcome to the world of IF functions/2. If function.mp4

27 MB

~Get Your Files Here !/4. Welcome to the world of IF functions/3. AND OR Function.mp4

36 MB

~Get Your Files Here !/4. Welcome to the world of IF functions/4. IFS function.mp4

20 MB

~Get Your Files Here !/4. Welcome to the world of IF functions/5. Section 4 QUIZ.html

149 B

~Get Your Files Here !/5. Summarize data using Conditional Function/1. Countif, Sumif & Averageif.mp4

63 MB

~Get Your Files Here !/5. Summarize data using Conditional Function/2. Countifs, Sumifs & Averageifs.mp4

75 MB

~Get Your Files Here !/5. Summarize data using Conditional Function/3. Maxifs and Minifs.mp4

28 MB

~Get Your Files Here !/5. Summarize data using Conditional Function/4. Subtotal.mp4

37 MB

~Get Your Files Here !/5. Summarize data using Conditional Function/5. Section 5QUIZ.html

149 B

~Get Your Files Here !/6. Lookup and reference Functions/1. VLOOKUP.mp4

29 MB

~Get Your Files Here !/6. Lookup and reference Functions/2. Choose and switch function.mp4

34 MB

~Get Your Files Here !/6. Lookup and reference Functions/3. Match and Index function.mp4

41 MB

~Get Your Files Here !/6. Lookup and reference Functions/4. Two way lookup.mp4

19 MB

~Get Your Files Here !/6. Lookup and reference Functions/5. XLOOKUP.mp4

20 MB

~Get Your Files Here !/6. Lookup and reference Functions/6. Offset function.mp4

28 MB

~Get Your Files Here !/7. Date and time functions/1. Understanding date and time function.mp4

37 MB

~Get Your Files Here !/7. Date and time functions/2. DATETIME Function.mp4

20 MB

~Get Your Files Here !/7. Date and time functions/3. Today , Now & Datevalue.mp4

13 MB

~Get Your Files Here !/7. Date and time functions/4. Workday and Networkday function.mp4

15 MB

~Get Your Files Here !/7. Date and time functions/5. Datedif function.mp4

20 MB

~Get Your Files Here !/7. Date and time functions/6. EDATE & EOMONTH.mp4

7.6 MB

~Get Your Files Here !/7. Date and time functions/7. Section 7 QUIZ.html

149 B

~Get Your Files Here !/8. TEXT functions/1. Find , Search and Mid function.mp4

15 MB

~Get Your Files Here !/8. TEXT functions/2. Left , Right and Flash fill.mp4

25 MB

~Get Your Files Here !/8. TEXT functions/3. Merge data.mp4

22 MB

~Get Your Files Here !/8. TEXT functions/4. Text formatting.mp4

22 MB

~Get Your Files Here !/8. TEXT functions/5. Replace and Substitute.mp4

27 MB

~Get Your Files Here !/8. TEXT functions/6. Textafter, Textbefore and Textsplit.mp4

11 MB

~Get Your Files Here !/8. TEXT functions/7. Section 8QUIZ.html

149 B

~Get Your Files Here !/9. CONCLUSION/1. WHAT NEXT.mp4

1.8 MB

~Get Your Files Here !/Bonus Resources.txt

386 B