It happens that the table contains a group of heading lines, but these titles will not appear in the other cells and these are seen as empty cells. When we want to take these values and copy them into empty cells down to another value (someone says to fill down), there is an interesting trick to do it. […]
Did you know that Excel can calculate a different way than by creating formulas? A little bit different procedure demonstrates this video. You can actually change the selected value via the “Paste Special” option. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful […]
When selecting the cells in Excel it is sometimes necessary to quickly find cells with some special features. E.g. we want to quickly select the blank cells or cells containing only numbers. Other times, it fits in group or summaries selecting only the visible cells. In short, there are situations where users would give anything in the […]
In Excel 2013, you can compare numeric data geographically on a three-dimensional globe, using the add-in PowerMap. Look at the video how to do it. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful for them too. Please note that this tutorial is presented […]
Using a version of Microsoft Office 2013 and create a new file, you lack the ability to load your own templates? This feature is still there, but by default is not set path to the folder of custom templates. In this article you will find the procedure to set up this way. If this guide has helped […]
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 […]
