WorkSheets
Shortcuts
Cells
Charts
Columns
Pivot Tables

Shortcuts
Video Professor
Contact Us
How to Create a Template from an Existing Pivot Table and Chart to Use with a New Set of Data
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 »
How to Quickly Add Data to an Existing Pivot Table and Chart Already Saved and Styled
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 »
How to Instantly Create a Pivot Table Chart
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 »
How to Quickly Format a Pivot Table
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 »
How to Create a Pivot Table from a Range or Table
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 »
Learn to Overcome Pivot Table Fear
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 »
How to Create Mailing Labels Merge Using Microsoft Excel and Word
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 »
How to Create a Mail Merge Using Microsoft Excel and Word
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 »
How to Merge Columns in Excel
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