Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

[youngcharlie36]

Hi there, I hope you might be able to refer me to one of your videos, I am a complete novice with excel, but I want to create a database on like sheet two, and have a smart looking front sheet 1 with a search box that I can use to search the data that has been collected. Any suggestions?

[ExcelIsFun]

I don't have a video on the 'Form' feature to search a database. But the Form is not 'Smart looking or very useful'. If you wanted to use a 'Form', you have to tell me what version of Excel you are using. If you want to do something custom (which is preferable) you must use VBA code. I am not good with VBA code. The best place to ask questions about Excel VBA code is:

mrexcel[dot]com/forum

[youngcharlie36]

@ExcelIsFun Thanks, I ended up using Vlookup which is working ok, however I have set it up to search names and you have to have an exact match to find the result which is not very helpful

[ExcelIsFun]

Exact Match is fine when you have names!

[robinmitra1]

Man ur channel is the best! keep rockin!

[ExcelIsFun]

I am glad that you like it!

[GeneralApathyNonFan]

Mike, what are your thoughts on MCAS certification? I got SAS certified (at the most basic tier) and no employer gave a care. From what you've heard and read, are employers attracted to candidates that have those letters or do they react with a "meh"?

Thanks in advance. Love your vids -- I've learned more in the last two weeks than my entire college career!

[ExcelIsFun]

I have zero ideas about the topic of certification. I am not familiar with any of the certification processes and I have no certification myself. I just never got around to get any certification myself.

You might search for a YouTuber named PrincessWithSkills. She is a fellow Excel YouTuber that knows something about certification.

[Accounting010203]

Thanks!

[ExcelIsFun]

You are welcome!

[kmvspratt]

Thank you so much, Your Youtube videos have helped me so much with my spreadsheets assignments for college

[ExcelIsFun]

I am glad to hear that! That is why I put them out there! Remember to rate, rate, rate!!

[kmvspratt]

Just rated this vid as Awesome :) will do the same to all of your vid's I view :)

[ExcelIsFun]

Thanks! The higher and the more the ratings, the higher the video will be ranked and the more that people will get to have fun with Excel!!

Thanks!

[Mynotoar]

You finally got the Beta channel :P. Good for you, Mike.

Any more thoughts on la grande mille, the big 1000, one-treble-zero, 10^3?

[ExcelIsFun]

Not, yet. But I will do it for the 1000th Excel one (since I have some family videos posted also). I have to figure out which is the Excel 1000th - it is aproximately the 1055 video...

Maybe I will have my 3 1/2 year old do an Excel video for number 1000!?

[DP2009KJ]

U r the best TEACHER in teaching EXCEL i salute u. R u part in Microsoft team(EXCEL)?

[ExcelIsFun]

I am not part of the Microsoft Excel Team. I am just a guy having fun with Excel!

[Mynotoar]

Why did you reply to my comment? It's mike you want to reply to.