How to load jQuery once per page in SharePoint and avoid conflicts and errors with multiple instances on the same page.
Lessons learned from completing my first custom PC build.
How to perform complex lookups in Excel using multiple criteria through either a formula based on the sumproduct function or an array formula.
Excel VBA procedure to programmatically import worksheets from one closed workbook into a different Excel workbook.
Excel VBA functions to break all external references and delete defined names containing external workbook references.
Excel VBA utility function to test if a workbook is already open.
Excel VBA utility function to test if a file exists.
How to dynamically replace text values with Unicode characters or images in a SharePoint list view using jQuery.