Пікірлер

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

  VERY USEFUL

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

  Glad it was helpful!

• 
  @phaychit43374 күн бұрын

  "Alt + Enter" which is exactly what I was looking for decades. Thank you so much!!!

• 
  @Advanced_Excel4 күн бұрын

  You're very welcome!

• 
  @a.k.78985 күн бұрын

  THANKS. YOUR VIDEO IS MUCH MORE HELPFUL THAN THE SOLUTIONS OFFERED BY OTHER VIDEOS.

• 
  @patriciashell93036 күн бұрын

  there is no "series" in drop down

• 
  @Advanced_Excel5 күн бұрын

  What version of Excel are you using

• 
  @findingx1526 күн бұрын

  Can u help me how to do this in python using openpyxl

• 
  @Advanced_Excel6 күн бұрын

  Sorry don't do python

• 
  @psychette88466 күн бұрын

  Good video BUT you literally glanced over the biggest annoyance of hyperlinks 2:18 you click the hyperlink for income statement and Excel focuses on the first moment it can put the cell on the screen. When the vast majority of people click the Income Statement hyperlink they want it to focus to the top left of the screen not at the bottom or the far right of the screen. Is there a solcution to that issue?

• 
  @Advanced_Excel6 күн бұрын

  Agreed . I have previously made the hyperlink go 30 rows lower than the actual cell within the calculation but no real ideal solution.

• 
  @sarahnorlin38889 күн бұрын

  Thank you Thank you Thank you. I looked everywhere online and the answers were useless and referred to the wrong menus. This was so simple and now I can continue to get my work done! Again, thank you!

• 
  @Advanced_Excel9 күн бұрын

  You are welcome!

• 
  @priyagaikar66859 күн бұрын

  Helpful

• 
  @Advanced_Excel9 күн бұрын

  Glad to hear that

• 
  @gamerchick203610 күн бұрын

  Is there a way to do this that won't affect formulas?

• 
  @Advanced_Excel10 күн бұрын

  So you want the formulas to keep looking at the same row as before. With this video technique the formulas would follow the cells? Quick suggestion would be to copy paste the formula down again from the top but not sure if this helps in your scenario.

• 
  @AMANZ201010 күн бұрын

  Thanks ❗Nicely explained However I have another challenge Can you recommend settings for Pivot Table chart when using slicers🤔❓ For example: I have data (numbers for Jan ⬅➡ December) for years 2023 and 2024 On graph, data for 2023 is on primary axis and 2024 is on secondary axis I have changed the Series overlap and Gap width so that 2023 and 2024 data columns overlap When slicer is used to select off 2024 and then select back on, the secondary axis is disabled and both years default back to primary axis

• 
  @Advanced_Excel10 күн бұрын

  You may need to think about putting in a phantom series that always stays on the secondary axis. I think excel will then remember that 2024 belongs there. Difficult within a pivot table though

• 
  @nicomellett580310 күн бұрын

  Exactly what I was looking for, thanks boet

• 
  @booboomaniac11 күн бұрын

  Thank you!!!!

• 
  @RoboGymDesign14 күн бұрын

  Spot on. Thank you

• 
  @Advanced_Excel14 күн бұрын

  You are so welcome

• 
  @jesusdelarosa930815 күн бұрын

  Clear and to the point, exactly what I needed. Thank you!

• 
  @Advanced_Excel15 күн бұрын

  You're welcome!

• 
  @saveethamatthews610015 күн бұрын

  Thank you so much! You saved me a bunch of time!

• 
  @Advanced_Excel15 күн бұрын

  Glad I could help!

• 
  @vinatopia17 күн бұрын

  Noice! Thank you: No messing :)

• 
  @neelbis17 күн бұрын

  Thank you so much. I thought my 1 hour work has gone to complete waste. You're a life saver

• 
  @Advanced_Excel17 күн бұрын

  Glad I could help

• 
  @juliusm36717 күн бұрын

  dude, are you South African? haha definitely a SAn boytjie

• 
  @Advanced_Excel17 күн бұрын

  🇿🇦 ja ek is

• 
  @qamberaliharoon925919 күн бұрын

  Thanks!

• 
  @Advanced_Excel19 күн бұрын

  Thanks so much. Hope it saved you hours of time

• 
  @qamberaliharoon925918 күн бұрын

  @Advanced_Excel it most definitely did!

• 
  @escapevelocity616721 күн бұрын

  It's so dumb how excel can produce such complicated formulas even pulling numbers out of other programs but can't recognize a date if its format is ever so slightly different from what it's used to. Great video, thank you.

• 
  @franzo1357923 күн бұрын

  THANKS <3

• 
  @Advanced_Excel23 күн бұрын

  Pleasure

• 
  @blackscreenproject126 күн бұрын

  Thanks!

• 
  @Advanced_Excel26 күн бұрын

  No problem!

• 
  @Balasana123426 күн бұрын

  This has been tremendously helpful - thank you!

