TutorialsSoftwareMicrosoft Excel

Excel: How to graph or chart your data!

Written by Marc Roberge | 07 June 2010

graphs

I’m a geek! I like numbers a lot! All types of numbers! Simple data, values, stats, binary, hex…bring it on! I also think formulas and functions are fascinating. I’m also a realist! I know that not everyone feels the same. In fact, some people find numbers boring or befuddling. Enter graphs! Graphs are a palatable way to feed various stats to people who would otherwise scan over your data with a blank stare or yawn their way through your report.

Excel offers a myriad of graph options for all types of data and situations. In this quick tutorial, we will cover the 3 basic graph types: Column or Bar (histograms), Pie Chart and Line Chart.

Add a comment

Excel Tutorial: How to make a loan amortization table

Written by Marc Roberge | 02 June 2010

Excel Loan Amortization 1

In this tutorial, I will show you how to create a fully automated loan amortization table in Microsoft Excel that will show how much of your payment is being applied towards the principal and how much is interest.

We will be using the “loan_calculator” we built in our tutorial titles “Excel Tutorial: How to make a loan payment calculator using the PMT function”. If you didn’t follow that tutorial or don’t have the “loan_calculator” file, you can download it here:

Add a comment

Excel Tutorial: How to make a loan payment calculator using the PMT function

Written by Marc Roberge | 02 June 2010

excelloan

In this tutorial, I will show you how to create a simple loan payment calculator in Excel using a few basic formulas and the PMT function. This calculator can be used by a borrower or lender to establish a payment amount based on an initial loan amount, annual interest rate, repayment term and periods.

Add a comment

MS Excel 2007 Tutorials – How to transpose your data horizontally or vertically

Written by Marc Roberge | 13 January 2010

This is just a quick little Excel tip in response to a question received from a site member. Essentially, I will show you how to transpose data arranged in a column to a row or vice versa.

If your data is arranged like this:

and you would like to arrange it like this:

Simply select the entries you would like to transpose and press Ctrl+C on your keyboard to copy.

Add a comment

dd_badge_75 Are you a blogger, site owner or writer with a tip or review to share?
Do you want a place to showcase your writing and tech savvy?
Are you interested in helping thousands of readers?