Can I use cheat engine on single player games?

Yes you can use it but if anything goes wrong you wont be able to do a thing about it. Note that some 'single player' games are actually open to the internet for others to join. Dead Island, TF2, etc. If it is a VAC game, ensure you are in -insecure mode!