Ring the Bell… School’s in
Introducing ExcelCampus.com’s fearless leader Jon Acampora. Jon is a surfer/analyst from sunny southern California. He is a recent Excel MVP and is best known for the solutions and Add-ins that are available on his site. During our interview, Jon explains what an Add-in is, and how he learned to build them. He started with Excel straight out of college, using Excel for Accounting, Finance, Inventory management, etc. He further discusses when you are in “add-in territory” and when you are not. Jon started learning to build Add-in by recording macros and deconstructing them. This is a good interview for the wannabe Excel programmer.
Win a FREE Copy of Tab Hound
In the first few moments of the discussion, Jon announces that he is giving away a few copies of his Excel Add-in TAB HOUND that was released the same week. To win, you have to comment one the strangest ways that you have used VLookup. Scroll down to the comments section to see several of the entries. Pickle-flavored drink? Seriously? 🙂
The Good Ole Days
Remember Clippy? What about that Wizard in the turbine that used to pop out of Excel and ask you about your day? Remember the dog/puppy? The days before the ribbon and the million rows? In this episode the panel discusses how Excel used to look and changes in the form and functionality throughout the years. The good and the bad.
Where to find Jon:
- Website: http://ExcelCampus.com
- Newsletter: http://excelcampus.us7.list-manage.com/subscribe?u=06002626c1f028fc9d1d1a1f1&id=1570cf8368
- Youtube: https://www.youtube.com/user/ExcelCampus
- Facebook: https://www.facebook.com/ExcelCampus
- LinkedIN: http://www.linkedin.com/in/jonacampora
- Google Plus: https://plus.google.com/+Excelcampus1/posts
What to do next:
Follow us on our social channels. Also, head on over to Jon’s Excel Campus site and check out his add-ins and his blog. Lots of good stuff over there. Also, right below you will see a newsletter sign up form — put your email in to get access to our new episodes as they become available. Don’t be the last kid on your block that knows what’s going on with Excel TV. All the cool kids are doing it.
- The Comprehensive Guide to the Excel Ribbon: Making the Most of Your Data - January 31, 2023
- 51: Oz du Soleil & the Global Excel Summit 2021 - February 8, 2021
- 50: Randy Austin – Excel for Freelancers - January 22, 2021
excel 95 about 15000
I work in the supply chain industry and I constantly use VLOOKUP to look up case configurations for the various consumer packaged goods companies that we bid. One of the strangest products I remember doing a VLOOKUP against was a pickled flavored beverage.
I always wondered what people did with the pickle juice left in the jar. Who knew anyone would want to drink it. 🙂 Thanks Ryan!
James, great to see you here!
To Rename a sheet
Alt + O + H + R
Yes, that’s the one I can never remember… 🙂
Thank you all for having me!!! It was a true honor to be a part of the show! I can’t wait to read some crazy VLOOKUP stories!
Thanks for making the time for us, Jon. It was a great and fun episode. Now, let’s see how much Tom Hanks would cost is. 😀
Haha! I’m sure he would do a straight-up trade for one of those yo-yos of yours. 🙂 I didn’t see those during the broadcast, but that’s a pretty cool collection you got there!
I had a blast! You guys are hilarious. Looking forward to next time, and 100 more episodes from Excel TV!
Yup! And there are more yo-yos that don’t fit in the case.
Man! You take me back. Since you grew up in Cypress, you’ll know that intersection, Katella & Valley View where I’d catch the bus and go into Long Beach.
Ha! I used to catch bus #46 on Valley View to go the other way to Buena Park for a job I had in high school. Small world! 🙂
Why was Rick talking about crazy VLOOKUP stories anyways? Well, I think it had something to do with a blog post I wrote about vlookup at Starbucks. It’s an introductory explanation of vlookup using a Starbucks menu. For those that are already experts at vlookup, this might help you explain the function to co-workers or clients. And yes, you can replace Starbucks with your favorite beer menu. Although we might need a function that returns multiple values for that…
http://www.excelcampus.com/vlookup-starbucks
As we mentioned in the episode, anyone that leaves a comment about vlookup will be entered to win one of three free licenses I’m giving away for my new Tab Hound add-in. You can watch videos about Tab Hound and Tab Control at the following link.
http://www.excelcampus.com/tabhound
I explained a few tips during the episode, but after watching the video playback I realized you can’t see much of what I was doing on my screen. My apologies and I will get that figured out for next time. Fortunately, I have videos and blog posts on those tips. You can checkout the links below for more details.
http://www.excelcampus.com/visible-cells
http://www.excelcampus.com/compare-lists-pivot-table
Please let me know if you have any questions. Thanks! 🙂
I used VLOOKUP to findout how many of the girls I am interested in are on the list of the ones I actually dated 😉 😀 hahaha
Haha! That’s a good one Rahim! I bet you were happy when Excel extended to 1 million plus rows in 2007. 🙂
Hey Jon,
The craziest stuff I so with vlookup is fuzzy matching
I don’t need to use any UDF or any other add-in for it,
Simply using wild card mostly * asterisk joined by & ampersand
Vlookup value. “*”&lookupvalue&”*”
Cheers
Jamil
That’s awesome Jamil! I don’t think I’ve ever used a wildcard like that in a vlookup. Thanks for sharing.
VLOOKUP does lookup to the right. I used VLOOKUP combined with CHOOSE to lookup values that are to the left.
That’s a great alternative to Index/Match. Mynda Treacy has a great article on how to create the Vlookup/Choose formulas.
http://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose
Thanks Maxime!
I can’t find any personal weirdest or craziest use of Excel so I will post about the dumbest way I have used it for:
1) A calculator
2) A list maker
Those might sound dumb or basic, but probably the most common uses for Excel are a list and a calculator. Thanks for sharing Jorge!
The most common uses for Excel are a list and a calculator very important key of Ms Excel. Thanks for sharing Jon Acampora!