Пікірлер

• 
  @JulieHerr-e3r12 күн бұрын

  So simple, glad I found your video!

• 
  @ApexTrainingLLC11 күн бұрын

  Hey Julie, thank you for the comment. Please like, share and subscribe.

• 
  @mohammadzaman738328 күн бұрын

  Cool

• 
  @ApexTrainingLLC26 күн бұрын

  Thanks! Please like, share and subscribe. Peace!

• 
  @Christina-fc7ulАй бұрын

  Could you please show us how to formulate a cell to show time - many times I have time data shown like 45678 - and it is so annoying to change from the top bar every time do you know how we can have a keyboard shortcut to fix it

• 
  @ApexTrainingLLCАй бұрын

  Hi Christina. Thank you for your inquiry. You can use the shortcut key combination of CTRL + SHIFT + 3 to apply date formatting in the format dd-mmm-yy. To apply a the short date format, you can right-click the menu choice for short date from the ribbon, then choose to add it to your quick access toolbar. Any icon on the quick access toolbar can be selected by pressing the Alt key, + the number that is the position of the icon on the toolbar. So if it is the 5th icon on your quick access toolbar, you would press Alt+5. I will make a video showing this process.

• 
  @amittaizeroАй бұрын

  Man you just saved me a lot of stress. I've signed up for a few mapping services the past few days to do just this -- this will make things much easier with a project I'm working on.

• 
  @ApexTrainingLLCАй бұрын

  Glad I could help! Please don't forget to share and subscribe. Peace!

• 
  @Safety100Ай бұрын

  Pls help me can you share me the steps with keys

• 
  @MrSardarshahАй бұрын

  Best video on multilevel grouping in excel

• 
  @ApexTrainingLLCАй бұрын

  Thanks for the feedback! Please subscribe!

• 
  @user-vs3eg9yn2qАй бұрын

  Doesn’t seem to work anymore. I get taken to “/homes. Not the address

• 
  @mpesmail1834Ай бұрын

  I tried, it prompts back 'VALUE' and not any number

• 
  @user-yj5qd3fs6eАй бұрын

  Bingo! Thank you!!

• 
  @ApexTrainingLLCАй бұрын

  You are so welcome @user-yj5qd3fs6e

• 
  @danielhudspeth56992 ай бұрын

  incredible. Thank you.

• 
  @ApexTrainingLLC2 ай бұрын

  Thank you too! @danielhudspeth5699

• 
  @lillianpalmer25562 ай бұрын

  Thank you so much, this video was so useful, keep up the good work and I have subscribed of course

• 
  @ApexTrainingLLC2 ай бұрын

  Awesome, thank you so much!

• 
  @BrockJamesStory2 ай бұрын

  Wow this is cool!!! I just took time out of my day to follow this. Now me and my coworker can play some Yahtzee 😂

• 
  @ApexTrainingLLC2 ай бұрын

  Excellent!

• 
  @BrockJamesStory2 ай бұрын

  Keep in up Rich!

• 
  @ApexTrainingLLC2 ай бұрын

  Thank you sir!!!!

• 
  @dnmurphy482 ай бұрын

  very helpful

• 
  @ApexTrainingLLC2 ай бұрын

  Thank you @dnmurphy48. Please do subscribe

• 
  @kevinsantos5852 ай бұрын

  Obrigado

• 
  @ApexTrainingLLC2 ай бұрын

  de nada. obrigado por visitar o canal. por favor inscreva-se!

• 
  @prajwalshetty20472 ай бұрын

  ❤👍🇮🇳

• 
  @ApexTrainingLLC2 ай бұрын

  Thank you @prajwalshetty2047!

• 
  @adeelzafar56742 ай бұрын

  Thank you SIR!

• 
  @ApexTrainingLLC2 ай бұрын

  You are welcome! Thanks for checking out the channel. Please subscribe and share with your friends & colleagues.

• 
  @BrockJamesStory3 ай бұрын

  That’s pretty cool!

• 
  @ApexTrainingLLC3 ай бұрын

  Thanks @BrockJamesStory

• 
  @judah5303 ай бұрын

  😡 Promo_SM

• 
  @winnerimonitie69173 ай бұрын

  I am not seeing ifs in my excel 2016

• 
  @ApexTrainingLLC3 ай бұрын

  Unfortunately, IFS (+MAXIFS, MINIFS, and more) only comes with an Office365 subscription. If you, or your company, have purchased Excel 2016 (or older) as a non-subscription product, you won't have access to these newer functions.

• 
  @winnerimonitie69173 ай бұрын

  What about in excel 2019 sir

