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...

Read more »

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...

Read more »

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...

Read more »

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...

Read more »

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...

Read more »

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...

Read more »

Since you probably have learned by now how to do a mail merge with Excel and Word, how about I show you how you can use the same principles and create a mailing label mail merge using both Excel and Word. In this tutorial, I will show you how to create...

Read more »

Have you ever been asked at work “Hey, do you know how to do a mail merge?” and you think to yourself, I know how to merge columns, yes I have done it but now I can’t remember for the life of me. Perhaps you did it once, or you saw someone...

Read more »

If you use Excel a lot, you probably know how to merge cells. However, something you may not use or think much about is merging columns. At some point, you will have a need to merge two or more columns, and you’ll wonder how to do it but figure...

Read more »

You know how some times you receive raw data in word and you really need to analyze it but you can’t do it in the format that was emailed to you. You have the option of taking this raw data and coping and pasting it onto an Excel spreadsheet,...

Read more »