I have error with this given me that I have problems with Bing
@abdulwahedissa.817511 күн бұрын
Great
@belencortez5975Ай бұрын
OMG!!!!! You're a life saver. Thank you a million times over.
@carolinecostaBR3 ай бұрын
Amazing class, thank you!
@DragoneSteez3 ай бұрын
How can you make the labels in the ribbon appear on a mac? ... on a mac, typically the command key is subbed for the alt key when using shortcuts. But hitting the command key does not bring up the labels like alt does on a PC.
@quantitysurveyorexposed10283 ай бұрын
just wondering, in the logic formula, 1st logic if greater than 35000, 2nd is greater than 30,000, thus the 1st logic falls to 2nd logic? anything that is greater than 30,000 will result as large, it means 30,001 up include 35,000
@Chris-at-Maven3 ай бұрын
Yes Excel will check the logic top to bottom, and stop as soon as the criteria is met.
@gadnziramakenga32036 ай бұрын
EXCELLENT
@RayKomai7 ай бұрын
Thank you so much. Very useful. Cheers
@Propelledfeline8 ай бұрын
How do I get rid of the extra +4 on zip codes quickly? I work with data that contains both zip code and zip code +4 but I need it all to be just zip code.
@tomada369 ай бұрын
My laptop doesn't have an 'Alt' key, but is there another way to do it?
@webimpactcompl11 ай бұрын
5:38 and theres edate formula, so we dont have to overcomplicate things
@remon037 Жыл бұрын
Thanks for the tip. After watching your video, I discovered that you can apparently also add extra spaces to the formula without any problems, making your nested formulas even more clearly visible through indenting.
@republikadugave420 Жыл бұрын
7:40 holds true if you insert a cubemember into a cubevalue formula and reference a cell in square bracket followed by "&C4&"for example... i actually use this trick to change things cubevelue is referencing with data validation list..
@neeleshapatil Жыл бұрын
What would be additional changes to this implementation if goal exceeded than actual to show it visually?
@AlexandreAlezzia Жыл бұрын
Excelente Video!
@harshvardhanselot7248 Жыл бұрын
Thanks. helped me. i used to think how do they do this. but nnow, because of you, i know.
@nikhilsoni1177 Жыл бұрын
Bring more vedio like this. #request
@cwnmaster Жыл бұрын
Can we use multiple 1 label filters - Based (a) one one field (b) multiple field -- 2Same question , but value filters ?
@mdshahzada693 Жыл бұрын
We are deliberately pulling the value for the 2 nd instance. How would this ensure that the order came from the store in 2nd store? What if the order is from store in the 1st instance?
@fadhlipratama2940 Жыл бұрын
Great video..thanks
@thangaveluraj Жыл бұрын
Excellent.. Thanks a lot, request to do more sequels
@emirosmic8668 Жыл бұрын
Would it be possible to get this file for him to download?
@ZbynekKysela Жыл бұрын
I tried Notion, Obsidian, Access, and even MySQL; just to find out that old good Excel can handle this kind of operations best. Many thanks, mate! 👍😁
@youjohnny16 Жыл бұрын
Maven rocks.
@dalskiBo Жыл бұрын
Thanks, short & sweet
@brightafghans2886 Жыл бұрын
Thank you sir
@royally254 Жыл бұрын
Whoa! You don't answer questions!
@andrelima7698 Жыл бұрын
does not work anymore, excel does not accept the single quote
@lukev730 Жыл бұрын
Awesome 👏 thanks
@johncallahan2447 Жыл бұрын
I just completed a Business Analytics Class and found the most difficult part was setting up the model pulling info from a paragraph containing the constraints. In your class, how much time is spent on organizing provided information and structuring it into the model?
@gbetter Жыл бұрын
this was a great explanation. good stuff!
@mamamtl Жыл бұрын
Question: isn't it faster to use F5 instead of Ctrl-G?
@johnpoe3791 Жыл бұрын
Very good. I came in analyzing for one problem and resulted in solutions for an unrelated problem as well.
@User_Notion Жыл бұрын
Can't we do this easily with Xlookup now? With search from last to first option?
@brightafghans2886 Жыл бұрын
Thanks for this.
@paulle15532 жыл бұрын
Hi Chris, do you know if it's possible to have multiple filters (either multiple text filters or multiple number filters) and showing subtotals for each filtered category? Or excel wouldn't allow that? For example, in this sample file, I want to see sales for movies with names starting in D and in T with subtotal for each category. I know I can do that manually, but I am trying to learn if pivot table can do it for you. Thank you.
@SpinDlsc2 жыл бұрын
Perfect for assigning alpha-numeric values in your cells, along with having images so as to still be able to sort by the image based on the cell's actual alpha-numeric values. Thanks!
@OFWCREATOR2 жыл бұрын
Hope you share the sample data, love you.
@sankarpadarthy60742 жыл бұрын
Excellent presentation sir. Was very helpful. Thank you
@henrikmanukyan31522 жыл бұрын
Your videos must be praised !! Awesome man, thx)
@jonathanchristensen81792 жыл бұрын
Love this clip, implemented no problems, thank you. Question i have though is... is it possible to combine Months together for a number of years, for example I have January 2020, 2021, 2022 and i want them all next to each other rather than at the start of each year, i don't know how to do that with these charts?
@johng52952 жыл бұрын
Thanks in a million. Great content. Awesome. Very well explained. I couldn't find this explanation--simply put anywhere else. Great teachers are hard to find. Grade: A++💥
@lonewolf30572 жыл бұрын
Thanks
@olga18862 жыл бұрын
Thank you so much for this - I'm stuck at the stage where I have the 100% stacked columns and my gap width is 0, but there's still a gap between them. I'm guessing that's because my time series is quarterly. What would be the solution to this? Can't change my time series. Thank you!
@ExcelMaven2 жыл бұрын
Hmm, one option might be to format your axis and change it from "date" to "text". That should prevent Excel from treating it as defined time periods and adding those spaces - give it a shot!
@jsprowse2 жыл бұрын
There is no synchronous scrolling option for Excel 2019 for Mac that I can see.
@muradsawalha55292 жыл бұрын
The BEST Excel instructor of all times
@AlxzAlec2 жыл бұрын
please just tell me what button to click in order to turn it off