Slide shows, motion graphics, basically almost anything you have ever seen in a movie or commercial can be created, composited, or animated in After Effects if you spend sufficient time learning the app and studying the techniques. AE is not an easy app to get a handle on. You cannot just open it up and start using it.
There are hundreds of slide show templates available, and you can customize most of them to suit your needs.
If you are planning to get clients that pay you well for your time just using a template or throwing together something quickly isn't going to keep you in business very long. It's all about the story, and that means music and or narration and or the right images and the right moves and the right kind of transitions.
I hope this helps. If you want to see how After Effects works check ou the User Guide.
I'm asking this as I will take the time over the next month or 2 to learn what I need to. I don't want to spend this time if I cannot sell my creations. My business is already making money I am paid well for my time, I wanted to add an additional product for my clients.