excel

Excel Tutorial – Making a Basic Spreadsheet That Totals Columns Automatically

March 30, 2011

Making a basic spreadsheet that totals columns automatically using Microsoft excel is easier than you think. When people think about using the program Microsoft excel, they automatically presume that it is a difficult program to use. I guarantee that you will be able to follow this simple tutorial and make your own basic spreadsheet by [...]

Read the full article →

Relative and Absolute Cell References in Excel Formulas

March 14, 2011

One of the more important (and confusing) aspects of creating Excel formulas is relative and absolute cell references. Today, with your permission, we will dispel the confusion and bring you one step closer to becoming an Excel formulas master. In this article, we’ll cover the basics of referring to a cell when creating a formula, [...]

Read the full article →

How to use data from a table to create a graph chart in excel

May 27, 2010

If you have a presentation or a project to do, creating a graph chart from your collected data can make your work look extremely professional. Just say you have some figures in a Excel table and you want to present it more clearly or make them visually eye catching. This is when you need to [...]

Read the full article →

How to merge cells in excel

May 27, 2010

In this tutorial I am going to show you how to merge cells in Excel. In the screenshot below I have an example of why I need to merge cells. As you can see the heading “money earnt” is at the top of one column when I need it to be centered over all the [...]

Read the full article →

How to create a simple budget in Excel

May 27, 2010

When you are new to using Excel you can start by creating a simple budget or just simply adding a list of figures to show what Excel can do. Below I will show you step by step how to create a simple budget. Create a list of all your expenses or all your earnings. See [...]

Read the full article →