How do i create diff transitions between 2 videos?

I know how to add two videos together, in most of my videos i pause  and then cut part out and connect the next video right to it and it picks right up. But how do i add some cool kind of transitions between those two videos, like what you can do on powerpoints, do unique transitions between slides. For example as the one video ends it acts like a page of a book is being turned and the new video picks right up from there. How do i add those transitions? Thanks