• 
  @ApexTrainingLLC3 ай бұрын

  It should be in 2019. answers.microsoft.com/en-us/msoffice/forum/all/my-excel-2016-missing-the-ifs-function/535af21d-456e-4305-a72b-7986211aeab1

• 
  @ApexTrainingLLC3 ай бұрын

  Do you have 2019?

• 
  @MariaCarolinaCruz-dr6ks3 ай бұрын

  thanks a lot :)

• 
  @ApexTrainingLLC3 ай бұрын

  Thanks for checking in Maria! I'm glad you enjoyed the video!

• 
  @BrockJamesStory3 ай бұрын

  Wwwhhhat I did not think it would be that easy. Always something new to learn!

• 
  @ApexTrainingLLC3 ай бұрын

  Thanks Brock!

• 
  @Vincent4253 ай бұрын

  Many thanks!!

• 
  @ApexTrainingLLC3 ай бұрын

  You're welcome! I'm glad it was useful! Please subscribe!

• 
  @bman342a3 ай бұрын

  I've got Office 365, which has the home/student version of Excel (2016) and doesn't have the map feature (amongst other features). is there an add-in I can purchase that will add these map features?

• 
  @ApexTrainingLLC3 ай бұрын

  I don't think Microsoft sells this specific feature as a separate add-in. They are lots of enterprise grade tools like Power Bai & Tableau which offer mapping. I would probably just upgrade to a standard version of Office 365.

• 
  @souvikghosh50873 ай бұрын

  Nice.I found it useful.I am subscribing it.

• 
  @ApexTrainingLLC3 ай бұрын

  Thank you very much. I'm glad it was useful!

• 
  @souvikghosh50873 ай бұрын

  how to get time difference in xl from today () and any other time in any other cell ? The time must be in year format.

• 
  @ApexTrainingLLC3 ай бұрын

  Do you mean you want to know how many years between today() and another date? You might find this video useful... kzread.info/dash/bejne/fWaEx62TdKrUlso.htmlsi=v6eOSE8K8zu4Ssvn

• 
  @cadeepakgoyal75004 ай бұрын

  I can't tell you in words, how much you helped me. Thanks you very much for this video. I really pray God to bless you

• 
  @ApexTrainingLLC4 ай бұрын

  Thank you for your kind words my friend. I’m glad you found the video helpful. Please subscribe to the channel! You might like this as well Microsoft Excel Stocks Data Type kzread.info/dash/bejne/gYyjuKajm7TIeag.html

• 
  @pepega_dawg_42074 ай бұрын

  VERY HELPFUL THANK YOU!

• 
  @ApexTrainingLLC4 ай бұрын

  Thanks for the feedback. I’m glad it was useful! Please subscribe!

• 
  @user-hm1ch7mu2w4 ай бұрын

  How do I create different tasks (lets say in a drop down) but some have 14 day target date and some have 21? ie, if its a postal complaint i have 21 days to respond, if its email I have 14

• 
  @ApexTrainingLLC4 ай бұрын

  Hello... I have a created a video for you.... kzread.info/dash/bejne/ZaeHmrane5WzqZs.html thanks for watching the channel, please subscribe and share!

• 
  @ibrahimal-saif93224 ай бұрын

  THANK YOU!!

• 
  @ApexTrainingLLC4 ай бұрын

  You're welcome!

• 
  @Franseven4 ай бұрын

  THANK YOU

• 
  @ApexTrainingLLC4 ай бұрын

  Thanks for checking in! I’m glad you enjoyed the video. Please subscribe and click the notification bell! 😃

• 
  @BrockJamesStory4 ай бұрын

  I’m first one to like! Everyone let’s give this man some subs! Great tips on here!

• 
  @ApexTrainingLLC4 ай бұрын

  Thank you Brock!!

• 
  @BrockJamesStory4 ай бұрын

  @@ApexTrainingLLC You know it!

• 
  @hunter3714 ай бұрын

  That's a nasty cough man! Hope you didn't have Covid. Next time mute that out or record without the nasty coughing throughout. Makes for a much more professional presentation

• 
  @ApexTrainingLLC4 ай бұрын

  Thanks Hunter. No Covid, just a cold. I think I will re-do this one after taking a Halls. :-)

• 
  @leopoldovazquez32554 ай бұрын

  Hi Rich, thanks for the explanation. I have a question. How can we add the S&P500 and the Dow Jones indexes?. Thanks

• 
  @ApexTrainingLLC4 ай бұрын

  Hey, I just did this video for you! kzread.info/dash/bejne/i2t8r7GGlpeXYrA.html

• 
  @leopoldovazquez32554 ай бұрын

  @@ApexTrainingLLC thanks a lot!!!

• 
  @JombaTUncleT27 күн бұрын

  ​@@ApexTrainingLLC🎉

