Form Controls - Excel for Advanced - Lesson 13

Simply watching the videos is fine, but, if you want to fully benefit from this course, we recommend you do the Excel exercises while watching.

We recommend watching all the lessons from the 'Excel for Beginners' and 'Advanced Excel' courses and then check your skills by doing the Excel Job Interview Tests, which are at the end of the 'Advanced Excel' course.

This video is best watched in high-definition. To change the quality, start the video, then click the cog icon in lower right-hand corner of the screen (Settings), select 'Quality' and then '720p HD'.

...and of course, don't forget to Like, Comment and Subscribe!

[usmankhalid]

Great video. I have seen all of your vidoes for basic so gave a try to watching advanced excel videos. Going to like and comment on all of them. Where can I find lesson 14, 15 and 19 please?

[stephaniehutcheson]

Thank you very much for this awesome video. I do Excel Instruction and I share your link with my class. Very clear, to the point and great examples.

[pennywang]

Very Useful and surprisingly good practice excel files. Love it, Thanks!

[stevereed]

Great video, thank you. Is it possible to use Spill ranges with Form controls

[TheBobby]

Fantastic. It would have been more efficient if you could have gone a bit slower. Remember, this stuff is new to us - that's why we are watching these videos :)

[carlswift]

The Exercise file link does not work would love to have access.

[QuoteHriday]

why i cannot open form control file in mobile version of excel? Please Help me out of it..

[gerrypomanski]

Trying to convert the vlookup to xlookup in form control 5, Cant seem to get it right. Formulae "=IF(D2=2, (XLOOKUP(D3, C19:E19, C21:E32)), (XLOOKUP(D3, F19:H19, F21:H32, "")))". Any help on this?

[its_kumar_Neeraj]

Plz upload practice file too with video.
Thanks

[pravachanmala]

Nice video but i can't open form control file in mobile excel please help me out of it.