Видео

Hello Andrew, I am stuck. I can't find form data for any site. Where should i look.

your training video is great and helps me a lot to Pull data form Closed Workbook, need little help to pull headers too, as you mentioned in your video some headers name not showed , same problem I face and need a solution to pull every header

Unfortunately, there's no way in office 365 to do the same, which is unfortunate

Sir Andrew for what it is worth and if you can live with yourself and also sleep well with this idea, you should succeed sir David Attenborough, he is at a very respectable age, therefore i see a brilliant future ahead for you... You have probably the most excellent and clear British male voice i have ever heard. If people even can't program after watching your lectures, they will certainly learn some advanced level English.

Hi, do you have any idea why GetObject is not working? References are correctly charged. Thank you for your time!

I just wanted to say that I really appreciate your videos. They have been very helpful for me!

How do I delete excel workbook on SharePoint folder?

Plz free just dax tutorial unlock free ...I will Prayer for best wishes 🙏🙏

You are truly the best, I can't think of anyone that does training the way you do, appreciated, is there any way we can get the excel files. Also can you make a video on undo, but not the application.undo one a real undo method similar to the normal way you undo in excel maybe attached to a button.

I completed the playlist! on to user forms :) thanks for the clear and free tutorial for vba. can't wait to use what i learned in my work

how to sort Month-YY in order

How to Sort MMM-YY(Month-YY) format in report builder.

Dear Sir Kindly guide: If I have to consolidate multiple sheets with same type of data but the column names differ across the sheets, can I first rename column names with the help of query itself and then use UNION to combine them? I know how to do it in Power Query, but pl. guide if and how it is possible with SQL/VBA query.

It's good, just that I want outlook to do it automatically instead of me clicking the run button every time. Is that possible?

Truly an invaluable resource! You helped me with VBA at work now it’s time to learn this 🎉

Impressive as usual

Dear Sir Kindly guide whether the functions used in this series like IIF, IsNull, Switch, Format, Year, DateSerial etc. are native functions of SQL or Excel VBA. If they are functions from SQL , kindly suggest if there is any documentation regarding all the functions of SQL.

Great video, sir! Thank you! Can anyone tell me please, how to OPEN the excel attachment in this case??? I can’t figure it out…((((

9:50 Is it possbile to copy the data and add from multiple workbooks

Hi, is possible to not have fix path in the Data Source? The reason is my source file is generated with different name and date every day. Is it got an option excel will ask you to browse the file after you click the button?

I really appreciate the high quality and well-organized content of each session! The author put in a lot of effort to explain each aspect in a very detailed manner.

Can report builder downloaded for MAC? Or is there an alternate way to open .rdl file in mac?

Hi, how to show empty value even if there is no data in Month Column? i.e. show all months including no data in December

YOU are amazing!

hi, I have questions, why do we need to put exit sub? and when we will usally use it?

Best and perfect direct on the point 😊

Hello Andrew, Your videos are fantastic, love the passion in your voice. Actually i have one question and hope that you will help me even though this video is 2y old. But when i put in vba the formula ....FindElementByClass(...).Click i have a debug which says "Run - time error "32" : Invalid selector Error invalid selector From java script error {"status":32 " value : "Compund class names not permitted"} (sessio info: Microsoft Edge = 126.0.2592.87) Driver info: msedgedriver = 126.0.2592.87 and some random numbers and letters.platform=Windows. Do you know maybe hot to repair it ? Thank you for the help

we can also do like this OR(ISBLANK(Movies[Box Office]),Movies[Budget]) as it's only two values are evaluated rather than using two pipes || for OR condition

Sir, thank you a lot for this great video!

You are a champion. You've produced all a student of Selenium VBA needs and you explain it all with great clarity. Thank you.👨‍🎓

excel 2021 gives me an error when trying to Refresh the tables, do you have any solution?

how about if you want to sort multiple sheets, but the tables are not the same?

Very nice accent in teaching channel, I'm not a native speaker of english

2 questions. 1. Can the add-in need to contain Sub procedures? 2. Does if require the Public (ie Public Function or Public Sub)? Thank you.

if i want to see data without select pick start date and pick end date or not providing any default value for date is it Possible ?

How do you create that table folder, actually I am in the ODBS sys DSN connection were I cant able to see database overview etc on the query builder

Xldown is taking all blank cells with formula. How can I correct that?

have to comment this haha. besides learning vba i love your movie reviews! haha

gracias!!!!!!! por fin solucione el problema con mis encabezados!!!

So helpful and excelent explanation !

Wow! As a starter with VBA I'm amazed haha. Thank you for this tutorials!

So helpful, thank you.

this is by far the best series to give confidence to use DAX out of so many other videos i have watched. Great work Andrew!

Hello!! Can you make a detailed video on how Helper queries work in power BI as well how parameters work in power bi

Sir, your lectures are perfect!!!! THANK YOU SO MUCH!!!!

Great❤

Hi, Thank you for your amazing tutorials, they are very clear. It has helped me developing many reports and improve my skills. I have question, Can you please explain how to pass a user defined table type to SP in Report builder? I would really be Grateful if you can help me. Thanks.