Agile Project Management has become more useful when it comes to managing projects. Several organizations are going to Agile Project Management instead of using the traditional waterfall approach.
When it comes to Microsoft Project, you can manage a Project as an Agile Project. There are also add-ons that can be purchased as well. It all depends on how your organization does there Agile projects. In my years of experience, I have seen companies use SCRUM exactly the way it is supposed to be used, others only do bits and pieces of it, some use Kanban, etc.
Before using Microsoft project to manage an Agile Project such as SCRUM, you will need to understand the basic principles, why they are used and what is the purpose. Some of those principles are: Product Owner, SCRUM Master, Product Backlog, Iterations (Sprints), Reports(ex. Velocity and Burn down) Daily SCRUM meeting, Vision, and Release and Iteration Planning.
For starts Microsoft Project does have and an out of box template for Agile Projects, it is generic.