Excel remains unbeatable for quick ad-hoc analysis. Move to Power BI when you need shared datasets, certified models, scheduled refresh, and governed distribution across departments.
Power Query in Excel and Power BI shares similar concepts—skills transfer directly.