All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.īasic to intermediate knowledge of Microsoft Excel is beneficial. The course was created using Excel 2019/365 for Windows. How to update your data in a PivotTable and Pivot ChartĪll about Conditional Formatting in a PivotTable How to combine data from multiple worksheets for a PivotTableĪdding new Data to the original source dataset Selecting the right Chart to present your dataĪdding Slicers and lines and how to apply on multiple tables
How to create Pivot Charts and add sparklines and slicers How to format Pivot Table and apply Styles Grouping and Ungrouping Pivot Table data and dealing with Errors Using the Fields pane and adding Fields and Calculated Fields Learn and Master Pivot Tables in Excel with this Bner to Advanced course from Microsoft experts, Simon Sez IT! Genre: eLearning | Language: English + srt | Duration: 119 lectures (13h 10m) | Size: 6.94 GB
