Microsoft Excel Formula

TYPE OF FORMULA	EXAMPLE
Conditional	Create conditional formulas
	Check if a number is greater than or less than another number
	Display or hide zero values
	Hide error values and error indicators in a cell
Lookup	Look up values in a range
Date and Time	Add dates
	Add times
	Calculate the difference between two dates
	Calculate the difference between two times
	Count days before a date
	Show dates as the day of the week
	Insert the current date and time in a cell
	Insert Julian dates
Financial	Calculate a running balance
	Calculate a compound annual growth rate (CAGR)
Statistical	Calculate the average of numbers
	Calculate the median of a group of numbers
	Calculate the mode of a group of numbers
Math	Add numbers
	Subtract numbers
	Multiply numbers
	Divide numbers
	Calculate percentages
	Round a number
	Raise a number to a power
	Calculate the smallest or largest number in a range
	Calculate the factorial of a number
	Create a multiplication table
Counting	Count cells that contain numbers
	Count nonblank cells
	Count how often a value occurs
	Count occurrences of values or unique values in a data range
	Count numbers greater than or less than a number
	Calculate a running total
	Count all of the cells in a range
	Count the number of words in a cell or range
Conversion	Convert times
	Convert dates stored as text to dates
	Convert numbers stored as text to numbers
	Convert measurements
	Convert numbers to different number systems
	Convert Arabic to Roman numerals
Text	Change the case of text
	Check if a cell contains text
	Compare cell contents
	Combine text and numbers
	Combine text with a date or time
	Combine first and last names
	Combine two or more columns by using a function
	Repeat a character in a cell
	Display only the last four digits of identification numbers
	Remove spaces from the beginning and end of a cell
	Remove characters from text
	Insert the current Excel file name in a cell
	Split names by using Convert Text to Columns
	Split text among columns by using function Source: Office.Mircrosoft.com

Microsoft Office 2007

Microsoft Office 2007 (officially called 2007 Microsoft Office System), also called MS Office 2007, is a Windows version of theMicrosoft Office System, Microsoft's productivity suite. Known as Office 12 in the early stages of its beta development, it was released to volume license customers on November 30, 2006[4] and made available to retail customers on January 30, 2007. These are, respectively, the same dates Windows Vista was released to volume licensing and retail customers. Office 2007 contains a number of new features, the most notable of which is the entirely new graphical user interface called the Fluent User Interface[5] (initially referred to as the Ribbon User Interface), replacing the menus and toolbars – which have been the cornerstone of Office since its inception – with a tabbed toolbar, known as the Ribbon. Office 2007 requires Windows XP with Service Pack 2 or higher, Windows Server 2003 with Service Pack 1 or higher, Windows Vista or Windows 7.[6] Office 2007 is the last version of Microsoft Office which is officially supported on Windows XP Professional x64 Edition and the first version to officially work onWindows 8.


The 'Ribbon User Interface' is a task-oriented Graphical User Interface (GUI). It features a central menu button, widely known as the 'Office Button'. The Ribbon Interface has been improved in Microsoft Office 2010.


Office 2007 also includes new applications and server-side tools. Chief among these is Groove, a collaboration and communication suite for smaller businesses, which was originally developed by Groove Networks before being acquired by Microsoft in 2005. Also included is Office SharePoint Server 2007, a major revision to the server platform for Office applications, which supports "Excel Services", a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.


Microsoft FrontPage has been removed from the Office suite entirely. It has been replaced by Microsoft Office SharePoint Designer, which is aimed towards development of SharePoint portals. Its designer-oriented counterpart Microsoft Expression Webis targeted for general web development. However, neither application has been included in Office 2007.


Speech recognition and handwriting recognition are now part of Windows Vista. Speech and ink components have been removed from Office 2007.[7][8] Handwriting and speech recognition work with Office 2007 only on Windows Vista or Windows XP Tablet PC Edition. However, XP users can use an earlier version of Office to use speech recognition.[9]


According to Forrester Research, as of May 2010, Microsoft Office 2007 is used in 81% of enterprises it surveyed (its sample comprising 115 North American and European enterprise and SMB decision makers).[10]








Source: Wikipidia...