EXCEL SKILLS YOU MUST HAVE FOR THE 2023 Admin Job Test
Hello everyone, this video contains lessons on MANDATORY EXCEL SKILLS for the 2023 Admin Job Test. Hopefully, after watching this video, you'll be more confident and confident of being accepted to the job test.
You can download the practice files here:
https://s.id/kaemnur_teskerja
You can also find me here.
🔍 Instagram: www.instagram.com/kaemnurr
🔍 TikTok: www.tiktok.com/@kaemnurr
✉️ Email: [email protected]
🌐 Website: kaemnur.com
If you have any suggestions, feedback, or requests for Excel discussions on my channel, please write them in the comments section or DM me on my social media.
If you found this video helpful, please subscribe so you don't miss my other videos. And please share it with others; this might just be what they've been looking for.
Thanks and good luck
Kaemnur
=========================================================================
Timestamp:
00:00 Intro
00:20 Hide empty data
01:31 Auto Sum ( sum, counta, max, min, average)
03:30 Logical IF
05:33 Match (countif, sumif, match, iferror)
08:22 Lookup (vlookup, hlookup, xlookup)
12:01 Text (text join, upper, proper, lower, Marge & Center)
14:25 Design & Pivot (Table design, Pivot)
16:44 Closing