Пікірлер

• 
  @ruthmoinde364927 минут бұрын

  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.

• 
  @biggfoot5221 сағат бұрын

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

• 
  @soakinupthesun111Күн бұрын

  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!

• 
  @robertmuth97623 күн бұрын

  Great Video Thanks much

• 
  @betsinewbury46704 күн бұрын

  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!

• 
  @ajayrathod77774 күн бұрын

  Can we record excel power query measures with Vba?

• 
  @richardhay6454 күн бұрын

  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.

• 
  @richardhay6454 күн бұрын

  What is the name of his youtube channel.

• 
  @mrstardhi64204 күн бұрын

  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,

• 
  @ajayrathod77775 күн бұрын

  How can i automate dax measures in excel power query

• 
  @EricJemms6 күн бұрын

  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?

• 
  @yanchaoli68357 күн бұрын

  Perfect,thank you

• 
  @tonyjones55697 күн бұрын

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

• 
  @Character-j1r9 күн бұрын

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

• 
  @guizot20109 күн бұрын

  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.

• 
  @TonyJones-k5l9 күн бұрын

  Excellent video

• 
  @EmmerentiaFlemming9 күн бұрын

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

• 
  @kolyuminevski739 күн бұрын

  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 kzread.info/dash/bejne/nYVrpq2xY8jAgco.html

• 
  @lisalandes11 күн бұрын

  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!

• 
  @weirdonamedlee11 күн бұрын

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

• 
  @HamzaAhmed-yf1yk15 күн бұрын

  Thank You !

• 
  @learnspreadsheets11 күн бұрын

  Thanks for saying it!

• 
  @nitishkumarlala381915 күн бұрын

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

• 
  @learnspreadsheets11 күн бұрын

  I hope this could help with your frustration!

• 
  @nitishkumarlala381911 күн бұрын

  @@learnspreadsheets definitely

• 
  @mitooquerer16 күн бұрын

  Thanks! Just what I was looking for. 😊

• 
  @learnspreadsheets11 күн бұрын

  Thanks for saying that - very kind!

• 
  @IbrahimBashir16 күн бұрын

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

• 
  @learnspreadsheets11 күн бұрын

  Nice one!

• 
  @Tensquaremetreworkshop16 күн бұрын

  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.

• 
  @learnspreadsheets11 күн бұрын

  Sorry to hear, fortunately the classic Outlook is still going strong

• 
  @Tensquaremetreworkshop11 күн бұрын

  @@learnspreadsheets To which I have returned. Faster, cleaner, and works. Now all I have to deal with is the constant nagging to 'upgrade'...

• 
  @michaelperretta388917 күн бұрын

  how do you use date range for same event?

• 
  @learnspreadsheets11 күн бұрын

  You have two options: 1. Unless you repeat the same event in multiple rows in the event list or 2: With power Query, generate a list of dates in between start and end dates and load that first.

• 
  @nicolevanmeurs957719 күн бұрын

  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?

• 
  @learnspreadsheets11 күн бұрын

  Thanks for the feedback. There is a way to include a filter, but it would be hard to explain over the comments section and would be better with a video or via a forum where people can share files!

• 
  @dhananjayparihar428319 күн бұрын

  Just amazing 💥

• 
  @learnspreadsheets11 күн бұрын

  Cool trick eh?

• 
  @yberry10019 күн бұрын

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

• 
  @learnspreadsheets11 күн бұрын

  Sorry it's not satisfactory. Google Workspace might be something to consider if you want an alternative or Zoom Workspace.

• 
  @alemsisay587521 күн бұрын

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

• 
  @learnspreadsheets20 күн бұрын

  That’s lovely to read - thanks so much 😃

• 
  @alemsisay587520 күн бұрын

  @@learnspreadsheets Thank you 🙂

• 
  @johnathanmudrovcic640523 күн бұрын

  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?

• 
  @learnspreadsheets20 күн бұрын

  Hi that is absolutely possible but with another method, using the FILTER function or QUERY function. Check my videos on QUERY & dynamic arrays in Sheets for more info!

• 
  @user-ky8ko8hy7w24 күн бұрын

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

• 
  @learnspreadsheets20 күн бұрын

  Hi thanks for the feedback, sorry but I cannot cover everything there is in the app in a short video. Conversation view (if this is what you are referring to) is available on both versions & you can switch it on/off in outlook options

• 
  @SSCLWorkControlCenter24 күн бұрын

  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

• 
  @learnspreadsheets20 күн бұрын

  Hello I don’t understand your situation, for those kinds of issues best to post in one of the excel forums where you can upload files & screenshots so people can help better.

• 
  @debrapretorius456525 күн бұрын

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

