Lennox International Interview Question

Describe a time you used excel and had to solve a complex problem?