Top 10 excel excel formulas to know for interviews
Just imagine: you're on a job interview and your asked to give your top 10 excel formulas. 😮
How would you respond?
Sure, there are many ways to answer this, yet in this video we'll give you a list of functions that are very commonly used in most businesses, and will get an interviewers attention.
In this video we'll show you how to use the following:
SUM
AVERAGE
IF
VLOOKUP
INDEX
MATCH
SUMIF
OFFSET
IFERROR
TRIM
⌚Timestamps
0:00 How knowing a specific function list helps during interviews
1:15 SUM
4:10 AVERAGE
4:50 IF, IF And, IF Or, Nested IF (IFS)
13:10 VLOOKUP
17:35 INDEX | MATCH Intro
18:05 INDEX
19:30 MATCH
23:20 INDEX and MATCH combo
24:37 SUMIF
27:50 OFFSET
32:48 IFERROR
34:19 TRIM
📄 Download the sample file
https://1drv.ms/x/s!AgnhzVKiTqWmgQO5W...
📘 Resources (on the house)
Mega Excel Keyboard Shortcut List
https://view.flodesk.com/pages/63bf31...
Excel Quick Reference Guide
https://view.flodesk.com/pages/63bf2f...
Job Search Guide
https://theprofessorcubs.gumroad.com/...
☕ Buy me a coffee?
https://www.buymeacoffee.com/professo...
#excel #jobsearch #jobinterview #jobsearching #interviewquestions #interviewpreparation
Смотрите видео Top 10 excel excel formulas to know for interviews онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Professor Cubs 28 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,789 раз и оно понравилось 74 людям.