Pivot Table Data Source
Who doesn’t want to build Excel Pivot Tables fast and easy, and without rework? If you encounter difficulties, error messages and warnings, this article is for you.
How to display 2 excel workbooks on 1 screen
In this post I will show with you how to display multiple Excel files on one screen. Say you have one screen and you want to see 2 files at once for whatever reason (copy, compare, review, etc.). As always there are a number of scenarios within one setup: 1 screen 2 workbooks. Windows 7:…
‘Create PivotTable’ dialog box
What all the options in a ‘Create PivotTable’ dialog box mean?
What is a Pivot Table?
This article is meant for beginners that never heard of or never used a Pivot Table. Pivot Table (PT) is a powerful feature in Excel for analyzing, slicing and dicing data. Many people know about it, but have never used it. I met a professional with MBA credentials who said they (not to disclose the…