HR How to Merge Sheets from multiple Excel Files into one .xls file September 3, 2011 by Hrformats First open a blank workbook (let suppose name is TEMP) then open the excel file whose sheet you want to merge in to one Read More
HR Excel Shortcuts June 13, 2011 by Hrformats Uploading Excel Shortcuts Keys. Click Here To Download Excel Shortcuts Read More
HR Advanced Excel May 16, 2011 by Hrformats I am Herewith posting Advanced Excel details. Click Here To Download Ready Reckoner for Microsoft Excel 2003 Click Here To Download Advanced Excel 2003 Read More
HR Convert Num to Word May 10, 2011 by Hrformats Dear All, Please find the attachment. 1. Save as “Microsoft Office Excel Add In” file. 2. Open Excel > Tools > Add Ins.. 3. Read More
HR Excel – Create a Summary April 23, 2011 by Hrformats This example demonstrates how to create a summary sheet of data from a number of sheets. Relevant data should be in the same position Read More
HR Link in to Excel Sheet April 23, 2011 by Hrformats Please see attached Excel file in which I mentioned how to give link to other sheets. Click Here To Download Links Read More
Uncategorized Excel Amazing Traffic Light Formatting April 21, 2011 by Hrformats Hi, Here is another way to highlight data status using traffic lighting. This technique also uses conditional formatting as its basis, but unlike the Read More
Comments