It's often used in a triumphant or dramatic way, like when you've finally finished something or when you're presenting a solution.
Here are some examples:
* "I've finished the project! Voilà!"
* "And there you have it, the answer to your question."
* "Here's the recipe, voilà!"