PivotTable: Calculated Fields
Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total...
Tag
PivotTable
Data Slicer and Timeline are Useful Reporting Tools in PivotTable
Most of us know how to use a Filter in PivotTable, but do you know that there is an even better tool in slicing data in PivotTable? Yes, there is, and the name is, well, Data...
How Advance do People Make Rental Car Reservations? The Result May Surprise You!
Spring break is upon us. Many students of mine are heading to exotic location, and quite a few of them have reserved rental cars many weeks earlier. But here is the question:...