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...
Category: Advanced
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...
Top Excel Tips
This will be an ever improving Top Excel Tips post. I’ll be adding new tips every couple of days until total count reaches 100 tips....
Using Data Form
Excel has a pretty unknown tool for data input assistance named Data Form. Here is how to benefit from this tool…
Excel Timeline
Excel Timeline is a new pivot table filter introduced in Excel 2013. It automatically evaluates date data and provides year, quarter, month and day filters...
