46,024 views
This is a comprehensive look at the Level 2 Computer Skills Practical Lecture Functions! ????We will come back with a quality lecture that will satisfy you even more!! Please take a look and leave a comment if you have any questions???????? ???? Download PDF + Excel example https://blog.naver.com/ekscnrzl3/2233... ???? 24-year computer proficiency level 2 revised functions finished at once • ✏️24-year computer proficiency level 2 revised functions finished at once Timeline - 0:00 Intro 0:11 IF 3:37 AND, OR 13:58 IFERROR 15:51 Nested IF 18:53 TODAY, NOW 22:57 YEAR, MONTH, DAY 24:19 HOUR, MINUTE, SECOND 27:09 DATE, TIME 29:13 WEEKDAY, WORKDAY 32:48 DAYS 33:43 EDATE, EOMONTH 35:52 D function 40:52 MAX, MIN 44:09 LARGE, SMALL 45:28 COUNT, COUNTA, COUNTBLANK 47:35 QUOTIENT, MOD 50:30 RAND, RANDBETWEEN 51:53 INT, ABS, MODE 54:55 MEDIAN, POWER 56:29 TRUNC 58:48 ROUND, ROUNDUP, ROUNDDOWN 1:02:37 SUMIF, AVERAGEIF, COUNTIF 1:07:32 SUMIFS, AVERAGEIFS, COUNTIFS 1:11:47 RANK.EQ 1:13:58 LEFT, RIGHT, MID 1:16:05 UPPER, LOWER, PROPER 1:17:20 LEN, TRIM 1:18:23 FIND, SEARCH 1:20:05 ROW, ROWS, COLUMN, COLUMNS 1:22:21 CHOOSE 1:24:14 INDEX, MATCH 1:29:02 HLOOKUP, VLOOKUP - ???? Jiwoo Teacher Cafe https://cafe.naver.com/teacherjiwoo ???? For inquiries about lectures, tutoring, and content, contact [email protected]