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.