Learn Microsoft Excel with easy to follow video tutorials.
If you’re looking to learn the basics of Microsoft Excel as well as tips and tricks, I invite you to check out the Excel Tutorial videos on my channel!
Nice! 😊 It would be great if the final output looked something like the thumbnail. Will work out one towards that. By the way, how about a roulette simulator? 😁
We appreciate your work, l would like to create a different slots machine it will us six slots l got to trues my numbers, the win number most start by the smallest finish with the biggest, like (09,12.25,34,39,48)
How to write formula for this equation.... If b2 greater then c2 then the results should come with + and how much value that increase For example : b2 is 40 c2 35 then results should come +5
Hello, thanks for the info & it’s amazing, I need another help with formula. I have 0 to 9 numbers & needs to pick 3 numbers from 0 to 9 in the separate cells. The 2nd cell number always should be greater than the first cell pick or it can be same or zero. Similarly with the cell 3 or 3rd pick. Can you please advise me how to do in the excel. I would be happy to connect to learn from you
You are teaching excel formulas which is difficult for me concentrate on and you pipe in distracting music over the instuctions. I hate that you did that.
Thanks for your feedback. When I started my audio wasn't great so I added music to get rid of some of the background noise. Our upcoming videos will have no music
I wonder if theres a way to select a column of numbers and have Excel display which numbers are cold/hot, so i can make a decision on numbers that might be overdue? So, although i am well aware that lotteries are random, there may be a way of using 'overdue' numbers as a long term strategy.
Yes, each draw is random. However, I suppose if you wanted to find "overdue" numbers ... Most lotteries publish historical lists of drawn numbers. You could scrape those numbers and pull in to Excel and find the least occuring numbers and use those as your "overdue" numbers. Good luck! If you win, think of the Excellent Dude. Cheers!
Cannot get this to work. Set it up exactly as you have it, but with a -/+ extended scale in the letter grade column. Anything that falls on the border is scored as the next lower grade: e.g., 93 should be an A, but is scoring as an A- and the range for A- is 90-92, with 90 entered in the center column.
Hi! It’s there by chance a way you could help me design a lottery generator with specific filters? I know nothing about Excel but I do play the lottery and it would be much easier if I could create my own numbers to the print out and fill in my slips!!
Got stuck several times, getting F for all grades. The solution is that the scoring table array - just like in this video - must be sorted/ordered from the LOWEST to the HIGHEST scores/grades. My mistake was that my scoring table array was sorted from the highest to the lowest... that's why I am getting all F... nice vid man, thanks!
It could be quicker if the data was static. However, what if the various tables were separate to support different business requirements (i.e. a table for the East, West, etc.) and were updated on a frequent basis? Then this solution would make more sense.
@@ExcellentDude Thanks for coming back so quickly. In the end I realised that using the IFS function worked just as well. BTW, I suspect that my problem was maybe using commas, instead of semi-colon.
Great concept. Would it be possible to add score system for some symbols and combinations, with spin limits/credits. And button with refresh option? Thanks 👍🏻
Hi there - the key is to make sure when you reference the scoring table on the right (in my video), to use absolute references (noted by $ signs) otherwise when you copy the vlookup formula to other rows, the vlookup will shift what it's looking at which will give incorrect results. Here's an example with absolute references - hopefully this is why your results aren't working (=vlookup(C4,$G$4:$H$8,2,FALSE). Let me know if this was the issue - if not, add your formula to the comments.
@@ExcellentDude I did exactly that and just got Fs and Es. BTW, I found a better solution, use the IFS function, it's just as good (and easier to use). Also, if in doubt use the function wizard, it's sometimes the formatting that causes the problems.
Thank you for the video. Very informative. Quick question. I have values that total 100% but for some reason, I cannot get the % sign to be visible. Anything below 100% will show the % sign. Any suggestions? Thank you.
Hi there! Let me check my files (it's been a while since I did that video). It may be something as simple as making the font size a little smaller or increasing the size of the text box.