## A gateway to hidden and powerful features !

Do you use Paste Special every day? If not, you could be wasting a lot of time in Excel. Paste Special sounds boring, but it’s a gateway to many hidden and powerful features: Powerful features of Paste Special here! With paste special, we can easily: Convert formulas to static values Paste data without borders Paste […]

## Sum If (MS Excel)

SUMIF Adds the cells specified by a given criteria. Syntax SUMIF(range, criteria, sum_range) Range    is the range of cells you want evaluated. Criteria    is the criteria in the form of a number, expression, or text that defines which cells will be added. For example, criteria can be expressed as 32, “32”, “>32”, “apples”. Sum_range    are […]

## Data Analysis (MS Excel):

Assignment: Data Available in Raw Shape To make analysis use of Pivot Table   Use of Formulation & Function: Date = Date() Sum = Sum () Condition/Check = If() Conditional Sum =  Sumif() Absolute Cell Reference Length = LEN() Left = Left() Error = Iferror() Null Valve Chart Pivot Table   Additional: Day, Month, Year Right, […]

## Advanced Topics in Excel :

Excel over view The Date in Excel Excel Conditional Formatting Excel VLOOKUP Excel HLOOKUP Using Excel’s Goal Seek Feature Create Excel Pivot Tables Microsoft Excel Sort Feature Introduction to Using Macros in Microsoft Excel 2003 Protect Excel Sheet Data base in excel Copy, paste special function Links (Sheet / work book) Data showing thru Chart […]

## Microsoft Excel – Course outline

Are you want to learn MS Excel online? A free training session available for short time. What topic you want to learn? comments here Question Y/N Question Y/N Write basic formulas, eg = A1*A2 Write formulas using brackets where required, eg =(A1+A2)/A3 Write basic functions, eg SUM, AVERAGE,MAX, MIN Selecting ranges with cells together and […]