This remarkable study by Van Der Werf and his colleagues shows that you can learn motor skills just by watching and then sleeping shortly after. But you won’t learn from watching if you don’t sleep immediately!
Dreaming improves creative problem solving and fluid intelligence type problem solving.