Look Who it Was Random video

Excel - Master Excel with 12-15 Pro Tips | Excel Tutorial & Free E-book Download - Episode 713

1,480 views · Published 18 February 2009 · 3:34 · Indexed 29 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Master Excel with 12-15 Pro Tips | Excel Tutorial & Free E-book Download.

Welcome back to the MrExcel netcast! I'm Bill Jelen and today we're talking about some exciting updates and tips for Excel users. First off, I want to share a cool gift I received from a client in Louisville - a personalized Louisville slugger bat with my name on it. How awesome is that? Speaking of Louisville, I recently did a seminar there and created a video showcasing my favorite tips from the event. This video is now available for everyone to watch on our website, mrexcel.com/video2003.html. It's a quick six and a half minutes and includes 12-15 tips that will make you a pro at Excel. Plus, there's a link to download the e-book for free. So, make sure to check it out and share it with your co-workers who could use some Excel tips.

But that's not all! We also have a new page on our website, mrexcel.com/excel_video_training.html, where you can find all 600 of our previous podcasts. That's right, no more scrolling through iTunes to find the older episodes. And to make it even easier, we have a flash viewer so you can watch the videos directly from Google. How convenient is that? 

Now, onto today's tip - Data Validation woes. We all know how useful Data Validation can be for creating drop-down lists in Excel. But have you ever noticed that you can't type the first letter of an item to jump to it like you can with other drop-downs? It's a frustrating limitation that many users have brought to my attention. So, I'm asking for your help - if you have a workaround for this issue, please let me know in the comments. Tomorrow, I'll be sharing the best solution I could come up with. 

Thanks for tuning in and don't forget to spread the word about our video 2003.html site. It's a great resource for anyone looking to improve their Excel skills. And as always, stay tuned for more helpful tips and tricks from MrExcel. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


In Episode 713, a link to http://www.mrexcel.com/excel_video_training.html
another link to http://www.mrexcel.com/video2003.html 
Then, how to set up a dropdown list in Excel, but some frustration that the dropdown list won't let you type the first few letters of the value.

Table of Contents:
(00:00) Introduction and explanation of the baseball bat
(00:31) Discussion of two websites, including mrexcel.com/excel_video_training.html
(01:04) Introduction to the Louisville-related site, mrexcel.com/video(01:28) html Description of the video with 12-15 tips for Excel
(01:57) Excel tip for the day: frustration with Data Validation
(03:00) Request for ideas and announcement of tomorrow's solution
(03:10) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Data Validation frustration
Drop-down menu
Excel 2007 version
Excel video training
List of valid answers
Louisville slugger bat
Louisville-related site
Tips for Microsoft Excel
Typing first letter in drop-down
User forum for problem-solving
Workaround for Data Validation


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152186/

More from this channel