This is fantastic. So simple. So creative. I think layers could help with that bar-timer idea. You could have multiple bar timers side by side but they would have to be masked by an object or be set to disappear after going behind the previous timer.

Love this!! Thanks from South Africa!!

way too much infor at the start , so I turned it off

Hello David....I would appreciate a copy of your sheet that would allow me to calculate average historical exchange rates for various quarters and currency pairs, as well as the quarter-end date rate.

The transpose feature in Excel is so relieving the see!

Is there a way to do this but with 2 filtered value instead of 1 ? Like I want to filter to get X and Y instead of just X ?

Thanks a lot

Yes we didn’t catch anything This video is not how to do This video is look how fast i am

Great video i want to replace #div,#na ,#value etc errors will null after populating in this list

Thank you

I am trying to come up with a formula in google sheets to do something specific. Would you be interested in helping me? Basically I created a drag racing bracket. 2 competitors are set up in 2 columns where the stats of the race are displayed. (Reaction Time, Holeshot, Speed, ET) Currently the Winner is indicated by the last rows in each column and the conditional formatting I have set-up turns the cell green if the cell has a lower ET number than the other competitor's column. I want to have the formula see which column is the winner and then take 1 cell of that column (the persons name) and populate another cell on the bracket (to show the winner advanced). I can show you specifically how I have it now if you are interested...thanks for your time...

Kindly Explain if we have to use bridge table? How should we decide which columns(Data) should we make dimension? Like in our case we decided that we should make dimensions like ( date,fruits,country) Thanks

Thank you! It helped a lot!!

I have been searching for how to enter a file location into a cell in google sheets and every video and blog post has absolutely nothing to do with my request. Is it always this difficult to get answers out of google? It use to be so great and now it is a POS!!!! Your video was a the top of my last search results. I like how quickly you get to the point but unfortunately it is the wrong point.

Just what I’m looking for! Is it possible to get a link?

Greetings David, I found this presentation to be exceptionally clear, specific, and easy to follow. It provided insights that I had not been able to capture, connect, or understand from various other sources. Thank you for this presentation, I was able to comprehend and apply the information directly to my project assignment. Thank you very much.

I've come to the conclusion, content is not as important as perception. Work it may, shine it must!

I'm having difficulty using text join to merge multiple events on the same date. I've replaced my formula of =XLOOKUP(O$15&" "&TEXT($M16,"DD MMM YY"),$K$16:$K$250,$J$16:$J$250,"") (which was working perfectly) to =TEXTJOIN("; ",TRUE, IF(N$15&" "&TEXT($M16,"DD MMM YY")=$K$16:$K$250,$J$16:$J$250,"")) and my entire calendar goes blank. Any ideas on how to troubleshoot? I'm using Google Sheets if that matters. Thanks!

Great Video Thanks much

I'm a bit late to finding your video, but I think it has given me the information I need to fix the headers I have been fighting with for over a week. Thanks much!

Can we record excel power query measures with Vba?

Hard to believe excel users don't use Tables. I think the main issue is that the robust version of Tables did not until Excel 2007 (minimal version in Excel 2003). So Tables are treated as an afterthought. Tables should be taught fro day one.

What is the name of his youtube channel.

do u know why it a like still loading to have access, after pressing allow access, but i feel like they are not accessible, it stay 'adding permission' loading,

How can i automate dax measures in excel power query

I share visualizations with customers, but I don't want them to be able to see the semantic model when they choose to export to excel. I'd like them to be able to export to excel only the data present in the visualization. Is this possible?

Perfect,thank you

Hi I dont see the link for the sheet please advise.

Can you create one with Gemini ..with help me create a table

These are not "hacks." These are just regular, normal, ordinary functions of Microsoft Word. You are not "hacking" a program when you click on one of the menu items in the ribbon above that's just sitting there asking you to use it when needed.

Excellent video

please send the code to me. Much appreciated. Learning for work and struggling with dates.

very interesting and useful overview. It seems though that tables were available in Sheets at least 2 years ago. but now they are significantly improved kzfaq.info/get/bejne/obdnd66pmMu-gZs.html

Thanks for the video! Question, are you have any issues with the signature functionality in the new Outlook? I work for a large org and employees need to be able to copy and paste our branded sig into their Outlook settings. The format isn't holding, and the logo isn't showing up. Copy and paste worked fine in the old version. Any easy workarounds? Thanks for your input!

Thank you much! I’m making a spreadsheet for a book club and this is exactly what I needed ^-^

Thank You !

Thanks a lot brother i stucked here since morning.🥰🥰🥰

Thanks! Just what I was looking for. 😊

Great video! I have definitely found most of the charts I wanted to use all in one video. Thanks for this.

Full of bugs! Keeps launching extra copies, mail you have read (gmail) goes back to unread, deleted mail returns, Sent items are later found in the drafts folder... And you get ads.

how do you use date range for same event?

Great video, thank you! I had a doubt that maybe you could solve, I want to not only filter by date, but by type of event. For example, only see “improv” events (based on your video example). How could I do that?

Just amazing 💥

I so much dislike Microsoft's products. Paying money for all the frustrating glitches is a total mess. Does anyone know another company that offers Office Suites besides Microsoft? I think it's time to show our dissatisfaction. A "nightmare is putting it very mildly, Salman..

Great, thanks for sharing! Came here from one of your other videos, and glad I've watched it.

Great content! What about separate filtered views? Example: Original source Table on Sheet 1. Sheet 2 requires a synced filtered view, and when this filtered view on sheet 2 is edited, it updates the data in the original table on sheet 1 (and visa versa). Is this possible and if not, do you know if it’s coming?

this does not explain how to collapse emails (not expanded) in new outlook

Hello sir how are you I need your help if the workbook link is breakall how to create link. What is the process kindly make a video

You explain everything brilliantly, may I ask 1 stupid question? I have my column of names that everybody typed in the wrong names so I have 3 versions of a name , lets say Prima Meat Group (PTY) Ltd is the correct one, then it has been typed in , Prima meat group, Prime meat . I have a long list of these, next to your original list you have a column on the side that has a description of the the true , false, CorrEct. How must I get it there without it taking up an entire day. I my list there is at least 1 of every name that is correct. How do I go about to find it? Oh and PS. I follow your tutorial with absolute ease. I appreciate that this came along my path.🥳

This is a great video. Thank you so much