Formula trouble? that’s easy!! :)

December 4, 2009

one good things of excel are we can calculate a whole lot of massive data, manage and manipulate it in no time. no matter with average, sum, even standard deviation can be calculated in very short time. of course we do that by inserting the formula, and as long as we know how to do it properly and there should be no problem in managing our data, because microsoft excel will calculate it and sort it all for us, however if you insert the wrond command for the formula or wrong method of inserting data, then you should have a hard time with microsoft excel.

this are list of common problem that commonly faced by students:

– forget to put the “=” in the begining of the formula, not so fatal, but a waste of time.

– having trouble of using the formula system efficiently.

and many more, but here are the basic tips for you to understand more about excel and do better. the principal is basically the same, you just need to understand how the excel mechanism work and all of your problem should be solved.

let’s try with the simplest function of the excel formula, SUM.

Using the SUM Function

The SUM function in Excel is specifically designed to add values from different ranges. The SUM Function can be typed into a cell in Excel, or inserted via the Insert Function tool to the left of your Formula bar. The syntax of the SUM Function is SUM(number1,number2, …).  SUM is the function name, and contained within the brackets are “arguments”, or the pieces of information that Excel requires to complete the Function.  The SUM function allows from 1 to 30 arguments (number 1, number ….) for which you require the total value or SUM.

Using Ctrl to Mark Cells

If you wish to add cells that are non-contiguous (not joined together), type in your function =SUM( click in the first cell you wish to add.  Hold down your Ctrl key and click in all other cells you wish to add up, then type in a ).  Typing in a comma instead of selecting with your Ctrl key also works just as efficiently as well.

Using SUM to Add a Range from a Different Worksheet

You can easily use SUM to add up the same range in different worksheets.  Click in the cell you want the result of your addition in, then holding down the Shift key, click on the next worksheet that you wish to include in your calculation and highlight the range to be used, then click Enter.

One thing to note here however, is that if you insert a worksheet in the middle of the range that you have told the SUM function to add, then the same range on that worksheet will be included in your sum. 

TIP! If you wish to force any new inserted worksheets to be included in the SUM range, try this.  insert a blank worksheet at the beginning of your sheets in your workbook, and a blank sheet at the end.  Now in the cell that you wish the result of your addition to appear in type in =SUM( and then click on the new first blank worksheet and highlight the range you require to be added in all worksheets.  Hold down your Shift key and click on the new last blank worksheet, then close your bracket ) and hit enter.  Now hide the first sheet and the last sheet by going to Format>Sheet>Hide.  This will force any new worksheets to be included in the SUM range as all new worksheets will be between the 2 blank ones.


Having trouble with chart? read this!=D

December 4, 2009

list of problem that will be solved by reading this article:

– you cannot get the chart to be like the model you want.

– you cannot select data properly and make it appear in the axis that you want.

– you have problem with the chart design, format or layout.

– how to move the finished chart to microsoft word in 3 seconds =D

Create a Chart
To create a chart:

  • Select the cells that contain the data you want to use in the chart
  • Click the Insert tab on the Ribbon
  • Click the type of Chart you want to create


Modify a Chart
Once you have created a chart you can do several things to modify the chart. 

To move the chart:

  • Click the Chart and Drag it another location on the same worksheet, or
  • Click the Move Chart button on the Design tab
  • Choose the desired location (either a new sheet or a current sheet in the workbook)


To change the data included in the chart:

  • Click the Chart
  • Click the Select Data button on the Design tab


To reverse which data are displayed in the rows and columns:

  • Click the Chart
  • Click the Switch Row/Column button on the Design tab


To modify the labels and titles:

  • Click the Chart
  • On the Layout tab, click the Chart Title or the Data Labels button
  • Change the Title and click Enter


Chart Tools
The Chart Tools appear on the Ribbon when you click on the chart.  The tools are located on three tabs:  Design, Layout, and Format. 

Within the Design tab you can control the chart type, layout, styles, and location.

Within the Layout tab you can control inserting pictures, shapes and text boxes, labels, axes, background, and analysis.


Within the Format tab you can modify shape styles, word styles and size of the chart.


Copy a Chart to Word

  • Select the chart
  • Click Copy on the Home tab
  • Go to the Word document where you want the chart located
  • Click Paste on the Home tab


Hello world!

December 4, 2009

Welcome to This is your first post. Edit or delete it and start blogging!