Udemy Mastering Microsoft Excel Formulas - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Udemy Mastering Microsoft Excel Formulas (/Thread-Udemy-Mastering-Microsoft-Excel-Formulas) |
Udemy Mastering Microsoft Excel Formulas - AD-TEAM - 06-21-2024
Download Free Download : Udemy Mastering Microsoft Excel Formulas
mp4 | Video: h264,1920X1080 | Audio: AAC, 44.1 KHz Genre:eLearning | Language: English | Size:2 GB 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 [To see links please register or login] |