• 
  @learnspreadsheets11 күн бұрын

  Thanks! Glad you find it helpful :) Microsoft have not put in a UI version yet sadly but it's coming soon. For your problem, I would make a table with two columns From and To, the load it into Power Query and use it as a Similarity Table which I showcase in the video. That should work! I'll pin this comment for others :)

• 
  @debrapretorius45657 күн бұрын

  @learnspreadsheets thank you kindly I will try that.

• 
  @taramwiza25 күн бұрын

  This is a great video. Thank you so much

• 
  @learnspreadsheets11 күн бұрын

  Thankssss! Glad it was hepful!

• 
  @ukam16126 күн бұрын

  Amazing! Thank you!

• 
  @learnspreadsheets11 күн бұрын

  Glad you liked it!

• 
  @williamarthur480129 күн бұрын

  That was great, I must get to grips with unpivoting / pivoting, I often end up creating multiple lists, and table to column / rows which then need zipping, all to avoid pivot .

• 
  @learnspreadsheets11 күн бұрын

  Absolutely! Unpivoting is one of my favourite things in Power Query

• 
  @rajeevgosavi4514Ай бұрын

  Very Confusing , Cant follow. Audio not very clear

• 
  @learnspreadsheets11 күн бұрын

  Sorry you feel that way, others seem to think it's OK. I am paying more attention to clear audio in my newer videos

• 
  @francoischarette2139Ай бұрын

  Hello. Thanks for the video. Now is there a way to retrieve the data using the table name with App Script?

• 
  @learnspreadsheets11 күн бұрын

  Hi thanks for the question. I believe so but have never tried myself sorry

• 
  @TigrenocchekАй бұрын

  Very usefull information, thank you for this video!

• 
  @learnspreadsheets11 күн бұрын

  Ya thanks!

• 
  @KelvinAdityoАй бұрын

  Hey, thank you much.

• 
  @learnspreadsheets11 күн бұрын

  No worries! Glad you liked it!

• 
  @JDen4Ай бұрын

  what about syncing a single cell sheet to another file?

• 
  @learnspreadsheets11 күн бұрын

  It would be the same method, even for just one cell

• 
  @NetMediaCCTVАй бұрын

  Structured tables are awesome, thanks for sharing!

• 
  @learnspreadsheets11 күн бұрын

  Yes! I'm so excited they're finally in Sheets

• 
  @JustOkkoАй бұрын

  Hi! Very good video! However, not exactly matching my need. I have 1000s of rows already matched on a customer number level. I now want a similarity score for address in system A vs. address in system B. Do you know if there are similar functions to do something like this? I could transform the rows to columns but that would try to match every single value to all, also to those not from the same customer.

• 
  @learnspreadsheets11 күн бұрын

  Hi this method will give a similarity score, but Im not sure if that is exactly what you need.

• 
  @SystemsDeptKIOCLАй бұрын

  Brilliant. I love this as this was the easiest way of using cell value as parameter

• 
  @learnspreadsheets11 күн бұрын

  Thanks! Glad you found it useful :)

• 
  @odallamicoАй бұрын

  Interesting options. Thank you for share

• 
  @learnspreadsheetsАй бұрын

  Glad you like it! Thanks 😃

• 
  @kebincuiАй бұрын

  Excellent explanation and solution that make the pivota error puzzle clear and easy to understand 👍👍

• 
  @learnspreadsheetsАй бұрын

  Yes you’re so right, it took me years where I didn’t understand why it broke my query all the time so as soon as I learned why I made this video 😃

• 
  @erinfield1943Ай бұрын

  0:24- using "Percent of Total", Power BI's UI way 1:05- Calculate the denominator first (the hard part) (measure). CALCULATE([Years on Throne]),ALL('English Monarchs')) 2:20- Numerator divided by Denominator. DIVIDE([Years on Throne],CALCULATE([Years on Throne]),ALL('English Monarchs')))*100 3:40- another way that will work with filters better. DIVIDE([Years on Throne],CALCULATE([Years on Throne],ALLSELECTED('English Monarchs'))

• 
  @learnspreadsheetsАй бұрын

  Thanks for the measures! Very helpful! Pinning your comment 😃

• 
  @mwsberdanАй бұрын

  Great video. Just enough demonstration to make your points without getting bogged down.

• 
  @learnspreadsheetsАй бұрын

  Thanks for the feedback, glad you appreciate my style!

• 
  @blaxmolassesАй бұрын

  hi! i couldn't see where you copied and pasted the unique values in the calendar. it's cut off

• 
  @learnspreadsheetsАй бұрын

  I’m sorry, where in the video is the issue? I can see if I can figure out.