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 […]
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 […]
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 […]
It is also strange to you that the column names in the table sometimes omitted some letter? It can make a sense, if it is desirable to have such a column hidden, eg. with helping calculations. How such column again to unhide? Have a look at this one minute video. If this guide has helped you, become a […]
One of the basic functions, yet many people are not using. If they know it they could save much work in calculating basic summaries. We are talking about the SUM and AVERAGE – end of counting totals and averages manually. SUM description =SUM(value 1, value 2, … ,value 255) values 1 … 255 are cells with the numbers or values for […]
