PivotTables have been around so long that there’s an assumption that all Office users are familiar with them. Even if you are not a data analyst or data scientist, you can impress your boss by creating some amazing PivotTable or charts to represent a larger set of data. Personally, I feel PivotTable is one of the most useful tools in Excel if your works demands you to play around data. Mayurakshi wants to show you some of the nifty parts of PivotTables but before that she’ll of PivotTables and why they are so useful. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. Thanks for joining us! You'll get a welcome message in a few moments.