Excel 2007

Microsoft Excel Basics – Creating Sums in Excel

Thumbnail image for Microsoft Excel Basics – Creating Sums in Excel May 27, 2011

Creating sums in excel is not that hard after all. I know most people see Microsoft Excel spreadsheets and automatically think they are difficult. As you will see in this tutorial, making sums in Excel is just a matter of knowing the formulas. Once you learn the Microsoft Excel basics it is easy to learn the more difficult features and use Microsoft Excel to your advantage. I believe that everyone can find the use for this fantastic software. Even the stay at home mum can make a family budget in Excel as the uses for this program are endless.

Read the full article →

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 →