Excel On Steroids Tips And Tricks Vol 4 - aimINSIGHT Solutions, Inc.

Call us anytime 310-313-0047

USING THE TAB KEY TO MOVE TO THE NEXT INPUT CELL
TRAPPING ERROR MESSAGES
DATE CALCULATIONS & FORMULAS
CUSTOMIZING VALIDATION LISTS
AVERAGING A NON-CONTIGUOUS RANGE
FORMATTING YEAR VALUES REPRESENTED AS DECIMALS TO SHOW YEARS & MONTHS
DATE VALIDATION
QUICK WAY OF CREATING A CHART
EDITING SELECTED CELLS ON A PROTECTED WORKSHEET
FORMULA TO FIND DUPLICATE VALUES IN A DATA RANGE
SWITCHING BETWEEN RELATIVE, ABSOLUTE, AND MIXED REFERENCES
GENERATING OF RANDOM NUMBERS FOR TESTING OF FORMULAS