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.

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.

Create a Work Breakdown Structure (WBS) in Excel

Are you a project manager and need to create a table version of a Work Breakdown Structure (WBS)? But you don't have MS Project and access to other sophisticated project management tools? Why not do it in Excel. Though not as robust as MS Project, Excel can be used to create or "hack" a WBS in a table form, so check out the video to learn how.