Home » Author Archive

How to Create a Template from an Existing Pivot Table and Chart to Use with a New Set of Data
0
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...

Continue Reading »

How to Quickly Add Data to an Existing Pivot Table and Chart Already Saved and Styled
0
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...

Continue Reading »

How to Instantly Create a Pivot Table Chart
0
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...

Continue Reading »

How to Quickly Format a Pivot Table

How to Quickly Format a Pivot Table

Posted by on April 4, 2008
0
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...

Continue Reading »

How to Create a Pivot Table from a Range or Table
0
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...

Continue Reading »

Learn to Overcome Pivot Table Fear

Learn to Overcome Pivot Table Fear

Posted by on March 31, 2008
0
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...

Continue Reading »

How to Create Mailing Labels Merge Using Microsoft Excel and Word
0
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...

Continue Reading »

How to Create a Mail Merge Using Microsoft Excel and Word
0
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...

Continue Reading »

How to Merge Columns in Excel

How to Merge Columns in Excel

Posted by on February 15, 2008
0
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...

Continue Reading »

How to Separate Raw Data into Columns

How to Separate Raw Data into Columns

Posted by on February 15, 2008
0
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,...

Continue Reading »