VIDEOS BY CATEGORY
VIDEOS BY AUTHOR
Wise Owl: Microsoft computer training videos
We've published 300 online training videos on our website - choose a category from the menu to see some of them!
Each of our videos begins with a cover slide:
A typical cover slide, showing what the video will cover.
This is followed by a list of contents:
The contents page showing what the video will cover.
As soon as possible, the video then begins to pass on its learning goodness to you, the viewer!
All of our videos were written by Andy Gould or Andy Brown, who have both been running classroom training courses for longer than they care to remember.
I'm very impressed with your teaching style. I want to learn these below topics from you. Can you please upload 2 videos on these topics?
001) How to auto fill Web Form using Excel Worksheet Data through VBA? Once it fills up the entire Form, the Submit Button (in Web Form) will be clicked automatically to store the Data in Server. And, then proceed to the next Row of Excel Data. This is how the entire procedure goes on till it reaches the Last Cell in Worksheet.
002) How to convert Word to PDF, PDF to Word or Excel to PDF and PDF to Excel using VBA?
Hi there, we do already have a video on saving an Excel workbook as a PDF which you can see here https://www.wiseowl.co.uk/vba-macros/videos/vba-files-folders/save-as-pdf/
The technique for Word is essentially the same, using the ExportAsFixedFormat method.
It's unlikely that I'll create a video to answer your first question but we do have videos on the individual techniques you'll need to make this work. We have a whole section of our online training course devoted to looping through collections https://www.wiseowl.co.uk/online-training/excel-vba/collections-for-each/
We also have several videos which describe how to work with websites using VBA https://www.wiseowl.co.uk/vba-macros/videos/vba-scrape-websites/
All you have to do is put it all together! I hope that helps and thank you for your comments!
Thank you Andrew, You've always been my inspiration. What you've been doing for Human, cannot be expressed in words. After learn VBA, I wish to go for Python and Oracle to boost up my career. Because, in our country India, these 2 languages are in demand most for Data Analysis. Hope, you'll uploading videos on these 2 languages on YouTube in near future.
On behalf of Andrew, who is temporarily furloughed, thank you! I don't think we will ever do Oracle, but Python is a good possibility.
I would like to thank you all for wonderful job you have done.
I am 54 years old and I'm from Moscow. I started to learn VBA a few month ago and realized that it's almost impossible to find fine courses for VBA in Russia and on areas of the World Wide Web. Fortunately I've found your web-site and what can i say - you are brilliant.
Special thank to Andrew Gould. He is my hero from now.
Thank you all!!!
Thanks so much for your tutorials. It shaped my knowledge on excel vba. I would like to know if any chance to create tutorials on creating DLL files & using it in VBA macros, will be very useful for our community. I see there are no good training materials available on tihs topic.
Hi, I'm happy to hear that you've found the tutorials so useful. As to the topic you've suggested, it's not possible to use VBA to create a DLL so you'd need to learn another language in order to do this, perhaps VB or C#. You can find quite a few resources on this topic already - here's the first link Google returned to me http://www.geeksengine.com/article/create-dll.html
I hope that helps!
I'm very much impressed by Mr.Andrew Gould .He is indeed the best teacher (with very calm voice and amazingly impressive teaching skills) iIve ever come across. He is very engaging and the way he teaches us (whether its SSRS,SQL or SSIS) is very learnable. I thank Wise Owlfor making efforts like these for people they actually don't know..Unknowingly theyre helping people to get a decent livelihood irrespective of their nationality,religion or race.Thank you!