I wouldn’t fully agree. XLOOKUP and VLOOKUP are useful, but they’re pretty basic and not really what differentiates candidates in accounting roles anymore. What matters more is being digitally up to date, tools like Power BI for analysis and reporting are far more relevant in today’s environment. Unless you’re targeting smaller/ medium companies, employers increasingly value data and automation skills over just Excel formulas. I’d take a course like Power Bi instead of excel course. If I was an interviewer I’d assume that you are proficient in XLOOKUP & VLOOKUP formula because you should have used it during training/ articles.
2026-06-23 19:50:52
20
Dudley :
SUMIF and SUMIFS are also important, but as you said XLOOKUP and Pivot Tables are a must.
2026-06-01 23:27:49
221
Samantha Martin9545 :
Idk why they ask vlookup when xlookup does everything that a vlookup does and is way better
2026-06-02 02:11:31
45
Shhh :
Can you please make a YouTube channel please that will help me a look. Not a lot of ppl in YouTube are good at teaching it. Could you please. Or if you know any channels that can help me
2026-07-21 00:41:25
8
Jamb876 :
any recommendations for identifying duplicates ?
2026-06-02 17:01:10
21
Carrel Oben :
God bless you 😭❤️Jeez I’m a graduate in Accounting and I am still learning Excel 😭😭❤️
2026-06-29 20:00:15
39
Jeeplife70 :
Where I work Power Query is highly used. Makes pivot tables seem like kindergarten knowledge.
2026-07-20 01:16:07
1
Kstrandz :
Thanks for sharing
2026-07-17 17:58:16
17
MJ 💕 • First Time Mom :
Pivot table 😏
2026-06-02 01:06:25
6
Kara🌺 :
I’ve never been tested on my excel skills. in the field for 20 years.
2026-06-18 11:09:41
10
Faa :
okay I'm seeing this after my interview 😭😭😭
2026-06-25 14:06:18
2
Britt :
Thank you I plan on getting a better understanding for Excel this summer
2026-06-04 00:49:04
12
Just Pretty Pee :
I love Xlook up I use it daily at work and lord I'm over making pivot tables but it is a must that uou know all of these skills especially when you have to use them every single day. Once you understand that basics it very simple for sure
2026-06-19 21:14:16
3
Mathule Madire :
Thank you
2026-06-03 04:13:28
1
dani24 :
do you offer mentorship?
2026-06-19 14:28:07
3
caballero007 :
You will remember these criteria and conditions based formulas if you have to use them in your duty.
2026-06-21 15:53:41
1
Ty | Boy Mom| Lifestyle 💙💙 :
Very true! ❤️
2026-06-02 21:58:08
1
✨Prexxie 🌹🥰 :
Thank you so so much ❤️
2026-06-17 23:41:26
1
Analyst :
Please can you compile skills in accounting I would need to transition into the job market? Entry level
2026-06-04 23:39:11
1
CoutourplusConfidenc :
I would also add Concatenation as well
2026-06-02 21:43:21
1
Angela :
Thank you 🙏
2026-06-24 19:58:57
0
Ly :
does this includes accounting internships that ask also?
2026-06-27 03:09:56
0
Abubacar :
Of course, in addition they also asked SUMIF, Covert negative value to positive value using IF.
2026-07-11 16:39:40
0
Lee :
Thank you so much. I appreciate this.
2026-06-08 18:07:57
0
To see more videos from user @guelitagee, please go to the Tikwm
homepage.