Excellent Dude
Excellent Dude
  • 97
  • 438 257
How to use the Excel FORECAST Function #exceltutorial
In this video, I'll demonstrate how to use the Excel Forecast function to generate estimates of future values based on past data.
It is a super easy function that will help business analysts to come up with "guesstimates" on trend data.
If you find my Microsoft Excel tutorial videos informative, please give this video a thumbs up.
Please consider subscribing as it will really help my channel grow and you'll get access to subscriber-only live streams where I will answer your questions live!:
SUBSCRIBE: ua-cam.com/users/ExcellentDude
☑️ About the Excellent Dude Microsoft Excel Tutorials
I create a wide variety of Microsoft Excel tutorials to help beginners all the way to advanced users.
#excelhowto #exceltutorials #learnexcel
Переглядів: 428

Відео

Excel SUBTOTAL or SUM?
Переглядів 23111 місяців тому
🔥 Excel Subtotal Function Demystified! Learn to Supercharge Your Data Analysis! 🔥 Are you ready to take your Excel skills to the next level? Join us in this comprehensive Excel tutorial where we delve into the powerful Subtotal function and compare it to the familiar Sum function. Whether you're a beginner or an experienced Excel user, this video will provide you with valuable insights into how...
How to use the IF Function In Excel | Functionality and Examples
Переглядів 230Рік тому
In this informative Excel tutorial, you'll learn how to master the IF function and harness its power for efficient decision making and data analysis. I'll take you step-by-step through two practical examples to simplify your understanding. In the first example, you'll discover how to quickly identify passing and failing students in a list of exam scores. The IF function will help you make decis...
How To Make a Lottery Number Generator in Microsoft Excel | Excel Tutorial
Переглядів 10 тис.Рік тому
Get your own lottery number generators at: www.excellentdude.com Have you ever dreamt of winning the lottery? I’m going to show you how to create your very own lottery number generator using Microsoft Excel and learn some skills along the way. Become an Excellent Person and join this channel to get access to perks: ua-cam.com/channels/rgiSOsfsZHgsjPpsxhz79w.htmljoin If you find my Microsoft Exc...
How to Remove Duplicate Values in Excel | 2 Easy Methods #exceltipsandtricks
Переглядів 244Рік тому
Are you tired of sifting through cluttered data in Excel? Do you want to streamline your spreadsheets and make them more organized and accurate? In this tutorial, I'll show you how to easily remove duplicates in Excel in two different ways. I'll demonstrate these two methods for identifying and eliminating duplicate rows, columns, or cells, so you can choose the one that works best for your nee...
How to Add Line Breaks Within Excel Formulas | Char(10) Function
Переглядів 3,4 тис.Рік тому
Welcome to our comprehensive Excel tutorial where we'll show you how to unleash the power of the CHAR(10) function to add line breaks within your formulas. Line breaks are a valuable tool when you need to structure your Excel formulas for better readability and organization. In this step-by-step tutorial, we'll walk you through the process of using the CHAR(10) function effectively to insert li...
Excel Functions Compared: CHOOSE vs VLOOKUP | Excel Tutorial
Переглядів 363Рік тому
Hello and welcome to this tutorial on why the CHOOSE function in Excel is better than using VLOOKUP. In this video, we will explore the limitations of VLOOKUP and how the choose function can solve them. VLOOKUP is a commonly used function in Excel that allows you to search for a value in a table and return a corresponding value from the same row. However, it has its limitations. It can only sea...
Unleash the Power of Conditional Formatting in Microsoft Excel
Переглядів 445Рік тому
Are you tired of looking at dull and boring Excel sheets? Do you want to add some color to your data and make it stand out? Well, look no further, because in this quick tutorial, I'm going to show you how to use conditional formatting to change the color of cells based on their value! If you find my Microsoft Excel tutorial videos informative, please give this video a thumbs up. Please consider...
How Good Is ChatGPT at Creating Excel Formulas?
Переглядів 404Рік тому
How Good Is ChatGPT at Creating Excel Formulas?
How to Add Mr. or Mrs. to Value in Excel
Переглядів 3,1 тис.Рік тому
How to Add Mr. or Mrs. to Value in Excel
How to Type The Squared Symbol in Excel | Excel Tutorials
Переглядів 54 тис.Рік тому
How to Type The Squared Symbol in Excel | Excel Tutorials
Microsoft Excel Tutorial for Beginners | Excel Tutorial
Переглядів 1 тис.Рік тому
Microsoft Excel Tutorial for Beginners | Excel Tutorial
How to Convert Number Grades to Letter Grades in Excel
Переглядів 10 тис.Рік тому
How to Convert Number Grades to Letter Grades in Excel
How to Define Variables in Microsoft Excel | Never Retype the Same Values Again
Переглядів 3,7 тис.Рік тому
How to Define Variables in Microsoft Excel | Never Retype the Same Values Again
How to Add Trailing Zeros in Microsoft Excel | Add Zeros After Numbers
Переглядів 7 тис.Рік тому
How to Add Trailing Zeros in Microsoft Excel | Add Zeros After Numbers
How to Automate Row Numbers in Excel | How to Use the Excel ROW Function
Переглядів 208Рік тому
How to Automate Row Numbers in Excel | How to Use the Excel ROW Function
How to Hide and Unhide Columns and Rows in Excel | Excel Tutorial
Переглядів 144Рік тому
How to Hide and Unhide Columns and Rows in Excel | Excel Tutorial
How to use the LEFT, RIGHT, and MID Functions in Microsoft Excel
Переглядів 217Рік тому
How to use the LEFT, RIGHT, and MID Functions in Microsoft Excel
How to Insert Images in Microsoft Excel the CORRECT Way
Переглядів 4432 роки тому
How to Insert Images in Microsoft Excel the CORRECT Way
How To Create A Pivot Table From Multiple Worksheets
Переглядів 8 тис.2 роки тому
How To Create A Pivot Table From Multiple Worksheets
How to Make a Thermometer Chart in Excel | Easy Step by Step
Переглядів 1,1 тис.2 роки тому
How to Make a Thermometer Chart in Excel | Easy Step by Step
How to Move Rows and Columns in Excel | Excel Tutorial for Beginners
Переглядів 1032 роки тому
How to Move Rows and Columns in Excel | Excel Tutorial for Beginners
Make Data Filtering Easier with Slicers!
Переглядів 2742 роки тому
Make Data Filtering Easier with Slicers!
How to add an Average Line to a Chart in Microsoft Excel
Переглядів 4 тис.2 роки тому
How to add an Average Line to a Chart in Microsoft Excel
How to Add Formulas to a Pivot Table | Excel Tutorial
Переглядів 2102 роки тому
How to Add Formulas to a Pivot Table | Excel Tutorial
How to Type The Squared Symbol in Microsoft Excel | Excel for Beginners
Переглядів 5842 роки тому
How to Type The Squared Symbol in Microsoft Excel | Excel for Beginners
How to Link Multiple Excel Worksheets Easily! | Microsoft Excel 3D Formulas Explained
Переглядів 3722 роки тому
How to Link Multiple Excel Worksheets Easily! | Microsoft Excel 3D Formulas Explained
Make a Keno Simulator Using Excel!
Переглядів 5 тис.2 роки тому
Make a Keno Simulator Using Excel!
The Excel REPLACE Function
Переглядів 4732 роки тому
The Excel REPLACE Function
How to Embed Excel Files Into PowerPoint | Add Excel Into PowerPoint
Переглядів 2292 роки тому
How to Embed Excel Files Into PowerPoint | Add Excel Into PowerPoint

