Fix Microsoft Excel Error – PivotTable Field Name Is Not Valid
PivotTable is a powerful feature offered by Microsoft Excel. It helps extracting important details from detailed and large data sets. While creating a new PivotTable...
Category: Advanced
List Unique Values In A Column
Often times you need list unique values in a column to summarize, check or compile results. I will show you three ways to do it...
Excel Organization Chart
Here is an unusual use of column chart, as an excel organization chart. It is pretty easy to make and look very nice. You can...
Multi-Level Filter On Pivot Table
Filtering pivot tables with more than one field at the same time is possible and easy. Here is a guide about how to set up...
Create Custom Ribbon
We have been over customizing ribbons in a previous post. Now let’s see how we can create custom ribbon in Excel.
Repair Corrupted Excel Workbook
You can encounter corrupted workbooks time to time. Sometimes one of your workbooks gets corrupted, sometimes a file you received is. But there is no...
