Whats Best in 2007 as compared to 2003

Well everyone must be wondering why some of them are still working on 2003 and not 2007 ?
The answer is quite simple. Not every corporate has license to 2007 rather are happy with 2003 as its one of the most stable versions of MS Office and is compatible with all OS and low on resources.
So whats different in 2007 ? Is it just the interface or looks or much more.
Keep following this page for more

How to Present using Excel?

Excel is not only used to create dashboards or MIS. It can be used as a valuable tool to present your views. So how can you do this?

Its all about what you want to present? Who is your audience? What is the end result you are expecting out of this presentation? How valuable and important is this presentation to you?

These are some of the questions you should be asking yourself before you can create something in excel.

I agree that Powerpoint is the tool which is used for presentations but excel is equally useful.

The final outcome can go in PPT but the base design can be on excel

Dual Conditional Formula

These formula are simpler than the "IF" formula

1. COUNTIF: Syntax =countif(range,criteria)

This formula can be used in case you want to count number of specific items in a range For example you have a list of fruits and you want to count of them how many are apples. This formula makes it simple. The formula is countif(Range,"Apples")

In place of Apples one can also specify a cell values. So if you want to know how many ones are there in the range of numbers this formula is easy. Also you can find the count of a specific value in the list to know whether it is distinct or no in the list

2. SUMIF:

Syntax: =sumif(range,criteria,sumrange)

The sum if formula is very useful if you have to add specific values corresponding a particular range. So you have two lists ---in one column you have list of managers(list1) and another number of sales done(list2). Now you have master list of managers and you want to find from the list how many sales did each manager did. The formula and method is easy. =sumif(list1,"manager1",list2)

Try these formula they are simple to use

CONDITIONAL Formula

Here comes the complex formula

The conditional formula means a formula which can work on conditions specified by the user. In case the condition does not match it will give the result of the second condition

The conditional formula is "IF"

Syntax =if(logical test,[valueif true],[valueiffalse]

Explanation: Logical test is the condition

Value if True means if the condition is satisfied this formula will give the result specified in the formula as true else value if false

Eg: I want to put a formula that if the value of two cells is same then I must get result as "YES" else "NO"...The formula is =IF(C2=B2,"YES","NO")

This If formula is very complex as it can be merged with any excel formula

The three components of this formula can be replaced by any formula

Eg: =IF(COUNT(C2:C10)=4,"YES","NO")

This formula means it first counts the numbers in range C2-C10 and if the result is 4 it gives YES else a NO

Eg: =IF(SUM(C2:C10)=4,"YES","NO")

This formula means it first adds the numbers in range C2-C10 and if the result is 4 it gives YES else a NO

We will learn more on this

COUNT Formula

The count formula is very simple and syntax is =COUNT(C2:C10) where C2 and C10 are the range of the cells . However this formula will only calculate the numbers in the range and will not consider the alphabetic characters