MS Excel Formula =ISERROR()

Start to use isError formula in excel when you are calculating something.

I have seen many time error, In Excel.

• #Ref
• #DIV/0
• #NAME?

You can remove all this error and also vice some user friendly value or message there by using ISERROR formula.

IsError(value) returns boolean value in True or False.

try some example in your excel sheet.

=IsError(1/0)

it will return TRUE, it mean there is some error.

Here in this case you can also vice some error message using if condition.

=IF(ISERROR(1/0), "Some Error!", 1/0)

or like that.

Ok, if you don't want to write down this formula every where in your calculation and you will see #NAME?, #Ref, #DIV/0 etc. messages in your excel screen, at list you should not print out them.

You can also hide those error when did you print.

Click on Page Setup.
Click on Sheet Tab.
there is a list box named "Cell error as".
See following image.


But, IsError formula is best, this formula is form Office XP version.

Read More

Live Search Maps Add-In for Microsoft Office Outlook

We all know that there is new version of Office 2007, and there is new Microsoft Office Outlook.

there are so many new functions see online help,

now there is new Add-In for Live Search Maps in this application.

see road, calculate travel distances between locations, print map, save custom locations.

Outlook Online

Read More

Microsoft Office 2007 File Format

Science last some tome I have to develop application with Microsoft Office 2007. I found that there are so many new features. Really g8,

There are some new file formats and so there are some new extension also available. Most common software Microsoft Word, Excel, PowerPoint and MS Access. I familiarly with them and I have a long time experience with them. I have many uses with it’s file format.

Word
File= .docx
Template= .dotx
Other Support= docm, doc, dotm, dot, mht, mhtml, htm, html, rtf, txt, xml, wps

Excel
File = .xlsx
Template = .xltx
other support = xlsm, xlsb, xls, xml, mht, mhtml, htm, html, xltm, xlt

PowerPoint
File = .pptx
Template = .potx
PowerPoint Show = .ppsx
Other Support = pptm, ppt, potm, pot, thmx, ppsm, pps, ppam, ppa, xml, mht, mhtml, htm, html, gif, jpg, png, tif, bmp, wmf, emf, rtf

Access
File = .accdb

There are new icon for the of them

Thought they did not change it’s application name it was the same as wall.
Word = winword
Excel = excvel
Power Point = powerpnt
Access = msaccess

Read More

Ribbon

I m sure that many people have used Microsoft Office, if they have not used it then minimum they have heard about it, if they are related with computer operating.

I m using Microsoft Office from many years, I used office 2000, XP, 2003 and now I have using Office 2007. I really like it.

Here you have come to know a new word “RIBBON”!

MS Access 2007

If u are not familiarly with ribbon that Click Here, for easy training to use Ribbon. more read about this

there is short cut key "Ctrl+F1" for auto hide Ribbon.

Read More