Archive for the ‘Ms Office’ Category

« Older Entries
Newer Entries »

Excel Tutorial: IF Function

September 27th, 2011 by @HKw@! | No Comments | Filed in Excel, Ms Office

How to create a formula to check whether a number is within the range and how to grade it into categories?

You may use IF function in the data. The If function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE.

The syntax for the If function is:

If( condition, value_if_true, value_if_false )

  • condition is the value that you want to test.
  • value_if_true is the value that is returned if condition evaluates to TRUE.
  • value_if_false is the value that is return if condition evaluates to FALSE.

Let’s take a look at an example: (more…)

Share

Tags: ,

How to Create a Dropdown List in Microsoft Excel 2010

August 1st, 2011 by @HKw@! | No Comments | Filed in Ms Office, Ms Office 2010

A dropdown list enable user to enter the data in more efficient way and standardized.

User is allowed to select the data from the list and to make the data easier to maintain.

To create the list for the drop down ,enter the data in a single column cells (more…)

Share

Tags: ,

How to open MDI files in Microsoft Office 2007

June 29th, 2011 by @HKw@! | No Comments | Filed in Ms Office, Windows

I got a ticket from my user said that she cannot open a file in .mdi format. I never see this kind of file format before. So, i just google it and i got the answer. An MDI file, which stands for Microsoft Document Imaging, is a file format of Microsoft for storing raster images of scanned documents together with optional annotations or metadata, and can only can only be opened or edited in Office Document Imaging.

In Microsoft Office 2003, you can open .mdi file by default. However, you cannot open .mdi file in .  The reason this happen is because by default Office 2007 does not install Microsoft Document ImaginMicrosoft Office 2007g. So if you want to open the MDI file in Office 2007, you have to install the feature manually.

To install MDI, just follow below steps:- (more…)

Share
« Older Entries
Newer Entries »
BlogCatalog