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 […]
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 […]
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 […]
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 […]
Making a presentation can be faster than you think. Especially if you have already text outline prepared in a text document – in Word. Check out this video that will show you the entire process. If this guide has helped you, become a fan on Facebook and recommend this site to your friends, it can be useful […]
When completing tables we may offer some items to be selected from the list of options using the Data Validation. You can ensure that users always selects one of the values and no other, or perhaps let Excel to calculate a formula or format the cells in a table right by the selected option. Whether in […]
