If you are using Visual Studio right click on your project and select Properties at the bottom of the pop up menu. Add the path to QuantLib in VC++ Directories/Include Directories.
You might find the library
https://xll.codeplex.com useful for creating the Excel add-in.