Microsoft Excel Training

Microsoft Excel Training We Provide
Professional Training For Microsoft Excel With Video Example

Games in Microsoft Excel

Some where I have heard about playing games in Microsoft Excel ,I have tried a lot about it but failed. Some people told me it is possible only when you have a licensed Microsoft Office, even I have licensed Microsoft Excel in my office but I have not found any game in Excel. If you know how to play games in Excel please guide.

It will be a great help.

You can visit this site for advanced Microsoft Excel Training
Free Microsoft Excel Training

Thanks a lot
Shailendra

FREQUENCY FUNCTION

I am little bit confused about Frequency function in Microsoft Excel. If any one know about this function, please let me know how and where to use this function.

ISERROR in Microsoft Excel

While performing some Mathematical calculation in excel many error comes as result as #DIV/0!
To hide these errors in the result use combination of IF, ISERROR and your calculation like this.

=IF(ISERROR(C4/D4),0,C4/D4)

ISNA and Vlookup in Microsoft Excel

I believe you are frequent user of Vlookup function. Have you ever send #N/A in the result.

When you apply Vlookup on lookup value is it is available in Table array corresponding result will be displayed and if it is not available in Table array an error #N/A will be returned that looks very funny in the result.
To avoid this we use combination of IF, ISNA function with Vlookup, Syntax is as following.

=IF(ISNA(VLOOKUP(C6,$F:$F,1,0)),"",VLOOKUP(C6,$F:$F,1,0))

This formula will replace all #N/A to blank. You can put your custom text or 0 in place of "".

C6 is lookup value
F:F is table array

Try it yourself.

Can any one guide me how to use calculated field in Pivot Table. I making a report in wihch i want to show sum of two fields that are present in data but i do not know how to display the sum.

Indian Cricket

Sehwag made triple century today, what do you say he will continue making it or ????