Excel 2013 comes with addin PowerPivot and PowerView. PowerPivot is used to prepare the data model and the subsequent creation of PivotTable where the classic Excel is not enough. It enables eg. creating of relationships between tables and can have even more records.… Read more
This is a video on demand for Jakub, who searched for a solution of the problem with numbers in cells that contained spaces, brackets and more. Look in the manual for a final solution using functions and removing spaces. The results are only numbers… Read more
Two or more documents in Word with small or larger differences can be compared by integrated tool Compare documents. It highlights individual differences clearly and you just decide the change you save or delete. This video helps you to understand this issue and… Read more
Sorry, this entry is only available in Czech.
Maybe the article title does not say anything, but if you are often importing txt or csv files in Excel, this guide will help you set the default encoding type. Generally importing serve to convert the file from another application… Read more
I received the question about how to insert new blank row in the table below each row. Surprisingly, the solution is not complicated, it is only a play with sorting. Check out how to do it in one minute video. If this… Read more
When you copy cells in Excel, the user can choose how the copy inserts. I often encounter questions as how copying only the result value, not to change the column width, to transfer only the formatting etc. And all these problems are… Read more