HowtoExcel.net
HowtoExcel.net
  • 506
  • 2 166 238

Video

Track Berkshire Hathaway's Stock Changes with Pivot Tables in Excel
zhlédnutí 47Před 7 hodinami
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #berkshirehathaway #berkshirehathway #buffett #warrenbuffet #warrenbuffett #pivottable #pivottables
Add Cool Effects and Images to Your China Travel Videos With Filmora 13
zhlédnutí 16Před 12 hodinami
Learn more in the Creator Hub: bit.ly/3ssiU9V Download and try Filmora 13: bit.ly/3TVMuOZ #filmora13 #WondershareFilmora #FilmoraCreatorHub
Enhance Your China Travel Videos In Filmora 13 With Relevant Effects and Stickers
zhlédnutí 17Před 12 hodinami
Learn more in the Creator Hub: bit.ly/3ssiU9V Download and try Filmora 13: bit.ly/3TVMuOZ #filmora13 #WondershareFilmora #FilmoraCreatorHub
Excel Copilot: How to Create Charts With Ease
zhlédnutí 52Před 19 hodinami
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips
Visualize Sales Growth Components With Stacked Charts in Excel
zhlédnutí 66Před dnem
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #chart #charts
Easily Enhance Your Videos in Filmora Mobile
zhlédnutí 14Před dnem
Learn more in the Creator Hub: bit.ly/3ssiU9V Download and try Filmora 13: bit.ly/3TVMuOZ #filmora13 #WondershareFilmora #FilmoraCreatorHub
How to Apply Multiple Effects to Your Videos in Filmora Mobile
zhlédnutí 23Před dnem
Learn more in the Creator Hub: bit.ly/3ssiU9V Download and try Filmora 13: bit.ly/3TVMuOZ #filmora13 #WondershareFilmora #FilmoraCreatorHub
Analyzing Earnings Reports: Copilot vs ChatGPT and Other AIs
zhlédnutí 49Před 14 dny
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #copilot #gemini #claude #ai #chatgpt #chatgpt4
How to Sum and Group Fields in Power Query
zhlédnutí 41Před 14 dny
#excel #powerquery #exceltips #exceltutorial #exceltricks #powerquerytutorial #office365 #microsoft365
Excel Copilot: Quickly Do Data Analysis in Seconds
zhlédnutí 133Před 21 dnem
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #copilot #dataanalysis
How to Fix #SPILL Errors in Excel
zhlédnutí 1,6KPřed 21 dnem
How to Fix #SPILL Errors in Excel
Excel Copilot: Easily Code VBA Macros Even if You're a Beginner
zhlédnutí 575Před 28 dny
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #copilot #vba #macros
XLOOKUP vs VLOOKUP vs INDEX & MATCH
zhlédnutí 75Před měsícem
XLOOKUP vs VLOOKUP vs INDEX & MATCH
Enhance Charts in Excel with Gradients
zhlédnutí 57Před měsícem
Enhance Charts in Excel with Gradients
Power Query Beginner's Guide for Excel Users
zhlédnutí 156Před měsícem
Power Query Beginner's Guide for Excel Users
Automatically Update Drop-Down Lists in Excel
zhlédnutí 356Před měsícem
Automatically Update Drop-Down Lists in Excel
Enhance Your Travel Vlogs in Filmora With Cinematic Titles and Assets
zhlédnutí 26Před měsícem
Enhance Your Travel Vlogs in Filmora With Cinematic Titles and Assets
Easily Add Intense Cinematic Intros in Filmora 13.6
zhlédnutí 26Před měsícem
Easily Add Intense Cinematic Intros in Filmora 13.6
Calculate Date Differences in Excel Easily With the DateDif Function
zhlédnutí 89Před měsícem
Calculate Date Differences in Excel Easily With the DateDif Function
Easily Get Trending Stocks From WallStreetBets Subreddit into Excel with Power Query
zhlédnutí 149Před měsícem
Easily Get Trending Stocks From WallStreetBets Subreddit into Excel with Power Query
How to Quickly Remove Objects From Videos With Filmora 13
zhlédnutí 214Před měsícem
How to Quickly Remove Objects From Videos With Filmora 13
How to Import Data Into PowerBI
zhlédnutí 58Před měsícem
How to Import Data Into PowerBI
Easily Add Music to Your Videos With Filmora's AI-Generated Audio
zhlédnutí 25Před měsícem
Easily Add Music to Your Videos With Filmora's AI-Generated Audio
Get Random Cat Photos Into Excel Every Day!
zhlédnutí 48Před měsícem
Get Random Cat Photos Into Excel Every Day!
Highlight Averages on an Excel Chart in a Different Color
zhlédnutí 28Před měsícem
Highlight Averages on an Excel Chart in a Different Color
How to Find and Fix Circular References in Excel
zhlédnutí 91Před měsícem
How to Find and Fix Circular References in Excel
Create Date and Time Stamps in Excel With Checkboxes
zhlédnutí 562Před měsícem
Create Date and Time Stamps in Excel With Checkboxes
Easily Create Geo Map Charts in Excel and Google Sheets
zhlédnutí 138Před měsícem
Easily Create Geo Map Charts in Excel and Google Sheets
Create Progress Charts in Microsoft Excel
zhlédnutí 123Před 2 měsíci
Create Progress Charts in Microsoft Excel

