15/10/2024
āĻā§āϰā§āϏā§āϰ āĻĢāϰā§āĻŽ āϞāĻŋāĻāĻ: https://forms.gle/gEW4xSLJstBgMxr37
āĻāĻā§āϏā§āϞ āĻĢāϰā§āĻŽā§āϞāĻž āĻŦā§āĻāĻā§āϝāĻžāĻŽā§āĻĒ: ā§Žā§Ļ+ āĻāĻā§āϏā§āϞ āĻĢāϰā§āĻŽā§āϞāĻž āϏāĻžāĻĨā§ ChatGPT āĻāĻŦāĻ Conditional Formatting āĻāϰ āĻŽāĻžāϧā§āϝāĻŽā§ āĻĻāĻā§āώāϤāĻž āĻ
āϰā§āĻāύ āĻāϰā§āĻŖāĨ¤
āĻāĻĒāĻŋāĻāϏ:
01. Date & Time Functions : TIME, HOUR, MINUTE, SECOND, DATE, DAY, MONTH, YEAR, DATEVALUE, TODAY, NOW, DAYS etc.
02. Text Functions : LEFT, RIGHT, MID, LEN, FIND, SUBSTITUTE, REPLACE, UPPER, LOWER, PROPER, TEXT, TEXT SPLIT, TEXTJOIN etc.
03. Math & Trig Functions : SUM, SUMIF, SUMIFS, PRODUCT, SUMPRODUCT, MOD, QUOTIENT etc.
04. Logical Function : IF, IFS, AND, OR, LET etc.
05. Lookup & Reference : TRANSPOSE, SORT, UNIQUE, FILTER, VLOOKUP etc.
06. Statistical Function : AVERAGE, AVERAGEIF, AVERAGEIFS, MAX, MAXA, MAXIFS, MIN, MINA, MINIFS, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, LARGE, SMALL etc.
07. Information Function : ISNUMBER, ISTEXT, ISBLANK, ISERROR, ISEVEN, ISODD, ISFORMULA, ISREF etc.
08. ChatGPT: ALASKA, ALEXTRACT, ALFILL, AI, TRANSLATE etc.
09. Conditional Formatting : Highlight Cell Rules- Greater Than, Less Than, Between, Equal to, Text That Contains, A Date Occurring, Duplicate, Unique.
10. Bonus Lesson : Introduction with "Excel Enigma Machine" & Flash Fill.
āĻŦā§āĻāĻā§āϝāĻžāĻŽā§āĻĒā§āϰ āĻŦāĻŋāĻŦāϰāĻŖ:
āϤāĻžāϰāĻŋāĻ: 25/10/2024 (āĻļā§āĻā§āϰāĻŦāĻžāϰ)
āϏāĻŽā§: 07:15 PM āĻĨā§āĻā§ 11:30 PM (15 āĻŽāĻŋāύāĻŋāĻ āĻŦāĻŋāϰāϤāĻŋ)
āĻĢāĻŋ: ⧧⧝⧝ āĻāĻžāĻāĻž
āĻā§āϰā§āϏ āĻĢāĻŋ āĻĒā§āĻŽā§āύā§āĻ āĻāϰā§āύ: 0163777-3583 (Bkash Personal)
Call for any Query: 01874-220055
Address: Sector #06, Road #08, House #14, Uttara Dhaka