Excel Magic 8: Transforming a Pro-forma into a Dashboard

<p>The course is presented in three parts. <b>First,</b> the course reveals the 3 shortcomings of presenting a pro-forma report. They are:</p>

<ul>

<li>Hard to slice and dice</li>

<li>Hard to build a collapsible table on timeline</li>

<li>Not for self-service</li>

</ul>

<p><b>Next,</b> the course presents 3 challenges in building a Pro-Forma report and provide solutions for the challenges. They include:</p>

<ul>

<li>How to Track On-hire Days for Each Vessel?</li>

<li>How to Track Daily Hire Rates for Each Vessel?</li>

<li>How to Calculate Net Hire Revenues?</li>

</ul>

<p><b>Last,</b> the course presents another 3 challenges in building a Dashboard report and provide solutions for the challenges. They include:</p>

<ul>

<li>How to convert Pro-forma report to a Dashboard report?</li>

<li>How to build the Slice-and-dice function of a dashboard?</li>

<li>How to display budgets, actuals and off-hires all in one chart?</li>

</ul>

<p>&nbsp;</p>

<p>Course Key Concepts: <b>Pro-Forma report, Dashboard report, Power Query, Unpivot, Reference, Merge queries, Slicer, Timeline, PivotChart, Combo Chart, Secondary Axis.</b></p>