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.