Using Data Form
Excel has a pretty unknown tool for data input assistance named Data Form. Here is how to benefit from this tool…
Category: Advanced
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...
Website Like Ratings
I was looking for hosting solutions for beatexcel when I saw ratings for hosting companies on almost all affiliate sites. I wondered whether we can...
Text to Columns
Sometimes you may need to divide text data columns. This can quickly become a dreadful task. To overcome this problem, Excel provides a tool named...
