![HowtoExcel.net](/img/default-banner.jpg)
- 506
- 2 166 238
HowtoExcel.net
Canada
Registrace 18. 10. 2011
Excel tutorials from beginner to advanced including VLOOKUP, pivot tables, macros, vba, and also templates that I have made.
How to Visualize Inflation Trends with Easy Column Charts in Excel
#excel #msexcel #exceltips #exceltutorial #exceltricks #office365 #microsoft365 #spreadsheet #spreadsheets #exceltricksandtips #inflation
zhlédnutí: 59
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
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
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
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
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
Thanks for the video. I have a question, can I change the color and description of the button?
Beautiful presentation. Really enjoyed it. Is there a way we can get the excel data for practice purposes
very nicely explain the concept.thank you
This actually is very helpful! Thx a lot
Saviour ! Thank You !
Phenomenal video! This explanation is better than Seeking Alpha's
This tutorial was very useful! Thanks 🙏
Great job
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.
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.
Thank you
Really helpfull without going into too much detail, thanks !
what is tickercount?
This is a named range I used to reference the number of tickers.
Thank You Sir
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)
Perfect! Please share data file for practice
Excellent tutorial, thanks so much. Very helpful!
thank you so much!!!
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 ?
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
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
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.
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.
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!
Thank you. On Point
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
The database for some of the symbols is almost empty. Run HTGC, and you get only a few years of data
It's a free service, so it's still decent and it's probably better than the alternatives.
Thank you very much. Very concise and helpful video lesson.
What if the time difference is 12:30 hours. Its not taking this formula. Can you please explain it.
this is EXACTLY what I was looking for
I was facing the exact problem in the first formula. Thank you very much - you are amazing. Keep it up !!!
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 ?
Yes, and I believe that's normally what most sites us. Since it's a momentum indicator, exponential is probably most appropriate.
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.
Thanks, this helped me come up with a chart solution today.
Thank you so much.. just a question what if i have more than one task in single day ?
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).
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).
page 404
thanks. it has been fixed
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? :)
God bless you
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... 🙂👍💯❤
How about if data in pivot is numbers and you will lookup is numbers also. Is it applicable even not letters/word?
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?
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?
Euro template is excellent, having lots of fun with lads :) Can't thank you enough.
Thank you for the support. I'm glad you are enjoying it!
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
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.
Thank You
Great Awesome Spectacular
Hi. The last 16 fixtures are in correct. Do we change these ourselves? Please advise. Thanks
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.
@h2e my actual fixtures are correct my player fixtures are different
I've got this far an all fixtures are messed up. The actual fixtures are correct, player fixtures are random what do I do ?
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.
We're having trouble in our sheet, the teams aren't updating in the matches of the knockout round
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).
@@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
Thanks, Man I appreciate your work