КОМЕНТАРІ

  • @hotpotato7392
    @hotpotato7392 18 днів тому

    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? 😁

    • @ExcellentDude
      @ExcellentDude 13 днів тому

      I've thought about a roulette sim but the betting portion seemed overly complicated (unless using VB) with betting corners, etc. Perhaps I'll do a simple one without the betting component

  • @jfarr206
    @jfarr206 21 день тому

    Perfect. Just what I needed. Thank you!

  • @PierreJuste-p6l
    @PierreJuste-p6l Місяць тому

    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)

  • @nevilledamm6265
    @nevilledamm6265 Місяць тому

    Hey there excellent dude, How can I do this in apple please?

  • @adilhassan987
    @adilhassan987 Місяць тому

    thanks very easy and i did it

  • @Roar_of_a_Lion
    @Roar_of_a_Lion Місяць тому

    THANK YOU!!!!!!

  • @ishramuaadh9510
    @ishramuaadh9510 2 місяці тому

    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

  • @tavimihai3095
    @tavimihai3095 2 місяці тому

    Thank you so much ! You saved me !!

  • @xlwatcher8885
    @xlwatcher8885 2 місяці тому

    Is there a link to download the files to follow along? Thank you

  • @NMG1007
    @NMG1007 2 місяці тому

    Thank you very much 😊 ☺️ 🙏

  • @soms42
    @soms42 3 місяці тому

    for assigning values, vlookup is much easier and better then nexted if funtion

  • @muralis9759
    @muralis9759 3 місяці тому

    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

  • @cubehire3653
    @cubehire3653 4 місяці тому

    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.

    • @ExcellentDude
      @ExcellentDude 4 місяці тому

      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

  • @RobCLynch
    @RobCLynch 4 місяці тому

    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.

    • @ExcellentDude
      @ExcellentDude 4 місяці тому

      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!

    • @RobCLynch
      @RobCLynch 4 місяці тому

      @@ExcellentDude Thank you for your excellent reply.

  • @danijelakeserovic1134
    @danijelakeserovic1134 4 місяці тому

    Well my symbol sign is not working that tab won't open what now

    • @divyanshagrawal7623
      @divyanshagrawal7623 4 місяці тому

      Then u can't do anything have fun

    • @ExcellentDude
      @ExcellentDude 4 місяці тому

      Hi there. Could you give me more details of the issue you are encountering. I'm not sure what tab are you referring. The "Insert"?

  • @ronaldlawrence8777
    @ronaldlawrence8777 4 місяці тому

    Worked great! Thanks Made my work a lot easier

  • @dreamfyre1811
    @dreamfyre1811 5 місяців тому

    Is there a way to generate a button to click instead of pressing shift+F9?

    • @ExcellentDude
      @ExcellentDude 5 місяців тому

      You could use VB and/or a macro to create a button to save you from having to do shift+F9

  • @Raonaidh
    @Raonaidh 5 місяців тому

    Thank, exactly what I was looking for!

  • @JoesPhenomenal
    @JoesPhenomenal 5 місяців тому

    Cool.... Thanks for that. Will try this out and see what happens.

    • @ExcellentDude
      @ExcellentDude 5 місяців тому

      hopefully that solves the problem - if not, let me know and I can dive deeper into the file.

  • @rajeevmalur
    @rajeevmalur 5 місяців тому

    Thanks this was very helpful. Also, wanted to know if we can change the format to currency while we apply this formula?

    • @ExcellentDude
      @ExcellentDude 5 місяців тому

      You could adjust the "Increase Decimal" (below the Number Format drop down) to increase the number of zeros showing after the decimal point.

  • @ShelbyBryant
    @ShelbyBryant 5 місяців тому

    so great!

  • @mahaboobkhalid3553
    @mahaboobkhalid3553 5 місяців тому

    Hi, Could you please make the UAE based lottory prediction calculations which works through previous draw results

    • @ExcellentDude
      @ExcellentDude 5 місяців тому

      Thanks for the suggestion! I'll take a look at the UAE Lottery

  • @naomii.m6539
    @naomii.m6539 6 місяців тому

    Well explained. Better than my lecturer

  • @janicelayne9053
    @janicelayne9053 6 місяців тому

    I love the pace & depth at which you walk us through setting up these progress charts. Thank you so much!

  • @Maddie-rh7zf
    @Maddie-rh7zf 6 місяців тому

    Thank you; simple, brief, and helpful!

  • @dariknour6051
    @dariknour6051 7 місяців тому

    First of all thank you sir. One thing, if I write a score of lets say 120, it returns an 'A'. So, how can fix the rage between 0-100?

  • @Matt-lc8qt
    @Matt-lc8qt 7 місяців тому

    This is super helpful. Never knew you could do something like this. Thanks! :)

  • @drvmyslfcrzy
    @drvmyslfcrzy 7 місяців тому

    This only works if you add the zeros first.. didn’t explain how to remove zeros that are there to begin with.

  • @markrationalthinker
    @markrationalthinker 8 місяців тому

    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.

  • @sexyshelly2011
    @sexyshelly2011 8 місяців тому

    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!!

    • @ExcellentDude
      @ExcellentDude 8 місяців тому

      I'm not sure if I can help out with your request. However, I'm sure there are online tools that could do that for you.

  • @herdityawahyu1250
    @herdityawahyu1250 8 місяців тому

    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!

    • @pratyushpillai
      @pratyushpillai 6 місяців тому

      great video + your comment was really helpful. thank you both :)

  • @harvey8695
    @harvey8695 8 місяців тому

    wouldn't it be faster to just copy the tables into one big table and insert a new pivot table against the new combined table?

    • @ExcellentDude
      @ExcellentDude 8 місяців тому

      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.

  • @floridaclaimersted5243
    @floridaclaimersted5243 9 місяців тому

    😊😊😊😊😊

  • @ashrafctg
    @ashrafctg 9 місяців тому

    Thanks a ton. Very helpful.

    • @ExcellentDude
      @ExcellentDude 9 місяців тому

      I'm glad it was helpful! Thanks for the comment!

  • @cardboardmusic
    @cardboardmusic 9 місяців тому

    Tried it several times, but never worked, so I gave up.

    • @ExcellentDude
      @ExcellentDude 9 місяців тому

      Sorry to hear that. Can you provide more details what is going wrong and maybe I can help get it working for you.

    • @cardboardmusic
      @cardboardmusic 9 місяців тому

      @@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.

    • @ExcellentDude
      @ExcellentDude 9 місяців тому

      OK - glad to hear you have a working solution. Cheers!

  • @andrejdebnar5065
    @andrejdebnar5065 9 місяців тому

    Instead concatenate, I can use & for simply conection of the cells, perfect :D

  • @scottblazicek7369
    @scottblazicek7369 9 місяців тому

    Best example for What I was looking for!!! Thanks!

  • @CajunConstitution57
    @CajunConstitution57 10 місяців тому

    Excellent! 😉 I've been trying to figure this out for nearly an hour. Your video was perfect!

  • @rockcrawler001
    @rockcrawler001 10 місяців тому

    Quick and easy... love it and it saved me a ton of time ☺

  • @BarryB468
    @BarryB468 10 місяців тому

    👍🏽

  • @pindol-nik
    @pindol-nik 10 місяців тому

    This project is so versatile, with small changes can serve as dice roll simulator, so many uses. 🎲🎲🎲

  • @pindol-nik
    @pindol-nik 10 місяців тому

    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 👍🏻

    • @ExcellentDude
      @ExcellentDude 10 місяців тому

      Cool idea! It's certainly possible. Perhaps I'll add a Part 2 to this video and incorporate some of those ideas.

  • @parvezkhan-tv8ze
    @parvezkhan-tv8ze 10 місяців тому

    Superb... I just got how to work with excel Thank you 😊

  • @BarryB468
    @BarryB468 10 місяців тому

    👍🏽

  • @daltonlange6417
    @daltonlange6417 11 місяців тому

    hey alyssa

  • @nkirotemwaria6135
    @nkirotemwaria6135 11 місяців тому

    Also only seeing Fs all the way down.

    • @ExcellentDude
      @ExcellentDude 11 місяців тому

      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.

    • @cardboardmusic
      @cardboardmusic 9 місяців тому

      @@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.

  • @jamesfoster7595
    @jamesfoster7595 11 місяців тому

    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.

    • @ExcellentDude
      @ExcellentDude 11 місяців тому

      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.

  • @BarryB468
    @BarryB468 11 місяців тому

    👍🏽

    • @ExcellentDude
      @ExcellentDude 11 місяців тому

      Thanks for the thumbs up Barry