Amazing class, thank you!

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.

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

EXCELLENT

Thank you so much. Very useful. Cheers

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.

My laptop doesn't have an 'Alt' key, but is there another way to do it?

5:38 and theres edate formula, so we dont have to overcomplicate things

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.

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..

What would be additional changes to this implementation if goal exceeded than actual to show it visually?

Excelente Video!

Thanks. helped me. i used to think how do they do this. but nnow, because of you, i know.

Bring more vedio like this. #request

Can we use multiple 1 label filters - Based (a) one one field (b) multiple field -- 2Same question , but value filters ?

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?

Great video..thanks

Excellent.. Thanks a lot, request to do more sequels

Would it be possible to get this file for him to download?

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! 👍😁

Maven rocks.

Thanks, short & sweet

Thank you sir

Whoa! You don't answer questions!

does not work anymore, excel does not accept the single quote

Awesome 👏 thanks

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?

this was a great explanation. good stuff!

Question: isn't it faster to use F5 instead of Ctrl-G?

Very good. I came in analyzing for one problem and resulted in solutions for an unrelated problem as well.

Can't we do this easily with Xlookup now? With search from last to first option?

Thanks for this.

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.

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!

Hope you share the sample data, love you.

Excellent presentation sir. Was very helpful. Thank you

Your videos must be praised !! Awesome man, thx)

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?

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++💥

Thanks

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!

There is no synchronous scrolling option for Excel 2019 for Mac that I can see.

The BEST Excel instructor of all times

please just tell me what button to click in order to turn it off

I NEED HELP! PLZZ im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months. i'm trying to recreate an app that i was using but doesn't track enough details. in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all" and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow. i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be PLEASE TELL ME if you think that is at all possible on excel can i do this using form controls

Any idea how to change sparkline LINE COLOR dynamically based on a value? For example if a movement is up make the line GREEN and if movement is down make the line RED?

should have looked this up like 6 hours ago.... smfh so sad lol. thanks dude

@1:50 You show a layout of your content with star ratings. Do you have a video series on how you made that layout?