andriajah Fri Jul 2023 9 months ago
25 Most Important Excel Formulas - Get Good at Excel!
The training file can be downloaded for free here: https://drive.google.com/file/d/1wQF3TgsLk-0_751AFR-O6LtWMz_aMgsS/view?usp=sharing
00:00 Intro
02:15 Sum
03:33 Average
04:28 If
06:52 Rank
08:05 Count
09:34 Max
10:13 Min
10:28 Sumif
12:43 Countif
13:54 Trim
15:19 Lower
15:53 Upper
16:06 Proper
16:48 Concatenate
19:05 Len
20:21 Left
22:00 Mid
23:09 Right
23:54 Rounddown
26:10 Roundup
26:31 Rounds
27:59 Floor
28:58 Ceilings
29:34 Mround
30:33 Vlookup
35:39 Hlookup
37:50 If error
40:28 Closing
E-BOOK EXCEL PRICE IS AVAILABLE
🎓 E-book Learning Excel from Zero https://lynk.id/ignasiusryan/D8p04vG
📊 E-book 72 Excel Formulas https://lynk.id/ignasiusryan/kKgPP4W
🏎️ E-book 100 Important Shortcuts https://lynk.id/ignasiusryan/DAabpz5
MY DESK SETUP
🖥️ Monitor screen https://invol.co/cl8a7cu
⌨️ Keyboard https://invol.co/cl8a6w8
📷 Webcam https://invol.co/cl8a6y8
🖱️ Mouse https://invol.co/cl8a788
🎙️ Microphone https://invol.co/cl8a76o
💡 Lighting https://invol.co/cl8a75k
💼 Work desk https://invol.co/cl8a7sj
🥙 More https://ignasiusryan.notion.site/Desk-Setup-Gue-3dad46dc39834a079e1ad8368cef5e7f
GET IN TOUCH
📷 Instagram https://www.instagram.com/ignasiusryan/
✈️ Telegram https://t.me/ignasiusryan
📧 Email [email protected]
📽️ Tiktok https://www.tiktok.com/@ignasiusryan
🌐 Website linktr.ee/ignasiusryan
I use Excel 365.
If you were helped by this video, please subscribe so you don't miss my other videos and help share them with other people. Who knows, maybe this is the video they have been looking for.
Thanks,
Igna
Crazy, read the description of this video until the end.
andriajah