• 
  @Advanced_Excel26 күн бұрын

  Glad it was helpful!

• 
  @dUSSEm26 күн бұрын

  Does this also allow sorting?

• 
  @Advanced_Excel26 күн бұрын

  Yes it should but for some reason you need to unprotected the heading cell as well

• 
  @natgeo359529 күн бұрын

  Thank you mate

• 
  @Advanced_Excel29 күн бұрын

  You're welcome!

• 
  @selimkalifa6794Ай бұрын

  It took me hours to find out. Thanks mate!

• 
  @Advanced_ExcelАй бұрын

  Glad I could help!

• 
  @MorganHaroАй бұрын

  Thanks!

• 
  @Advanced_ExcelАй бұрын

  Thanks so much. Hope it saved you lots of time!

• 
  @AshishYadav-gz3jqАй бұрын

  Coolest.. Without wasting time.. Thanks

• 
  @Advanced_ExcelАй бұрын

  Welcome 😊

• 
  @AshishYadav-gz3jqАй бұрын

  Very nice...

• 
  @Advanced_ExcelАй бұрын

  Thank you! Cheers!

• 
  @richardlievesley8992Ай бұрын

  Short n sweet. Thank you!

• 
  @claude77573Ай бұрын

  Excellent. At 4:51, you mentioned you did not have the plus/minus symbol in your clipboard. If you turned clipboard history on, then you can store the plus minus symbol in your clipboard history and then retrieve it when you need it.

• 
  @Advanced_ExcelАй бұрын

  Nice and agreed.

• 
  @claude77573Ай бұрын

  Hum. This didn't work or me. When I type +, -, space, I get the error message "This is an incomplete formula".

• 
  @Advanced_ExcelАй бұрын

  Did you put it between quotes " in the custom format dialog box?

• 
  @Hus77777Ай бұрын

  Thanks man.. that issue was really annoying and you solution helped! ✌

• 
  @Advanced_ExcelАй бұрын

  No problem 👍

• 
  @leandrobronzatto8251Ай бұрын

  I've been looking for this solution for the last few hours. Thank you for sharing this!

• 
  @Advanced_ExcelАй бұрын

  You are welcome!

• 
  @sancasteabro4285Ай бұрын

  Excellent explanation

• 
  @Advanced_ExcelАй бұрын

  Glad it was helpful!

• 
  @Matt-tx5cbАй бұрын

  Thanks!

• 
  @simonmouton6487Ай бұрын

  Great Video, and its great to hear another South African accent.

• 
  @Advanced_ExcelАй бұрын

  🇿🇦

• 
  @simonmouton6487Ай бұрын

  @@Advanced_Excel Thanks for making this, its very helpful!

• 
  @varunr8322Ай бұрын

  Just getting straight into the point 👌

• 
  @im_rishhiiАй бұрын

  can copy paste data is detected

• 
  @rosinulanam4565Ай бұрын

  Thank you very much, your explanation is very helpful.

• 
  @Advanced_ExcelАй бұрын

  Glad it was helpful!

• 
  @umariobakerАй бұрын

  This is amazing. Thank you! I am glad there is something other than trying to figure out the numerical value of the date.

• 
  @Advanced_ExcelАй бұрын

  You're very welcome!

• 
  @mikepanteli882Ай бұрын

  Thanks for your advise, clear and concise :)

• 
  @marceloalvesdeoliveira2908Ай бұрын

  This helped me a lot, thanks!

• 
  @Advanced_ExcelАй бұрын

  Glad it helped!

• 
  @mathewjoseph9340Ай бұрын

  Sir ,your solution was awesome .... my job is done ... God B;ess

• 
  @ianrjm969Ай бұрын

  If I wanted to reference another sheet, but use an AND IF formula, there is an error message. Do you have any advice?

• 
  @Advanced_ExcelАй бұрын

  What version of Excel are you using.

• 
  @ianrjm969Ай бұрын

  @@Advanced_Excel latest

• 
  @davidkoenig8822Ай бұрын

  Great video. Thank you very much for the helpful explanation! Keep making great content.

• 
  @Advanced_ExcelАй бұрын

  Glad it was helpful!

• 
  @chinikarlughАй бұрын

  Thank you for sharing this. I'm using this function so that I can check if the answers I typed in a cell is correct or not, but I don't want to always know it, that's why having this function where I can turn the conditional formatting on and off whenever I want is really helpful in my studies. It speeds things up. Thanks again. I hope you're having a great day :)

• 
  @laiwk2Ай бұрын

  good one, straight forward! Thanks!

• 
  @Advanced_ExcelАй бұрын

  Pleasure

• 
  @omolemokodisang157Ай бұрын

  Thank you so much!!!

• 
  @Advanced_ExcelАй бұрын

  You're welcome!

• 
  @suleimankhan18732 ай бұрын

  This saved me hours of work. Thank you very much! 🙏

• 
  @Advanced_Excel2 ай бұрын

  Glad it helped!