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...
Category: Advanced
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...
Sum a Range of Cells that Contains Errors
Every now and then you will need to calculate sum (or average, min, max, etc.) of a range of cells that contains errors. Normal functions...
Customize Ribbons
You can customize your ribbons, add new commands or rearrange existing ones as you like. In this post I will show you how to customize...
