Grouping, ungrouping and dealing with errors How to combine data from multiple worksheets for a PivotTable How to do a PivotTable (a quick refresher) If you are new to Excel, try out one of the Simon Sez IT Beginner Excel courses also available on Udemy. We don’t recommend this course for people brand new to Excel. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function. In this course, we give a PivotTable refresher before moving onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. In this Advanced PivotTables in Excel course, we teach you how to make the most of this powerful data analysis function.
0 Comments
Leave a Reply. |