In this short tutorial, you’ll learn how to save a Pivot Table and Chart as a template for later use and how to update this template with new information using the “Refresh” feature within the PivotTable menu. If for example, you have created...

In this tutorial, you’ll learn how to quickly make unforeseen changes to pivot table data and quickly update that change in the pivot table and Chart. Once you create a pivot table and Chart that works for you, save it and file it in an accessible...

In this tutorial, I’ll show you how to create a chart from a Pivot Table. Next, you can create a chart just as quickly as you formatted the table. Go to the floating pivot table menu and click on the button labeled “Chart Wizard” or click...

In this tutorial, you’ll learn how to format a pivot table using the feature of “Autoformat.” Now that you have your new table created it’s time to style it and make it look professional and the fastest way to do this is to use the pivot...

In this short tutorial, you’ll learn how to create a simple Pivot Table in a couple of steps. With the help of the wizard feature, Excel will actually walk you through the essential steps to build a Pivot Table from scratch. Open the excel file...

We all have used or will have to use Excel at some point in our lives. Excel is a great tool that makes handling, analyzing, presenting and reporting data a walk in the park. But most people are still deadly afraid of the pivot table feature within...