Description

<p>The course is presented in four parts:</p>

<p><b>First,</b>&nbsp;t<span style=”font-size: 13.8px;”>he course illustrates where pivot tables stand in Excel Techniques, and covers the topic of when and when NOT to use a pivot table.</span></p>

<p><b>Second,</b> the course illustrates how to build a self-service dashboard using:</p>

<ul>

<li>pivot tables</li>

<li>pivot charts</li>

<li>slicers</li>

<li>timeline</li>

</ul>

<p><b>Third,</b> the course provides 5 extreme hacks for pivot tables including:</p>

<ul>

<li>How to collapse 12 months data into 1 field?</li>

<li>How to break free of Pivot Tables?</li>

<li>How to use Power Pivot without opening Power Pivot?</li>

<li>How to connect tables without using VLOOKUP()?</li>

</ul>

<p><b>Last,</b> the course explores best practices in building a dashboard. They include:</p>

<ul>

<li>Do follow data table naming convention</li>

<li>Do fix changing column width</li>

<li>Do keep column/bar charts sorted</li>

<li>Do add a heat map for pivot tables</li>

</ul>

<p>Course Key Concepts: <b>Artificial Intelligence, Pivot chart, Slicer, Timeline, Power Pivot, Power Query, Data model, Outline form, Calculated fields, Calculated item, Auto Refresh, VBA, Macro.</b></p>