This is SUPER helpful for using Excel. Thank you!
wait wait, i usually use F1 driver's name too for exercise 😂
Got to love data validation!
Data validation shortcut key is awesome 👍😎
SO USEFUL, THANKS A LOT
Is it weird that I only knew the suggested answer to the hard question? I don't typically use notes or create anything dynamically in excel(but knew methods for achieving something similar) but data validation is 80% of my job most days so this that trick has been one of my go to's for years.
For the duplicate exercise , one must first ensure that there are no duplicates in each of the lists separately . Otherwise, values will be highlighted without being in the two lists
Will use all 3 of these tips! Was able to recreate each 1 easily from tutorial.
Thank you so much I thought I have to learn vba for second function🎉🎉
Extra points for F1 reference 👏
how to remember all these shortcuts?
Excellent
Thanks so much
Is it weird that I knew Q3 but I didn't know Q2?
Thank you!!!
THANK you so much!!
I knew 1 & 2 ! Hahaha I feel smart.
I knew the intermediate and hard but not the easy 😅
Please explain what is data entry and retrieving data from other devices
@KenjiExplains