Posted in Word

MS Word ShortCut

Ctrl + s = save file

Posted in Excel

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…

Posted in Excel Jobs

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…

Posted in Excel Jobs

Data Analysis (MS Excel):

Assignment: Data Available in Raw Shape To make analysis use of Pivot Table   Use of Formulation & Function: Date…

Posted in Excel Jobs

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…