• 
  @JombaTUncleT27 күн бұрын

  ​@@ApexTrainingLLC🎉

• 
  @bman342a4 ай бұрын

  What version of excel? Not seeing map to insert. Is this an add-in?

• 
  @ApexTrainingLLC4 ай бұрын

  HI it is built in as of Excel 2013

• 
  @wats244 ай бұрын

  thank 😊😊

• 
  @ApexTrainingLLC4 ай бұрын

  You are welcome!

• 
  @jesschodor89495 ай бұрын

  This worked in one workbook I was working in, but now in my new workbook it is copying the formula into every row instead of keeping a blank cell in every other row. Any ideas??

• 
  @ApexTrainingLLC5 ай бұрын

  Hi! Will check on this for you

• 
  @jesschodor89495 ай бұрын

  Thank you, Rich! Very time consuming task & room for error when this doesn't work, blah! @ApexExcelTraining

• 
  @jesschodor89494 ай бұрын

  Oy... I had some rows hidden. That was the issue. Resolved.

• 
  @ApexTrainingLLC4 ай бұрын

  I’m glad you got it worked out!

• 
  @AngelRivera-sg5ue5 ай бұрын

  please how can i use this with waze maps??

• 
  @ApexTrainingLLC5 ай бұрын

  Hi! Will check on this for you

• 
  @AngelRivera-sg5ue5 ай бұрын

  hi, great video just how would i make it work with waze live maps can you please let me know

• 
  @ApexTrainingLLC5 ай бұрын

  Hi! Will check on this for you

• 
  @user-nu5kp9zp4v5 ай бұрын

  THANK YOU

• 
  @ApexTrainingLLC5 ай бұрын

  You’re welcome!!!

• 
  @usmaniqbal18365 ай бұрын

  Please share data file for practice

• 
  @ARCHTECHEARNTV5 ай бұрын

  Thanks a lot 😊

• 
  @ApexTrainingLLC5 ай бұрын

  You’re welcome! Thanks for visiting the channel!

• 
  @eruditeinvestor46086 ай бұрын

  Thanks so much

• 
  @ApexTrainingLLC4 ай бұрын

  You're welcome!

• 
  @sukhjitkaur19786 ай бұрын

  I used the same formula but if the value in first column is blank for next months, it picks random number of days because of formula

• 
  @ApexTrainingLLC4 ай бұрын

  check out this updated version... kzread.info/dash/bejne/d3uZk8-il9iuqrw.htmlsi=d1kInDOPre0rJaLQ

• 
  @SoshiKyo6 ай бұрын

  Hi Sir, thank you for sharing this! also, I would like to know if there is any simple way like this to calculate remaining days, from today to specific date. kinda like the count down, it's for something like remaining days for subscription or promo. thank you ^_^

• 
  @ApexTrainingLLC6 ай бұрын

  I'm glad it was useful for you. Yes! To calculate the remaining days, you simply subtract today's date from the future date. Suppose you have a promo that ends on March 31st. You could write ="3/31/2024" - TODAY() Or if the promo expiration date was in a cell, for example, B5. You would write: =B5 - TODAy() as your formula.

• 
  @SoshiKyo6 ай бұрын

  @@ApexTrainingLLCah why didn't I think about it before, actually it might be similar to what I used to do, I put the 2 dates (exp and today) in the cell and substract them. But I have no idea that I can also use =TODAY instead of typing the date manually. On the second thought, it's not always the 'today' date that I want to calculate, sometimes it's different date, so I can't always use =TODAY formula. Anyway thank you for the explanation and for replying my comment Sir, I really appreciate it 😊

• 
  @MotusfitnessColorado6 ай бұрын

  Super helpful, thanks!

• 
  @ApexTrainingLLC6 ай бұрын

  I'm glad it was helpful! Thanks for the feedback.

• 
  @sarathkumar54057 ай бұрын

  Thank you very much🙏🙏

• 
  @ApexTrainingLLC4 ай бұрын

  Welcome!

• 
  @michelepowell87697 ай бұрын

  Exactly what I needed and super easy thank you!

• 
  @ApexTrainingLLC7 ай бұрын

  I’m glad it helped!!

• 
  @stanTrX7 ай бұрын

  Nice , thanks. Can you do that also for tables dynamically?

• 
  @ApexTrainingLLC7 ай бұрын

  Tables are trickier, because with a table, the headers and the data are separate objects. I'll see what I can come up with.

• 
  @stanTrX7 ай бұрын

  thanks@@ApexTrainingLLC

• 
  @mindeajeff7 ай бұрын

  Very useful . . . especially because I am also looking to make a Cook County zip code Heat map!