Generate Random Numbers in Excel

Do you like randomness? If so this is the video for you cause it will cover how to generate random numbers in Excel. There are three examples: One using the RAND function, another using the RANDBETWEEN and one more using the Data Analysis Toolpak Random Number Generator option.

Create a Timeline with Milestones

If you've got to schedule tasks or milestones onto a horizontal axis, it can readily be done in PowerPoint. However if this was a recurring task and you wanted to make it easier to do or just create a template why not create it in Excel, plug in to updated info and let the charting engine take care of the work? Check out the video to learn how to create a timeline that has multiple milestone markers or labels.

Create an Amortization Table with a Pre-Payment Option

Are thinking about real estate or maybe considering purchasing a house, condo or other type of property? Usually you'll be thinking about getting a loan and then thinking about how to pay for it. Maybe there will even be an option to pay some of the loan early. But then you may want to know how that will impact the amount and term of the load. Check out this video to see how to create an amortization table that also let you calculate pre-payment amounts.