VIDEOS BY CATEGORY▼
VIDEOS BY AUTHOR▼
Wise Owl: Microsoft computer training videos
We've published 338 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.
Andrew, I did not go to school for any type of coding. I was previously an account support agent taking phone calls. One day I ran across your videos online and several hours later (due to binge watching) I found myself writing my first bits of code. I rewatch bits of your videos on a weekly basis to refresh in parts here and there. Because of wise owl I am now employed as a business analyst with the same company, my primary role is to automate work that deals with spreadsheets of data and connect over to our SAP system. Wise Owl VBA videos have taken me to where I am now and I have nothing but the highest praise for the work you have done making them. I enjoy my job a great deal, I love to hear how excited people get when I tell them I can automate a task that they are doing manually. I also enjoy playing around with VBA to create things like, my own version of Yatzee with dice you can roll. I cannot thank you enough.
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!!!
I saw and watched the videos of Andrew Gould about VBA. At first, i just wanna try few samples as I am discouraged watching videos I can't follow. But his videos were...top of the line. Everything is clear and most possible scenario that you might encounter like mistakes you might do or errors you might encounter were explained in advance.
I can't help myself watching the next video so I am here having no strength watching for almost 4 hours straight.
This is all Andrew's fault!
This is the best video series I have ever seen in any tutorial videos. The explanations were clear, a little fast but excellent voice. Really happy I saw his video tutorials. Too bad I am on the other side so can't join at least one of your site trainings. A thousand likes to your video tutorials.
I have seen a few of Andrew Gould's VBA training videos online and feel compelled to congratulate him (and I'm sure there are other contributors too) for such an excellent piece of work. I am due to fly out next week to Mauritius for my annual long break and this year it will be spectacularly good, lying on the beach, whilst trying to teach myself VBA .... not sure if I want to thank Andrew for this !!! But on a positive note, this is the best training videos I have seen for a long time. Keep up the good work. I will spend more time looking at your website to see what else you all do and more importantly to spread the good word about you guys. Cheers. Azeddine
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!