OST3100X4 — Excel: Pivot Charts Power Qry
This advanced level Microsoft Excel course covers the ins and outs of Excel PivotTable and PivotChart reports, including how to create a stand-alone PivotChart. Students will learn how to quickly drill down, drill up, and cross drill in a PivotTable to identify specific information, and how to change your PivotTable field settings to a variety of options such as average, minimum, maximum, and custom settings. Additionally, you will learn to work with large data sets in Power Query to manage and transform your data.