Komentáře

  • @mystictouch9
    @mystictouch9 Před dnem

    Does voice cloning cost extra money ? I have filmora 12... perpetual plan... It said I can can upgrade... but i only will upgrade if i can use my voice for text to speech because im tired of paying money to eleven labs or any company for text to speech

  • @manuelmarqueze4931
    @manuelmarqueze4931 Před 2 dny

    Thanks for the video. I have a question, can I change the color and description of the button?

  • @mayowamayor2009
    @mayowamayor2009 Před 3 dny

    Beautiful presentation. Really enjoyed it. Is there a way we can get the excel data for practice purposes

  • @AMARDIPNIMBALKAR
    @AMARDIPNIMBALKAR Před 3 dny

    very nicely explain the concept.thank you

  • @armandaneshvar6606
    @armandaneshvar6606 Před 4 dny

    This actually is very helpful! Thx a lot

  • @Vocal_Vibes_byaniket
    @Vocal_Vibes_byaniket Před 11 dny

    Saviour ! Thank You !

  • @yogihex
    @yogihex Před 13 dny

    Phenomenal video! This explanation is better than Seeking Alpha's

  • @alexrosen8762
    @alexrosen8762 Před 13 dny

    This tutorial was very useful! Thanks 🙏

  • @AdoniasRumoAoTopo
    @AdoniasRumoAoTopo Před 14 dny

    Great job

  • @michaelsherron7815
    @michaelsherron7815 Před 14 dny

    I conducted a podcast interview last month and i forgot to turn on the mics, but the volume on my iphone recorded the session, but the volume is very low. I activated speedh-to- text and at the "transcription" phase, it hasn't budged past 99%. Does that mean it can't pick up the words because the volume is too low or something else. Thanks.

    • @h2e
      @h2e Před 13 dny

      I've come across that where it gets stuck and that's with the volume being perfectly fine. You may just want to try it again.

  • @mohnasser8229
    @mohnasser8229 Před 16 dny

    Thank you

  • @JulieMackenzie88
    @JulieMackenzie88 Před 20 dny

    Really helpfull without going into too much detail, thanks !

  • @Gaussen
    @Gaussen Před 23 dny

    what is tickercount?

    • @h2e
      @h2e Před 13 dny

      This is a named range I used to reference the number of tickers.

  • @joeldadi5033
    @joeldadi5033 Před 23 dny

    Thank You Sir

  • @NaguiSalsa
    @NaguiSalsa Před 23 dny

    Thank you so much! This solved my problem with my worksheet! But this is interesting. Because when you are creating formula by clicking cells, it automatically add the sheet name. Why does it add the sheet name if the cell is referencing the cell in the same worksheet? (FYI: I also reference data from another worksheet in the same formula)

  • @usmaniqbal1836
    @usmaniqbal1836 Před 26 dny

    Perfect! Please share data file for practice

  • @spiritualrainfrances
    @spiritualrainfrances Před 26 dny

    Excellent tutorial, thanks so much. Very helpful!

  • @PlayerHeader
    @PlayerHeader Před 27 dny

    thank you so much!!!

  • @rickb5271
    @rickb5271 Před 29 dny

    Your "Average Gain" and "Average Loss" take care of 0 values when in opposite Gain/Loss, are you sure it's the way? Example for "Average Loss" it would be (4.01+3.42+1.92+1.16+0.74)/5 = 2.25. Not 0.80 ?

  • @feline-fox
    @feline-fox Před 29 dny

    Thanks, this was super helpful! I know some power query basics, but I didn't know you could reference a calculation like that within the same query. Game changer

  • @AmpersAndAI
    @AmpersAndAI Před 29 dny

    This was awesome. I needed a far more cleaner formula than the options that were being thrown at me via reddit et al. Many thanks

  • @IqbalHamid
    @IqbalHamid Před měsícem

    How do you compare similar values when they exist in different worksheets? I have worksheets for each month of the year and want to produce a comparison columns by month, stacked against each other.

    • @h2e
      @h2e Před 21 dnem

      The easiest way is to consolidate them. One way could be by doing a lookup so that you have the values from both sheets on one line.

  • @PaulDBaker95
    @PaulDBaker95 Před měsícem

    Hi thanks for this video, could you let me know: we start our financial year on 1st July 2024 so our version of Week 1 would be then. however, when I use the =WEEKNUM function, it is bringing it up as week 26 (because it thinks that is the 26th week of the year). Is there any way we could tell Excel that our year begins at the start of July instead of January? I hope that makes sense, thank you!

  • @tee-gamer8281
    @tee-gamer8281 Před měsícem

    Thank you. On Point

  • @dpb1997
    @dpb1997 Před měsícem

    HI, this is great video. Thanks for making it. I am having an problem with this - =IFERROR(MATCH(B2,Order_ID,0)+3,""). It will not return 4. The next formular does not work either. I suspect it is to do with the Orders DB sheet. I have formated as a table. Any ideas? Thx

  • @denislaviliev5667
    @denislaviliev5667 Před měsícem

    The database for some of the symbols is almost empty. Run HTGC, and you get only a few years of data

    • @h2e
      @h2e Před měsícem

      It's a free service, so it's still decent and it's probably better than the alternatives.

  • @inno4reel
    @inno4reel Před měsícem

    Thank you very much. Very concise and helpful video lesson.

  • @sparkle_spree_byricha1515

    What if the time difference is 12:30 hours. Its not taking this formula. Can you please explain it.

  • @lgambis
    @lgambis Před měsícem

    this is EXACTLY what I was looking for

  • @shahswatmallick1222
    @shahswatmallick1222 Před měsícem

    I was facing the exact problem in the first formula. Thank you very much - you are amazing. Keep it up !!!

  • @beisatonlineshopping5713
    @beisatonlineshopping5713 Před měsícem

    Thank you for this great tutorial, the calculation shown in the video is for "RSI exponential" right ? . normal RS = AVG Gain/AVG Loss) , am i right ?

    • @h2e
      @h2e Před měsícem

      Yes, and I believe that's normally what most sites us. Since it's a momentum indicator, exponential is probably most appropriate.

  • @mvred100
    @mvred100 Před měsícem

    It's best to also show how you calculate the number of shares you end up with. That's the most essential part of this exercise.

  • @guarddogy
    @guarddogy Před měsícem

    Thanks, this helped me come up with a chart solution today.

  • @sounduniverse9060
    @sounduniverse9060 Před měsícem

    Thank you so much.. just a question what if i have more than one task in single day ?

  • @jillianrisse
    @jillianrisse Před měsícem

    This was a super helpful tutorial. Thank you so much. Any suggestions on how to change formatting to a month-year drop down? So this can be used for past and future years (vs this year).

  • @jillianrisse
    @jillianrisse Před měsícem

    This was a super helpful tutorial. Thank you so much. Any suggestions on how to change formatting to a month-year drop down? So this can be used for past and future years (vs this year).

  • @abcd-o8e
    @abcd-o8e Před měsícem

    page 404

    • @h2e
      @h2e Před měsícem

      thanks. it has been fixed

  • @partyboyww
    @partyboyww Před měsícem

    Nice video but i can't get it to work, i have this formula in X35: =IFERROR(H35+U35; "") (H35 is my start amount, and U35 is my PnL, and if it's empty it will be blank) How do i apply it to this formula i keep getting errors, can somebody pls help me? :)

  • @johnichie6130
    @johnichie6130 Před měsícem

    God bless you

  • @garyandrewranford
    @garyandrewranford Před měsícem

    I've just rediscovered Wondershare Filmora (WF). Bought it many years ago.... I was using 11Labs text to speech AI voice cloning. Suffice to say, It is full of bugs and errors, where many of my small paragraphs of conversions become annoyingly recorded with ticks, and odd human noises (Which were not on the recording). The support was useless too, no replies to any of my emails. So, I have just used WF and the voice clone with text to speech conversion is brilliant, 5 stars... 🙂👍💯❤

  • @betterb4584
    @betterb4584 Před měsícem

    How about if data in pivot is numbers and you will lookup is numbers also. Is it applicable even not letters/word?

  • @ashahussein603
    @ashahussein603 Před měsícem

    How do I replicate the month so that I have a worksheet with 12 months instead of one? I want them to all to be the same size but to have them appear one after the other as I scroll down the page? I want to be able to view the upcoming months. Also at 9:15, how are the cells being frozen? What buttons are being pressed?

  • @chrisc.8862
    @chrisc.8862 Před měsícem

    Thanks, Is there a way to make the chart show only months with values ie in this case only show Jan - Mar, on the chart but without changing the source data, so in the next month when data is provided for April, the chart shows this line without changing the data source?

  • @MrTamtaramtam
    @MrTamtaramtam Před 2 měsíci

    Euro template is excellent, having lots of fun with lads :) Can't thank you enough.

    • @h2e
      @h2e Před 2 měsíci

      Thank you for the support. I'm glad you are enjoying it!

  • @ramonaswope8327
    @ramonaswope8327 Před 2 měsíci

    I have no identifier for checks. It is just the check number. Same with deposits I have odd and different descriptions what if you just want the excel to look at date and amount or check number date and amount. Then allow us to use the reconciler tool X short cut if multiples and clear accordingly

    • @h2e
      @h2e Před měsícem

      If you are willing to send me a snapshot of what some of your descriptions look like I can try to see if there's a way to make it work. The reason I set it up this way is to avoid matching things which it shouldn't, and if there's no way to know what a transaction definitely is without some logic built into it, that creates the risk that there could be some false matches.

  • @Practitionher
    @Practitionher Před 2 měsíci

    Thank You

  • @twerktospec
    @twerktospec Před 2 měsíci

    Great Awesome Spectacular

  • @paulmeggison8211
    @paulmeggison8211 Před 2 měsíci

    Hi. The last 16 fixtures are in correct. Do we change these ourselves? Please advise. Thanks

    • @h2e
      @h2e Před 2 měsíci

      If the standings/fixtures for the round of 16 are incorrect I would double-check your inputs. I tested it and it looks to be calculating properly and all the matchups are correct.

    • @paulmeggison8211
      @paulmeggison8211 Před 2 měsíci

      @h2e my actual fixtures are correct my player fixtures are different

    • @paulmeggison8211
      @paulmeggison8211 Před 2 měsíci

      I've got this far an all fixtures are messed up. The actual fixtures are correct, player fixtures are random what do I do ?

    • @h2e
      @h2e Před 2 měsíci

      well if the player fixtures are incorrect then that just means that their predictions weren't the same as the actuals, which is to be expected. if you wanted them to re-pick for the knockout stages, then you could use the overrides to force the correct standings and matchups.

  • @f_0_n
    @f_0_n Před 2 měsíci

    We're having trouble in our sheet, the teams aren't updating in the matches of the knockout round

    • @h2e
      @h2e Před 2 měsíci

      Please double-check the scores you have entered in to make sure they are in the right format (0:0). If this is correct, you should also see the tables populate correctly. If there's an issue, it's probably due to a score being entered incorrectly somewhere. For example, even if you put a team as winning 1:0, make sure the order is correct (e.g. you you may need to enter it at as 0:1 rather than 1:0, depending on the order of the teams).

    • @f_0_n
      @f_0_n Před 2 měsíci

      ​@@h2e that's not really the problem. We've used the #:# formatting, we're gathering points, and the groups are populating. We've decided to only predict the games from the group phase, and predict the following now that it ended. In the Actuals sheet, the knockout fixtures populated correctly. In the Players sheets, they didn't

  • @raakashofficial
    @raakashofficial Před 2 měsíci

    Thanks, Man I appreciate your work