Power Automate Part 12 -  Approvals
34:06
Power Automate Part 7 - Conditions
11:43
Python Part 21b - Classes case study
45:10
Python Part 21a - Classes
53:49
10 ай бұрын
Пікірлер
@Dexter101x
@Dexter101x Сағат бұрын
Unfortunately, there's no way in office 365 to do the same, which is unfortunate
@Dexter101x
@Dexter101x Сағат бұрын
Just found it, its now "Excel Add-ins" rather than just Add-ins
@erendiz79
@erendiz79 2 күн бұрын
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.
@pk2k2
@pk2k2 2 күн бұрын
Hi, do you have any idea why GetObject is not working? References are correctly charged. Thank you for your time!
@rjmc64
@rjmc64 3 күн бұрын
I just wanted to say that I really appreciate your videos. They have been very helpful for me!
@sarikasingh4540
@sarikasingh4540 3 күн бұрын
How do I delete excel workbook on SharePoint folder?
@nationfirst-worldaffairs6410
@nationfirst-worldaffairs6410 4 күн бұрын
Plz free just dax tutorial unlock free ...I will Prayer for best wishes 🙏🙏
@sasifexcelsolutions4509
@sasifexcelsolutions4509 4 күн бұрын
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.
@other_stuffs-yj3dl
@other_stuffs-yj3dl 4 күн бұрын
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
@salaiarunmanijb174
@salaiarunmanijb174 4 күн бұрын
how to sort Month-YY in order
@salaiarunmanijb174
@salaiarunmanijb174 4 күн бұрын
How to Sort MMM-YY(Month-YY) format in report builder.
@chaitanyajoshi690
@chaitanyajoshi690 5 күн бұрын
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.
@WiseOwlTutorials
@WiseOwlTutorials 4 күн бұрын
Hi! If you watch the video you can see that the column names can be different on each worksheet. As long as you select them in the correct order in each SELECT statement it will be fine. I hope it helps!
@Merirandomduniya
@Merirandomduniya 5 күн бұрын
It's good, just that I want outlook to do it automatically instead of me clicking the run button every time. Is that possible?
@WiseOwlTutorials
@WiseOwlTutorials 4 күн бұрын
You can! You can write event handlers to run code automatically when something happens in Outlook. Here's a starting point in Microsoft's documentation learn.microsoft.com/en-us/office/vba/outlook/concepts/getting-started/using-outlook-visual-basic-for-applications-to-respond-to-outlook-events
@user-sb5xv5nt6g
@user-sb5xv5nt6g 6 күн бұрын
Truly an invaluable resource! You helped me with VBA at work now it’s time to learn this 🎉
@WiseOwlTutorials
@WiseOwlTutorials 4 күн бұрын
Happy to hear that you've found our videos useful, thanks so much for watching!
@mohamedamro
@mohamedamro 6 күн бұрын
Impressive as usual
@WiseOwlTutorials
@WiseOwlTutorials 4 күн бұрын
Thanks!
@chaitanyajoshi690
@chaitanyajoshi690 7 күн бұрын
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.
@WiseOwlTutorials
@WiseOwlTutorials 4 күн бұрын
Hi! Annoyingly, they're neither Excel VBA nor SQL functions, rather a specific set of functions provided by the Jet database engine. See the excellent answer to this Stack Overflow post for links stackoverflow.com/questions/25226635/vba-function-in-excel-adodb-query
@MasterChelsea
@MasterChelsea 8 күн бұрын
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…((((
@shaikvalli1414
@shaikvalli1414 8 күн бұрын
9:50 Is it possbile to copy the data and add from multiple workbooks
@townnet
@townnet 8 күн бұрын
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?
@HannaKandratsenka-v5t
@HannaKandratsenka-v5t 9 күн бұрын
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.
@WiseOwlTutorials
@WiseOwlTutorials 8 күн бұрын
Thank you so much for the kind comments, happy to hear that you found it useful!
@NS-tp3vr
@NS-tp3vr 9 күн бұрын
Can report builder downloaded for MAC? Or is there an alternate way to open .rdl file in mac?
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi, I don't think that Report Builder is available in a Mac version.
@NS-tp3vr
@NS-tp3vr 6 күн бұрын
@@WiseOwlTutorials ok. Is there any way to open report builder in mac?
@ericheng2381
@ericheng2381 9 күн бұрын
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
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi! You'll need to create some sort of date table that contains an entry for each month and combine this with your existing data. You can see some suggestions on how to do this here: stackoverflow.com/questions/45890909/ssrs-display-all-months-in-a-year-with-no-data stackoverflow.com/questions/44549413/ssrs-how-to-show-all-month-of-a-year-as-x-axis-of-a-graph
@noneyabeezwax8865
@noneyabeezwax8865 9 күн бұрын
YOU are amazing!
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
So are you! Thanks for watching!
@jhunnniemat4444
@jhunnniemat4444 11 күн бұрын
hi, I have questions, why do we need to put exit sub? and when we will usally use it?
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi, you can see a simple example in this video kzfaq.info/get/bejne/j717eNGIrMzIqYU.htmlfeature=shared I hope it helps!
@PadmajaJadhav-vd8cg
@PadmajaJadhav-vd8cg 11 күн бұрын
Best and perfect direct on the point 😊
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Thanks for watching!
@konradstrozak9965
@konradstrozak9965 11 күн бұрын
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
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi! You might find this video helpful kzfaq.info/get/bejne/othndqmLqq-WiXU.htmlfeature=shared I'm fairly certain I mention compound classes in there and it provides various other options for finding elements that you should find useful. I hope it helps!
@nelrosell1
@nelrosell1 11 күн бұрын
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
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Indeed you can! kzfaq.info/get/bejne/gbSkaLF6mtGlkps.htmlfeature=shared&t=1207 Although you need to include the ISBLANK function for Budget as well as for Box Office: OR( ISBLANK(Movies[Box Office]), ISBLANK(Movies[Budget]) ) Personally, I prefer pipes because they work regardless of how many conditions you're using, while OR only works for two conditions.
@MasterChelsea
@MasterChelsea 12 күн бұрын
Sir, thank you a lot for this great video!
@joaofilipecastrosantos9947
@joaofilipecastrosantos9947 12 күн бұрын
You are a champion. You've produced all a student of Selenium VBA needs and you explain it all with great clarity. Thank you.👨‍🎓
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Thank you so much!
@chrisf3577
@chrisf3577 13 күн бұрын
excel 2021 gives me an error when trying to Refresh the tables, do you have any solution?
@gideonglick5808
@gideonglick5808 13 күн бұрын
how about if you want to sort multiple sheets, but the tables are not the same?
@treklin1573
@treklin1573 15 күн бұрын
Very nice accent in teaching channel, I'm not a native speaker of english
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Thanks for watching!
@DBJedi317
@DBJedi317 16 күн бұрын
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.
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi! The add-in does not need to contain Sub procedures (but you can include them if you want to). If you want to use the functions in the worksheet they need to be public. If you don't declare a function as Private, it will be Public by default. I hope it helps!
@shubhamkupade7008
@shubhamkupade7008 16 күн бұрын
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 ?
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Hi! Carry on watching the playlist and you'll get to the videos on optional parameters kzfaq.info/sun/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU&feature=shared I hope it helps!
@vishal_parajuli
@vishal_parajuli 16 күн бұрын
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
@dushanshalina4676
@dushanshalina4676 17 күн бұрын
Xldown is taking all blank cells with formula. How can I correct that?
@other_stuffs-yj3dl
@other_stuffs-yj3dl 17 күн бұрын
have to comment this haha. besides learning vba i love your movie reviews! haha
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
😀 glad you found them entertaining! Thanks for watching!
@charitomexico1830
@charitomexico1830 18 күн бұрын
gracias!!!!!!! por fin solucione el problema con mis encabezados!!!
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Happy to hear that the video helped you, thank you for watching!
@Trucpq
@Trucpq 18 күн бұрын
So helpful and excelent explanation !
@WiseOwlTutorials
@WiseOwlTutorials 9 күн бұрын
Thanks! Glad you found it useful, thank you for watching!
@other_stuffs-yj3dl
@other_stuffs-yj3dl 19 күн бұрын
Wow! As a starter with VBA I'm amazed haha. Thank you for this tutorials!
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
Happy to hear that you found it useful, thanks for watching!
@robertnpmk
@robertnpmk 20 күн бұрын
So helpful, thank you.
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
You're welcome, thank you for watching!
@NilimaParbatani
@NilimaParbatani 20 күн бұрын
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!
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
Thanks so much! Happy to hear that you found it useful so far, thank you for watching and taking the time to comment!
@aindryarya
@aindryarya 20 күн бұрын
Hello!! Can you make a detailed video on how Helper queries work in power BI as well how parameters work in power bi
@MasterChelsea
@MasterChelsea 21 күн бұрын
Sir, your lectures are perfect!!!! THANK YOU SO MUCH!!!!
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
You're very welcome! Glad you like the videos, thanks for watching and for the comment!
@sourabhpatel3834
@sourabhpatel3834 22 күн бұрын
Great❤
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
Thanks!
@likhitaGrandhi
@likhitaGrandhi 23 күн бұрын
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.
@WiseOwlTutorials
@WiseOwlTutorials 19 күн бұрын
Hi! Happy to hear that you enjoy the tutorials. Sorry but I don't know how you'd pass a user-defined table type from Report Builder to a stored procedure.
@voiceless8893
@voiceless8893 25 күн бұрын
I am sorry there no "Join" button at the bottom of any video?
@WiseOwlTutorials
@WiseOwlTutorials 24 күн бұрын
Hi! It could be that channel memberships aren't yet supported in your region: support.google.com/youtube/answer/7636690?hl=en
@ArchStanton806
@ArchStanton806 25 күн бұрын
Hi Andrew, can you help me with the following please? Case Complexity 1 = CALCULATE( COUNT('Cases'[Case Number]), DATESYTD('Cases'[Resolution Date],"3-31"), 'Cases'[statecode] = "Resolved", 'OS Case Complexity'[Value] = 1) I'm getting this error message and no matter what I try I can't fix thing: Couldn't load data for this visual MdxScript(Model) (320, 5) Calculation error in measure 'New KPI Measures'[Case Complexity 1]: DAX comparison operators do not support comparing values of type Text with values of integer. Consider using the Value or Format function to convert one of the values
@WiseOwlTutorials
@WiseOwlTutorials 24 күн бұрын
Hi! Without seeing your data model I would guess the problem lies with this part: 'OS Case Complexity'[Value] = 1 I'm guessing that the [Value] field is stored as text rather than a number. You could either change the data type of the column in the data model, or enter the number as a string like so: 'OS Case Complexity'[Value] = "1" Let me know if that helps!
@ArchStanton806
@ArchStanton806 24 күн бұрын
@@WiseOwlTutorials Thanks, I've modified the value so its now Text and it works. Much appreciated
@WiseOwlTutorials
@WiseOwlTutorials 24 күн бұрын
@@ArchStanton806 No problem, happy you got it working!