This article is a basic guideline on how to insert excel spreadsheet into word document. It gives a comprehensive list of the available options and describes each one of them in graphic detail.

Read the rest of this entry »

Popularity: 73%

This article talks about formatting and borders.

Read the rest of this entry »

Popularity: 5%

If you want to select adjacent sheets then you can do that by holding down the shift key and clicking on the next sheet tab.For e.g. There are six worksheets - sheet 1 to sheet 6. And you want to select one to four then simply select the first sheet, hold down the shift key and click on the forth sheet.You will notice this will automatically select sheet 2 and 3 as well.
However if you want to select non adjacent sheets then hold down both the shift and control keys together and choose the desired sheet.

If you want to do a mouseless selection, just hold down the shift and control keys and press “Page up” or “page down”.

If you want to select all the worksheets at once then you can also right click on one of the sheet tab and choose “Select all sheets” option.

Popularity: 5%

Once we have applied filter to our data using the excel’s “AutoFilter” option and we want to sum only the non-hidden range, then we can’t use the simple “sum” function as it adds both the hidden and visible cells. In that case we can use the excel’s subtotal function as it only sums the visible range.

The syntax of the Subtotal function is:

SUBTOTAL(function_num,range_reference1, range_reference2….)

We can perform 11 different functions in conjunction with subtotal.

Function_Num - Function
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV
8 STDEVP
9 SUM
10 VAR
11 VARP

Suppose you have a list of 4 different products - A, B, C and D along with their quantity sold.

And you wish to add up only the quantity sold of product A. Then if you apply filter and sum the range using “Sum” function then it will give the total for all the products

Whereas if you use subtotal function you will only get it for product A as shown below:

Popularity: 17%

Whenever you have some text in one column and you wish to break it into several ones then instead of retyping the text in the next column, you can use the “Text to Columns” option under the “Data” tab. For e.g. Both the names and marks of the students are in the same column(say Column A) and you want to separate them in different columns as shown below:

The first step is to highlight the column that needs to be separated. Then click “Data” and choose “Text to Columns” option.

Then choose the delimited option.

Select the “space” check box, keeping others unchecked. So whatever text is after the space will be put into the next column.

As soon as you click the “Next” tab you will see the preview of your data. And you will notice that it has put marks into the next column.

Now just click the “Finish” button and it will be done.

Popularity: 5%

To switch between your open excel workbooks,you can use the “Window” drop-down menu as it lists all the workbooks that are currently open. Alternatively, you can use the shortcut keys(Alt+Tab) to move from one window to another.You need to hold down the Alt key as you repeatedly press the Tab key to switch from one window to another.
When the desired workbook window is selected, release the Alt key and the
actual workbook will be displayed.
However using this combination(Alt+Tab) will display the names of not just the excel
workbooks but all other applications that are currently open like word documents, notepad, internet explorer etc. If you only want to toggle between your open excel workbooks you can use (Ctrl+Tab) key combination instead You can also switch between excel sheets using the shortcut keys (Ctrl + F6).

Popularity: 7%