Year: 2014

26. Videotutorial – PowerMap 3D add-in 01

26. Videotutorial – PowerMap 3D add-in

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 […]

Power View – show data on a map powerview2

Power View – show data on a map

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 […]

25. Videotutorial – convert numbers with spaces prevod

25. Videotutorial – convert numbers with spaces

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 […]

24. Videotutorial – compare documents in Word compare

24. Videotutorial – compare documents in Word

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 […]

Default text encoding typ for import import1

Default text encoding typ for import

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 […]

Scroll to Top