Category: Advanced

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...

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...