This course covers key features including IF formulas, VLOOKUP, Pivot Tables, and techniques for managing large datasets and linked sheets.