Udemy Mastering Microsoft Excel Formulas

Files Included :

10 - Using the SUBTOTAL function for filtered data.mp4 (50.15 MB)
MP4
11 - Counting data ranges.mp4 (16.36 MB)
MP4
2 - Excel-Mastery.zip (149.64 KB)
ZIP
3 - Introduction.mp4 (63.16 MB)
MP4
4 - Understanding Function Syntax.mp4 (41.61 MB)
MP4
5 - Understanding Expressions 1.mp4 (88.38 MB)
MP4
6 - Understanding Expressions 2.mp4 (16.27 MB)
MP4
7 - Introduction to Excel aggregate functions.mp4 (67.8 MB)
MP4
8 - Using Aggregate Functions in Excel 2.mp4 (20.9 MB)
MP4
9 - Replicating formulas and using the AUTOSUM feature smartly.mp4 (46.89 MB)
MP4
12 - Converting characters between cases in Excel.mp4 (15.99 MB)
MP4
13 - Extracting characters from beginning and ending of texts with LEFT and RIGHT.mp4 (26.14 MB)
MP4
14 - Using MID to extract characters and TRIM to remove extra spaces.mp4 (26.8 MB)
MP4
15 - Combining texts with CONCATENATE CONCAT and TEXTJOIN functions.mp4 (38.13 MB)
MP4
16 - Coding and decoding between characters and numbers with UNICHAR and UNICODE.mp4 (12.39 MB)
MP4
17 - Counting characters with LEN and finding position with FIND and SEARCH.mp4 (36.22 MB)
MP4
18 - Introduction to DATE functions.mp4 (43.75 MB)
MP4
19 - Extracting DAY MONTH and YEAR from a Date.mp4 (10.18 MB)
MP4
20 - Extracting Day of Week and Week of year with WEEKDAY and WEEKNUM.mp4 (25.6 MB)
MP4
21 - Using TEXT function to display dates in text formats.mp4 (57.88 MB)
MP4
22 - Using DATEVALUE to convert date in text format to proper date format in excel.mp4 (12.16 MB)
MP4
23 - Getting the endo of month date with EOMONTH function in Excel.mp4 (14.24 MB)
MP4
24 - Moving periods between dates with EDATE function in Excel.mp4 (11.89 MB)
MP4
25 - Using NETWORKDAYS NETWORKDAYSINTL to get number of working days in excel.mp4 (26 MB)
MP4
26 - Introduction to DATEDIF function in Excel.mp4 (20.6 MB)
MP4
27 - Calculating different units of age with DATEDIF.mp4 (34.08 MB)
MP4
28 - Introduction to combining multiple functions.mp4 (23.47 MB)
MP4
29 - Combining Excel Functions part 1.mp4 (37.21 MB)
MP4
30 - Combining Excel Functions part 2.mp4 (40.13 MB)
MP4
31 - Combining Excel Functions part 3.mp4 (35.77 MB)
MP4
32 - Combining Excel Functions part 3b.mp4 (38.18 MB)
MP4
33 - Introduction to Cell Referencing in Excel.mp4 (43.65 MB)
MP4
34 - Using the Relative default cell referencing stye.mp4 (23.91 MB)
MP4
35 - Using the Absolute full lock cell referencing style.mp4 (42.9 MB)
MP4
36 - Using Mixed row lock and column lock referencing style.mp4 (43.76 MB)
MP4
37 - Introduction to Logical Operators in Excel.mp4 (20.36 MB)
MP4
38 - Using COUNTIF function to count number of value occurrences within a range.mp4 (79.49 MB)
MP4
39 - Using COUNTIF function to count number of value occurrences within a range 2.mp4 (20.02 MB)
MP4
40 - Using COUNTIFS to count values in ranges with multiple criteria.mp4 (47.39 MB)
MP4
41 - Summarizing data values based on a criteria with SUMIF and AVERAGEIF.mp4 (44 MB)
MP4
42 - Summarizing data values based on multiple criteria with SUMIFS.mp4 (17.13 MB)
MP4
43 - Introduction to logical functions in Excel.mp4 (25.69 MB)
MP4
44 - Using the IF function to write conditional expressions part 1.mp4 (37.7 MB)
MP4
45 - Using the IF function to write conditional expressions part 2.mp4 (31.2 MB)
MP4
46 - Understanding the AND OR functions in Excel.mp4 (14.96 MB)
MP4
47 - Combining IF with AND to write an expression based on multiple conditions.mp4 (53.34 MB)
MP4
48 - Combining IF with OR to write an expression based on multiple conditions.mp4 (41.23 MB)
MP4
49 - Using nested IF.mp4 (54.13 MB)
MP4
50 - Introduction to VLOOKUP function.mp4 (63.71 MB)
MP4
51 - Using the VLOOKUP function to return values matched from a data range 1.mp4 (57.51 MB)
MP4
52 - Using the VLOOKUP function to return values matched from a data range 2.mp4 (58.95 MB)
MP4
53 - Introduction to MATCH function in Excel.mp4 (34.77 MB)
MP4
54 - Automating VLOOKUP column index with MATCH function.mp4 (58.74 MB)
MP4
55 - Handling unfound values by combing VLOOKUP with IFERROR function.mp4 (23.07 MB)
MP4
56 - Using the VLOOKUP function to return values matched from a data range 3.mp4 (30.97 MB)
MP4
57 - Introduction to XLOOKUP function.mp4 (21.92 MB)
MP4
58 - Introduction to INDEX function.mp4 (16.88 MB)
MP4
59 - Automating Row or Column number in INDEX with the MATCH function.mp4 (44.87 MB)
MP4