Kat: Chief Excel Officer
Region: US
Monday 04 October 2021 16:28:36 GMT
526976
16285
721
817
Music
Download
Comments
Zayn :
VLOOKUP is dead to me. XLOOKUP is where it’s at.
2021-10-04 18:58:31
28
drnebuloso :
index(match()) gang gang
2021-10-04 17:43:25
298
Nudo1985 :
work smarter not harder. xlookup
2021-10-04 19:02:08
154
Pete :
Macros. If you can creat a macro you are proficient
2021-10-04 17:00:04
130
Chris Richardson :
xlookup. I could have cried with joy when I saw "your lookup value can be on the RIGHT of the lookup array"
2021-10-04 20:57:24
81
wxyzyxw :
...I'm proficient in Google
2021-10-04 17:48:38
60
prfury :
Of course I failed. That’s why I’m here 😅 that vlookup is my enemy at the moment
2021-10-04 18:45:55
35
firecracker girl 🎆 :
Honestly feeling like I can put “proficient in excel” on my resume because of this tiktok account
2021-10-04 21:03:21
30
FlyingTy Aviation :
If you say you know the basics these are what I’d expect you to know.
2021-10-04 17:38:13
27
EvilOwl74 :
now I need to look up how to flash fill 🤔
2021-10-04 20:46:58
26
Mike :
Index Match, Pivot Chart, Slicers, XLookup to name a few 😜😜
2021-10-04 17:14:28
16
user3823103921040 :
Kinda wish that vlookup can lookup the columns on the left as well or instead of choosing the column number we can just choose column name
2021-10-04 19:53:20
14
Italianojtl :
Soooo…. Waiting around for the how to’s so I too can be proficient… 😳
2021-10-04 19:33:11
14
Stacy :
VLOOKUP is out, XLOOKUP is in!
2021-10-04 17:07:22
14
Natalie Hahlen :
Whew! I was holding my breath making sure I knew each one 😂
2021-10-04 17:01:22
13
Brendin Ketchum :
I always start with sumifs rather than sumif… then it is super easy to add another criteria rather than changing the formula if need be! 😁
2021-10-04 22:10:10
13
michellespeaking :
Failed on the PivotTables. I am sure I need them in my life, I just don't know why or how!
2021-10-04 18:22:25
12
Mike :
Text to columns
2021-10-04 16:59:18
11
lukesaskier :
idex match, vba, power query
2021-10-04 19:24:01
10
Ceejy Wonder :
Conditional formatting
2021-10-04 18:03:35
10
Mr. MeowMeows :
Bombed the proficiency test, but I figured out how to move and resize an image with a cell so now my boss thinks I'm an Excel wizard.
2021-10-04 19:56:29
5
Dave Baker :
I'm so lost
2021-10-04 17:31:56
4
Panic at the discourse :
power query
2021-10-04 17:03:40
4
Myles Rose :
Offsets
2021-10-04 18:41:01
4
Optic Verve :
nah to flash fill. it's speedy, but in the long run you're better off learning how to identify the patterns yourself so you can make more complex ones
2021-10-04 20:15:42
3
Bakazhar :
Gotta be honest. Felt really good to be reading the different types of actions and knowing how to do all of them🥰🥰. Thanks for the vids, helps a lot
2021-10-04 17:02:41
3
DB :
Good list! I’d add Pivot table, find & select Go To Special, and View New Window
2021-10-04 16:51:11
3
shannonsykes828 :
That’s what I came here to learn!
2021-10-04 20:54:32
3
Beth Geiser :
Where my Concatenate gang at??
2021-10-04 19:25:40
3
Mango Fett :
Hlookup?
2021-10-04 18:04:57
3
Lol :
I’m efficient then….. I need to learn vba still lol
2021-10-04 18:42:24
2
wymore20 :
=if(and(knowledge=logic formulas,knowledge=stringing logic formulas),proficient,non-proficient)
2021-10-04 22:49:30
2
Ashley Woolley-Pinko :
the only one i hate is macros
2021-10-04 16:57:04
2
flyersfaninphilly :
Alt + F11
2021-10-04 17:57:54
2
Herbs Derbs :
Sumproduct, power query
2021-10-04 20:15:42
2
user5164998078910 :
Does she even do excel VBA? 😂
2021-10-04 20:14:22
2
Sarah Lou :
My new fav is Xlookup!
2021-10-04 17:04:22
2
Kelly Ray :
XLookup, Fuzzy Lookup, and Power Pivot
2021-10-04 19:29:31
2
tufavoritamorenita :
Ooooo how to lock a spreadsheet.. I feel like it’s so underrated
2021-10-04 19:05:34
2
Custom PINATAS & Props ARTIST :
Im entering the workforce after 15 years. Im just trying to find the Excel Icon on my computer…. Please help 😅
2021-10-04 19:04:37
2
Az Sheridan :
CTRL+D to copy down. CTRL +R copy right. But I mostly love that you’re reply to these comments. 🙌🙌🙌
2021-10-04 18:50:49
2
MinistryOfJoy :
User defined functions, custom properties and new classes, own smart arts…
2021-10-04 18:33:31
2
Albert :
yup so lost ....
2021-10-04 17:49:37
2
ShadowTechFx :
index (match (indirect),match (indirect)) nested in if(and(or)) statements.. arrays advanced filter offset ppl think I'm mad
2021-10-04 18:42:26
1
Austin Dobbels :
Ctrl A, ctrl C, ctrl V, ctrl G, ctrl shift select, conditional formatting, textjoin
2021-10-04 17:51:29
1
Mark :
Vlookup is the only actual useful one
2021-10-04 18:48:55
1
Tom Colón :
I know how to change the date format
2021-10-04 18:48:57
1
To see more videos from user @miss.excel, please go to the Tikwm
homepage.
