Unable to Open Excel File After Recovery
Summary: The blog describes the standard recovery features such as AutoRecover and Open & Repair offered by MS Excel application to repair corrupt or damaged...
Category: Advanced
Microsoft Excel File Size Became 0 KB
Summary: The blog summarizes the methods to repair MS Excel workbook and explains various benefits that each procedure offers. It also describes a third-party Excel...
Search By Color In Excel
Most users does not know that they can search by color in Excel. But with a bit of attention to details, you can search by color...
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...
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...
