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. But this article is about PowerView tool, which serves as presentation addin for data whether […]
Month: February 2014
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 that can be used to create simple chart. If this guide has helped you, become a […]
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 set this tool correctly. If this guide has helped you, become a fan on Facebook […]
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 into spreadsheets in Excel. This guide will help you import text, you can find it […]
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 guide has helped you, become a fan on Facebook and recommend this site to your […]
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 solved by a single choice – Paste special. Check out the article on the most […]