Пікірлер

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

  Excellent

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

  Glad it was helpful 😊

• 
  @Diggaz-Chutiya004Күн бұрын

  high income scam jobs.

• 
  @JJ_TheGreatКүн бұрын

  That is so cool! Thank you!

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

  Glad you like it!

• 
  @gurvindersingharora5301Күн бұрын

  Hello Mam, When to combine ALL function with Calculate + Filter function in DAX in detail ? Please make a video of it 🙏 ❤

• 
  @tun-tunninc.6492Күн бұрын

  Sum of variance? Is that a field created in the original data?

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

  No, it's a calculated field. Steps are in this video: kzread.info/dash/bejne/Z5-Js7WxcrnSips.html

• 
  @matlabkuchbhi3060Күн бұрын

  How did you get source data in correct layout...

• 
  @MyOnlineTrainingHubКүн бұрын

  I use Power Query: kzread.info/dash/bejne/X32B082gY5jHlKQ.html

• 
  @KKB-tt4ljКүн бұрын

  Always use Tables! Nice video as usual!

• 
  @MyOnlineTrainingHubКүн бұрын

  Thank you!

• 
  @kimthanh4017Күн бұрын

  Do you have the file of this database that I can watch the video and practice at the same time?

• 
  @MyOnlineTrainingHubКүн бұрын

  You can download the example file with further practice questions from the link in the video description: bit.ly/analytics24file

• 
  @kimthanh4017Күн бұрын

  @@MyOnlineTrainingHub thank you so much

• 
  @hawksiteКүн бұрын

  "Make you the go to expert in your office" I found that today, if you give a person a fish, you feed them for a day. Teach a person to fish, and they will come back over and over expecting you to teach them again..... 😃

• 
  @MyOnlineTrainingHubКүн бұрын

  And that's when you politely refer them to one of my courses 😁www.myonlinetraininghub.com/courses

• 
  @luismagana3815Күн бұрын

  Thanks Excelente Video!!

• 
  @MyOnlineTrainingHubКүн бұрын

  Glad it was helpful!

• 
  @ignatiusmba-bo5rq2 күн бұрын

  Thank you so much for this video. Its Slow, steady and with a soothing way of talking that makes it easy to listen.

• 
  @MyOnlineTrainingHubКүн бұрын

  That's wonderful to hear. Thank you so much! 😊

• 
  @JohnnyJankovich12 күн бұрын

  What a wonderful trainer - well done!

• 
  @MyOnlineTrainingHubКүн бұрын

  Thank you, you're very kind 😊

• 
  @power-reconcile2 күн бұрын

  Very helpful, thanks for sharing!

• 
  @MyOnlineTrainingHubКүн бұрын

  Glad it was helpful!

• 
  @JohnnyJankovich12 күн бұрын

  Great vid - appreciate it!

• 
  @MyOnlineTrainingHubКүн бұрын

  Glad it was helpful!

• 
  @KKB-tt4lj2 күн бұрын

  When I select "Order Date" I cannot ungroup the years... any suggestions? Thanks!

• 
  @MyOnlineTrainingHubКүн бұрын

  It's possible they're not proper dates, i.e. they're text. Not sure what data you're using. You're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

• 
  @KKB-tt4ljКүн бұрын

  @@MyOnlineTrainingHub I downloaded the file from the link in your video...

• 
  @michaelarnold76982 күн бұрын

  Do you have a list of your courses that one should take in order in these 4 weeks ?

• 
  @MyOnlineTrainingHubКүн бұрын

  Hi Michael, thanks for your interest in my courses. I recommend the following (skip what you already know): - Advanced Excel Formulas: www.myonlinetraininghub.com/advanced-excel-formulas-course - PivotTables: www.myonlinetraininghub.com/excel-pivottable-course-quick-start - Power Query + Power Pivot + Excel Dashboards bundle: www.myonlinetraininghub.com/excel-dashboard-course If you have any questions, please reach out via email: website @ MyOnlineTrainingHub.com

• 
  @issamsultanoglu73382 күн бұрын

  Hi i like your method of explaining excel thank you very much for this valuable course

• 
  @MyOnlineTrainingHubКүн бұрын

  So nice of you 🙏😊

• 
  @LordBransty2 күн бұрын

  Great video Mynda. Learned a lot in a short space of time. That's what great training is supposed to do. Thank you!

