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
Watch video Top 10 excel excel formulas to know for interviews online without registration, duration hours minute second in high quality. This video was added by user Professor Cubs 28 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,789 once and liked it 74 people.