"Excel Formulas Intermediate: Advanced Formula Techniques." aims to enhance participants' knowledge of Excel functions, including using Name Manager for named ranges, Absolute and Relative References, compound formulas, troubleshooting with Formula Auditing, data extraction from Pivot Tables, 2-tier data validation, and creating 2-dimensional lookups.