• 
  @MyOnlineTrainingHub2 күн бұрын

  Awesome to hear 🙏

• 
  @goodone050042 күн бұрын

  OneDrive no longer gives the option of JavaScript :( Could you please do an updated video on this? Would love to know any other way we could embed securely on a website. Thanks again, love your work.

• 
  @MyOnlineTrainingHub2 күн бұрын

  It does still give the JavaScript option, but this is only available with OneDrive Personal accounts. If you don't see it, then I suspect you have OneDrive for Business.

• 
  @trulskjsnes26862 күн бұрын

  Why might Olap tools be greyed out?

• 
  @MyOnlineTrainingHub2 күн бұрын

  If you haven't added the data to the data model when creating the PivotTable.

• 
  @tun-tunninc.64922 күн бұрын

  I'm a supply chain data analyst. Are there any nifty tricks u know that may benefit a novice such as myself?

• 
  @MyOnlineTrainingHub2 күн бұрын

  The nifty tricks in Excel are endless. It really depends on your current skill level, as to what will be the next worthwhile Excel skill to learn. You're welcome to reach out via email and I can help point you in the right direction: website @ MyOnlineTrainingHub.com

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

  “The Mistake Almost EVERY Excel User Makes”… using excel

• 
  @rebesteves2 күн бұрын

  My data is huge. (1) I can't filter to remove the header from each sheet. It says, "Limit of 1000 values reached". how to by pass this? Except un-filtering the header, what are other options? (2) some of headers not come in as it it, for example, a header, "MainAccount", it shows error and says, can't convert to number. if I change it to text, still not work.

• 
  @MyOnlineTrainingHub2 күн бұрын

  Hard to say without seeing your problem. Please post your question and sample Excel file/screenshots on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

• 
  @belovedsoniathewriter2 күн бұрын

  #4 is my favorite function. Thank you for sharing this video, Mynda!

• 
  @MyOnlineTrainingHub2 күн бұрын

  Great to hear 🙏

• 
  @zak12online2 күн бұрын

  Thanks

• 
  @MyOnlineTrainingHub2 күн бұрын

  Pleasure 😊

• 
  @orlandob6623 күн бұрын

  this was nuts

• 
  @MyOnlineTrainingHub2 күн бұрын

  Hope you enjoyed it 😁

• 
  @jareksvoboda12573 күн бұрын

  Wonderful as always :-) I am in Power Pivot level with one project, however it is good every day to be challenged with skills for Cleaning Data. And thanks for your help on your Forum

• 
  @MyOnlineTrainingHub2 күн бұрын

  Great to hear 😊

• 
  @KittKatPawz3 күн бұрын

  This helps tremendously. Been working in excel for over 20 years and it’s hard sometimes to keep up with upgrades and new features. Thank you!🙏🏽 😊

• 
  @MyOnlineTrainingHub2 күн бұрын

  You're very welcome!

• 
  @brkc31533 күн бұрын

  what if seeing “ “ symbols with numbers when load the dada. How to get ride of them?

• 
  @MyOnlineTrainingHub2 күн бұрын

  Do a 'Replace' in Power Query that replaces " with nothing.

• 
  @SalvatoreTirabassi-113 күн бұрын

  I have a question. What happens when you have a row of promoted date headers that need to be changed from text? Right now, I just convert them in excel to become the right data type so that I can use Index/Match/Match to make a report. Wondering how that one row gets converted into the right date format so I can avoid the extra step in Excel.

• 
  @MyOnlineTrainingHub2 күн бұрын

  Ideally, you should never use dates as headers. Sounds like your data needs unpivoting into a tabular layout: kzread.info/dash/bejne/X32B082gY5jHlKQ.html

• 
  @enriquefernandezaraujo39433 күн бұрын

  Thank You for the video, it is clear and straight to the point.

• 
  @MyOnlineTrainingHub2 күн бұрын

  Great to hear 🙏

• 
  @darrylmunday64753 күн бұрын

  I have a list of employees and each has individual rates standard overtime rates which the timecards. Tell the rate to use looking for a simply way to return the rates. Any examples to look at please.

• 
  @MyOnlineTrainingHub2 күн бұрын

  Lookups sound like the way to go. If you're stuck, you're welcome to post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum

• 
  @joyezedo45033 күн бұрын

  i love you, thank u💛

• 
  @MyOnlineTrainingHub2 күн бұрын

  You're welcome 😊