Course Content
Excel for Finance
Excel for Finance
2. Advanced Data Manipulation with Power Query
4. Dashboard Automation
5. Developing an Interactive Report
Finalizing Report
In this guide, we will wrap up our work on the interactive report by exporting and setting up the OPEX table in the form of a Pivot Table, pulling data using filters, and calculating key financial metrics such as Net Revenue, Losses, and EBITDA.
In this chapter, we use the SUM, GETPIVOTDATA, and LEFT functions.
Everything was clear?
Thanks for your feedback!
Section 5. Chapter 3