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.

Create a Survey Form with Radio Buttons

Did you know you can create a survey with Excel? Even though it might not be as robust as those online tools like SurveyMonkey, it's not too hard to put together. If you wanted to know how to use the forms feature in Excel, putting together a short survey will be a good entry into it. See the video on how to create a radio button survey in Excel. The radio button concept is using the the form control - Option Button.