↓Details about the PC, smartphone and tablet classes where you can learn from zero knowledge • A seven-year dream and a one-year plan has finally come true [Sample file download] https://pasonyu.com/wp-content/upload... *After opening the Excel file, please press the "Enable editing (E)" button in the yellow bar at the top. [Table of Contents] Complete explanation of 79 major Excel functions [Archived version] 0:00:00 Overview 0:03:00 1. How to use the four arithmetic operations (addition, subtraction, multiplication, division) 0:05:40 2. How to use the SUM function 0:08:50 3. How to use the AVERAGE function 0:10:25 4. How to use the MAX function 0:11:15 5. How to use the MIN function 0:11:55 6. How to use the COUNT function 0:13:40 7. How to use the COUNTA function 0:15:35 7-1. How to select cells from end to end (Shift+Ctrl+arrow) 0:17:40 7-2. How to select a column and solve a function (COUNTA(A:A)-1) 0:19:55 8. How to use the COUNTBLANK function 0:21:30 9. How to use the ROUND function 0:21:42 9-1. Explanation of arguments 0:26:40 9-1. How to use the ROUND function + AVERAGE function (nested) 0:30:15 10. How to use the ROUNDUP function 0:32:25 11. How to use the ROUNDDOWN function 0:34:20 12. How to use the COUNTIF function 0:35:35 12-1. When specifying directly 0:39:08 12-2. When using inequality signs 0:43:25 12-3 When using wildcards 0:47:25 12-4. When combining 0:50:45 Extra: Absolute references / relative references 0:55:25 Extra 2: Solving the COUNTIF function with absolute references 0:59:04 14. How to use the SUMIF function 1:08:28 15. How to use the AVERAGEIF function 1:14:09 16. How to use the VLOOKUP function 1:23:56 16-1. How to use TRUE in the VLOOKUP function 1:26:23 16-2. [How to use compound references] How to use AutoFill with the VLOOKUP function 1:34:41 17. How to use the COLUMN function 1:36:42 18. How to use the CLUMNS function 1:39:28 18-1. How to use the VLOOKUP function + COLUMN function 1:42:10 Bonus 3: Why double-clicking doesn't work with AutoFill 1:43:32 19. How to use the IF function 1:49:00 19-1. How to use the IF function + VLOOKUP function 1:50:30 19-2. How to use the IF function + IF function 1:53:30 20. How to use the IFERRORAND function 1:55:23 20-1. How to use the IFERROR function + VLOOKUP function 1:57:00 21. How to use the AND function 1:58:42 21-1. How to use the IF function + AND function 2:00:10 22. How to use the OR function 2:01:17 21-1. How to use the IF function + OR function 2:02:10 23. How to use the NOT function 2:03:03 22-1. How to use the AND function + NOT function 2:04:55 24. How to use the INDEX function 2:07:25 25. How to use the MATCH function 2:09:07 25-1. How to use the INDEX function + MATCH function 2:12:20 25-2. How to use the INDEX function + MATCH function to autofill to the right 2:14:50 26. How to use the TODAY function 2:15:20 27. How to use the NOW function 2:15:45 27-1. TODAY function + arithmetic operations + display format 2:16:35 28. How to use the EOMONTH function 2:18:05 29. How to use the COUNTIFS function 2:24:30 30. How to use the SUMIFS function 2:29:10 31. How to use the AVERAGEIFS function 2:31:44 32. How to use the UPPER function 2:33:00 33. How to use the LOWER function 2:33:12 34. How to use the PROPER function 2:33:33 35. How to use the JIS function 2:34:05 36. How to use the ASC function 2:34:45 36-1. Pasting values ​​[How to deal with errors that occur when deleting] 2:36:20 37. How to use the YEAR function 2:37:07 38. How to use the MONTH function 2:37:17 39. How to use the DAY function 2:37:39 39-1. How to use the YEAR function + TODAY function 2:39:05 39-2. How to use the YEAR function + SUMIF function 2:40:00 39-3. How to use the MONTH function + SUMIF function 2:40:42 40. How to use the LEFT function 2:42:10 41. How to use the MID function 2:43:28 42. How to use the RIGHT function 2:44:20 43. How to use the DATE function 2:46:33 43-1. DATE function + YEAR function + MONTH function + DAY function + TODAY function 2:48:30 44. How to use the FIND function 2:52:50 44-1. How to use the FIND function + LEFT function 2:54:55 45. How to use the REPLACE function 2:58:37 45-1. How to use the REPLACE function + FIND function 3:01:15 46. How to use the SUBSTITUTE function 3:04:35 46-1. How to use the SUBSTITUTE function + SUBSTITUTE function 3:06:50 46-2. How to use the SUBSTITUTE function + SUBSTITUTE function + SUBSTITUTE function 3:09:08 47. How to use the LEN function 3:11:25 48. How to use the LENB function 3:12:00 48-1. LEN function + conditional formatting 3:14:00 48-2. LENB function + conditional formatting 3:17:28 48-3. How to use the LEN function + RIGHT function + FIND function 3:20:05 49. How to use the TEXT function ([Day of the week: aaa] [〇 day of the week: aaaa] [Number: 000] [Date: yyyy/m/d] [Text: @]) 3:25:37 50. How to use the CONCATENATE function 3:31:00 50-1. How to use & 3:32:25 50-2. How to use the CONCAT function 3:33:33 50-3. &+TODAY function + TEXT function usage 3:37:25 51. VALU