Practicing the most important Excel function: VLOOKUP! “Hold your horses Shir! I don’t know how to do a VLOOKUP!” No problem, check out this post: The Most Important Excel Function You Will Ever Learn Alright sparky here’s the deal… You’ve got month numbers and you want to show them as month names. Simple enough right? Sure …
In the previous post (The Most Important Function You Will Ever Learn) we looked at the VLOOKUP Function in detail. Now we’re going to take it up a notch, Emeril Lagassi style. “So Shir, I’ve got a list of values and I want to know which range it falls under.” Sounds like the perfect job …
FACT: Out of 400+ functions in Excel, VLOOKUP has been selected as THE indicator of Excel skills. Don’t look at me, it wasn’t my decision. So let me ask you this… Can you do a VLOOKUP? If your answer is “no,” or a lukewarm “kinda sorta,” this video is perfect for you! In this Excel VLOOKUP video tutorial, …
I've already tried my Haunted House Method for learning Excel Shortcuts on a handful of students, and on average they increased their retention by 419%.
Here's the 1st part of what could potentially turn into a 12 part series of memory tricks to learn the top 60 Excel shortcuts.
Here’s what happened last time on ExcelShir in case you missed it: The Ultimate Time Management Hack that Took Me 5 Years to Create – Part 1 And now, the conclusion… 4. Medium Focus Time (4MFT) What is 4MFT? I realize the word “medium” can be very subjective, so for me it means time in …
