Calculate Subtotals in Excel

Have you ever shopped online and mindlessly put items into your shopping cart? Then you go to check out and look at the Subtotal. Then you laugh. Then you close the window. That kind of sticker shock may happen once a while in our shopping lives and it come from the magic of the mathematical concept of addition. This magic is also available in Excel! In addition, you can conjure up sophisticated numbers across different categories with the Subtotal feature in Excel. Learn all this is less than ten minutes (that’s less time it takes to do a full load of laundry!).

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.