Excellent channel. Having been disabled by serious illness and losing my Analyst job, I'm trying to keep my current Excel skills up to date and learn new ones....so Thank You.
I needed to reverse the order of the Wine Sales Commission calculation to =$C$1*B4 in order to get a positive value. Otherwise for some reason it resulted in a negative value....
Thanks, Sir. This is such a wonderful and appreciated contribution. But I see six thumbs down. Well, there should be six videos out there better than this one. I'm sure there are not. This is something that moves society along. Thanks for your hard work. You're like the scrubbing bubbles commercial. You figured it out. So we don't have tooooooooooo. Sparkling. Gleaming. Wow. Feels like a lottery win. Humbling. Now back to your Pythagorean computer theorems. See you next year. I should be understanding it by then. Ha ha. 🤔?
I circumvented this by ignoring the produced list, copying the offset formula from the formula bar & using that to rename the Defined name ranges in name manager So just ignore it imo. It's probably an updated excel function & acts differently now compared to before 👍
You talk to much Sir, stick to skill to learn only, this will shorten your video. I have seen Liela Videos, she talks straight and to the point. Thanks
Excellent channel. Having been disabled by serious illness and losing my Analyst job, I'm trying to keep my current Excel skills up to date and learn new ones....so Thank You.
You are welcome and we hope you get well soon!
You have made very interesting video. I knew most of it, but I wish someone showed me those things few years ago.
Excellent explained, excellent examples and these are really cool, but also advanced things. Thank you very much
You're very welcome!
As always, very useful content! Thank you!
Glad it was helpful!
I needed to reverse the order of the Wine Sales Commission calculation to =$C$1*B4 in order to get a positive value. Otherwise for some reason it resulted in a negative value....
Thanks, Sir. This is such a wonderful and appreciated contribution. But I see six thumbs down. Well, there should be six videos out there better than this one. I'm sure there are not. This is something that moves society along. Thanks for your hard work. You're like the scrubbing bubbles commercial. You figured it out. So we don't have tooooooooooo. Sparkling. Gleaming. Wow. Feels like a lottery win. Humbling. Now back to your Pythagorean computer theorems. See you next year. I should be understanding it by then. Ha ha. 🤔?
Very useful, thank you so much Sir.
You are very welcome!
Thanks for your efforts, waiting for more videos in advanced excel , thanks again
1:03:12 Has some interesting info about stocks, but can't seem to do this as well with the formatting changes from Google
I am not able to import data from web. When I try to import it shows me some html code and not the data as it is? What might be the reason for this?
Hi Mansi, our instructors are available to answer questions at Offsite our online community - bit.ly/2RHRbzz
When I use offset function it displays the full list ie Month, what have I done wrong??
I circumvented this by ignoring the produced list, copying the offset formula from the formula bar & using that to rename the Defined name ranges in name manager
So just ignore it imo. It's probably an updated excel function & acts differently now compared to before 👍
You talk to much Sir, stick to skill to learn only, this will shorten your video. I have seen Liela Videos, she talks straight and to the point. Thanks
Thanks for the tip
Hmmm assigning ctrl +t to that macro is maybe not the best practice.
How to turn on the calculated item? Mine is greyed out. Can someone please help?
17:46 When I tried to select DynamicUnits it does not show anything under series values? Can someone please help me out? What am I doing wrong?
Did you create your own named range or you tried using pre-made list already in the excel file?
Is there a video about "Excel Power User Expert" level?
There is not. This is the last in this series. We do have a new update 2021 version coming soon however!
thanks!
7:00 Is the “-1” really needed?
Yes, because it is counting everything on the column, and you don't want to count "mouth"
any example file to work on?
It's in the previous video of this series "Excel Power User Beginners"
ເຈົ້າຂອງຈີນແຜ່ນດີນໃຫຍ່.ແຜ່ນດີນໄທ-ລາວ.ສາວງາມທົວໂລກ.ໂຫລ່ບີ່ນໂອ່ສະກ່າອິດຊາລາເອວ
I am unable to download the exercise files. Please advise
Hi Kamal! We just tested the link and it is working fine currently
ເຈົ້າຂອງຈີນແຜ່ນດີນໃຫຍ່.ແຜ່ນດີນໄທ-ລາວ.ສາວງາມທົວໂລກ.ໂຫລ່ບີ່ນໂອ່ສະກ່າອິດຊາລາເອວ
ເຈົ້າຂອງຈີນແຜ່ນດີນໃຫຍ່.ແຜ່ນດີນໄທ-ລາວ.ສາວງາມທົວໂລກ.ໂຫລ່ບີ່ນໂອ່ສະກ່າອິດຊາລາເອວ