Excel Power Query: Useful for Investment Banking Roles?

[@Galbiiiii]

Always thank you for awesome videos

[@financialmodeling]

Thanks for watching!

[@Joel-if2bg]

thanks man, very useful and great run-through

[@financialmodeling]

Thanks for watching!

[@bezualemfisseha2119]

thank you

[@financialmodeling]

Thanks for watching!

[@carrd3971]

this lesson had a high roi for my brain

[@T3AMKILL]

Agreed!

[@financialmodeling]

Thanks for watching!

[@daviddong7590]

A small improvement here: The new table created by Power Query was in "Excel Table" format, which name is "State_data". So users could just type "State_data" and "State_data[Col_name]" when INDEX the full table and its column.

[@financialmodeling]

Yup, that's true, thanks for adding. I didn't want to go into data table syntax here because that's a whole separate topic that requires more explanation. But yes, you can refer to columns more efficiently if a data table has been set up internally.

[@daviddong7590]

Mergers & Inquisitions / Breaking Into Wall Street Thank you for your response!

[@vladkornilov7509]

One of the conclusions - Mac is useless overpriced trash. Even in Excel 2019 there is no PowerQuery, when on Windows you can install it on Excel 2010... Of course it is effective Microsoft strategy to stimulate people to use Windows instead of Mac. Now for my work I am using PowerBI to make business insights and also learn Python visualisation libraries. And I dont see any alternative to PowerBI for business. Power of DAX formulas is one of the reasons that totally knock outs all other BI stuffs like Tableau.

[@financialmodeling]

I agree that Mac Excel and PowerPoint are largely useless, which is why we recommend using Parallels or otherwise installing a Windows partition and running PC Excel and PowerPoint. Some people really like Mac systems for other reasons (e.g., design or film editing work), but personally I can't get used to them even after trying multiple times.