How to Convert Dates into Quarter / Year Format

Summary: Convert a list of dates into into quarter and year format. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Convert Dates into Quarters (9.26 KB)

How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name.

Summary: How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Advance Vlookup (17.5 KB)

How to Select Multiple Cells, Rows or columns Without Holding Ctrl+Click

Summary: How to Select Multiple Cells, Rows or columns Without Holding Ctrl+Click. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

How to Automatically Numbering Rows

Summary: How to Automatically Numbering Rows. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Automatically Numbering Rows (22 KB)

How to Create Formulas Comparing Lists for Duplicates

Summary: How to Create Formulas Comparing Lists for Duplicates to see if there is duplicate information. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Formulas for Comparing Lists for Duplicates (17 KB)

How to Create Data Validation

Summary: How to Create Data Validation. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Data validation (16.5 KB)

How to Delete Duplicate Rows

Summary: How to Delete Duplicate Rows. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Delete Dups (21 KB)

How to Automatically Capitalizing First Letter of Sentence

Summary: How to How to Automatically Capitalizing First Letter of Sentence. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Proper Function (29.5 KB)

How to Summing Only Positive Values

Summary: How to Summing Only Positive Values. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Summing Only Positive Values (16.5 KB)

How to Converting Cells to Proper Case

Summary: How to create an Excel Macro to change cells from uppercase to lowercase. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Proper Case (30.5 KB)

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com