Although I can create simple formulas using functions, I can't seem to put together more complex formulas involving multiple nested functions.

I have a couple of Excel books that explain what all the functions do, and their syntax, but they don't explain how to string them together.

I'm not a programmer, but I do understand basic programming concepts.

Can anyone suggest a good method for learning how to do this?

Thanks.