Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
546 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
We've published an impressive 581 training videos on this website:
Our video training series for Business Intelligence products include videos on Power BI Desktop, Reporting Services and PowerPivot.
We've got a series of videos teaching you how to program in Visual C# (if ever we get time, we do intend to publish an advanced series …).
Our videos on all things Excel includes a series of quick tips, detailed videos on every aspect of VBA programming (including user forms) and even a series of videos on using PowerPivot.
Our training videos for Business Intelligence products cover all aspects of creating flows in Power Automate.
We have the following miscellaneous videos on our site:
Our Power Apps videos teach you how to create canvas apps from scratch.
We aim to create a full set of tutorial videos on both Power Automate and (separately) Power Automate Desktop, so this list should grow quickly over time.
We have tutorials on how to use Power BI to create reports, and on DAX to create measures.
Our Power Platform videos are currently on Power BI and DAX only.
Choose your programming language! We've got masses of videos on SQL, a whole series of training videos for VBA (including user forms), a set of videos showing you how to program in C# and even a video series including the use of DAX within PowerPivot.
Our Python videos are designed to get you up and running writing Python code as quickly as possible.
We've included our SSRS videos below too, since Report Builder and Reporting Services are such simliar products.
As well as a series of 30 or so videos showing you how to program in SQL (from writing simple queries through to creating complicated stored procedures), we've also got videos on how to install and use SQL Server 2016.
We've got videos on most aspects of SQL Server, including SQL, Reporting Services and Integration Services.
At the moment we've just got an introductory series of videos for SSIS, although this does encompass everything that the average SSIS developer will ever need to learn.
It doesn't really matter which version of SSRS you're using (provided it's not before 2008 R2) - you'll find both the 2012 and 2016 video series useful. We've also included our Report Builder training videos below, since this is such a closely related product.
Whatever you're doing in VBA, we've probably published an online training video for it! We've split the videos on creating and using user forms into a separate series.
You can watch any of these videos anonymously and free of charge, whether through this website or via our YouTube channel.
From: | Deon M |
When: | 03 Mar 21 at 17:41 |
Hi Andrew
Your YouTube videos already have tens of thousands of compliments, but I want to add that you are not only the best VBA or coding instructor, but simply the best teacher of ANY kind that I have ever seen. (I'm fifty and have 2 degrees.) The fact that you make this content freely availalble is mind boggling. Your videos have taken me from basically no coding experience to writing very complicated business-critical applications... and actually knowing 99% of what the code is doing. (It has also taken hundreds of hours of my life and wasted a year's worth of Netflix subscribtions!)
Your older videos on web scraping and the recent series on Selenium have been especially useful to me recently. I have a specific need to regularly synchronise / ftp a local folder/files to a web server and can't really find anything useful or recent on the topic. It appears that WinSCP (see https://winscp.net/eng/docs/library_vb) offers a useful dll that will allow extensive control of this. They also offer some VBA code examples on how to implement it...but, unfortunately, it is still a step too far for me.
I realise you must have a long list of topics, but perhaps control of this function / dll will be useful to many. There really is no other content around about this.
Regards
From: | Andrew G |
When: | 04 Mar 21 at 08:13 |
Hi Deon,
Thank you so much for the kind words! It's very rewarding to hear that the videos have helped people so thank you for taking the time to write down your thoughts, it's very much appreciated.
You're correct about the long list of topics - it only ever seems to grow! I'll freely admit that I'm not an expert in FTP using VBA but this topic has been on the list for some time already. I'm reasonably certain that it's possible to do this using some Windows API functions rather than third-party software (although WinSCP does look pretty helpful after a brief look).
I'll try to find time to get something working - no promises though!
From: | kishor0025 |
When: | 28 May 20 at 07:49 |
Hi Andrew,
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?
From: | Andrew G |
When: | 29 May 20 at 10:53 |
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!
From: | kishor0025 |
When: | 01 Jun 20 at 09:44 |
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.
From: | Rachel Owl |
When: | 03 Jun 20 at 09:59 |
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.
From: | JeffF |
When: | 04 Oct 19 at 18:04 |
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.
From: | Andrew G |
When: | 07 Oct 19 at 08:16 |
Jeff, that's such a lovely thing to read. I'm so happy to hear that the videos helped you to find a role that you really enjoy! Thanks so much for taking the time to post your feedback, it's very much appreciated. All the best,
Andrew
From: | AceAxe |
When: | 11 Apr 19 at 17:02 |
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!!!
From: | Rody |
When: | 16 Jan 19 at 08:12 |
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.
From: | Andrew G |
When: | 17 Jan 19 at 06:53 |
And a thousand thanks for taking the time to write such a glowing review, thank you!
From: | zeddine |
When: | 19 Feb 18 at 00:17 |
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
From: | balajivenky |
When: | 22 May 17 at 15:24 |
Hi Andrew,
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.
From: | Andrew G |
When: | 25 May 17 at 13:17 |
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!
From: | Arman |
When: | 13 Apr 17 at 22:24 |
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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.