Below are some links to articles I've written that you may find useful. Be sure to check back periodically for new content.

 

The Best Uses for Microsoft Excel's INDIRECT Function

The Best Uses for Microsoft Excel's IFERROR Function

The Best Uses for Microsoft Excel's RANK Function

The Best Uses for Microsoft Excel's SEARCH Function

 

Feel free to republish the above articles, provided they are copied in full and include the SIG line (the last 2 paragraphs that give credit) per the terms of service seen here.