andriajah Fri Jul 2023 1 year ago

25 Most Important Excel Formulas - Directly Excel!

This video explains in detail the 25 formulas that you must be able to because it is most often used in Excel.

The exercise 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 Round
27:59 Floor
28:58 ceiling
29:34 Mround
30:33 VLOOKUP
35:39 Hlookup
37:50 IFERROR
40:28 Closing

Excel E-Book Prices are up to
🎓 E-Book Learn Excel from Zero https://lynk.id/ignasiusryan/d8p04vg
📊 E-Book 72 Excel Formula https://lynk.id/ignasiusryan/kkgpp4w
🏎️ E-Book 100 Important Shortcut https://lynk.id/ignasiusryan/daabpz5

My Setup Desk
🖥️ 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 table https://invol.co/Cl8a7SJ
🥙 Others 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 are helped by this video, please subscribe so you don't miss my other videos and help share with others. Who knows, this is the video they have been looking for.

Thanks,
IGNA

Gokil, you read the description of this video until it's finished.