Dubnica nad Vahom, Slovakia
Oct 27, 2018   |  By Milos Gregor
This month I released new tool. Reshape.XL is a general purpose tool for effective data processing (wrangling) in Excel. This tool is released as a small installable add-in for Excel.
Jun 18, 2018   |  By Milos Gregor
If you are working with data, you probably have them stored in Excel files, databases or in CSV files. This post is about CSV files, their import and use in the Stagraph environment.
Jun 7, 2018   |  By Milos Gregor
To access data from databases, we use in Stagraph the data_database function. Since databases are an important source of data, we have paid much attention to developing the visual interface for database connection and data retrieving.
May 15, 2018   |  By Milos Gregor
Programming language R is a favored environment for working with data. The number of R users is already reported in millions. Thanks to its capabilities and functionality it can be used in many forms. Selection from the current options is provided by the following article.
Apr 20, 2018   |  By Milos Gregor
In the previous article, we have shown how to link the Stagraph with Power BI Desktop. In this article we will show you some practical examples. If you want to create professional statistical graphics in Power BI and you do not have R programming skills, integration with Stagraph can be very useful for you.
Oct 9, 2019   |  By Milos Gregor
This video introduces specialized filter functions in the Reshape.XL add-in for Excel data processing.
Oct 1, 2019   |  By Milos Gregor
Sep 25, 2019   |  By Milos Gregor
Simple video tutorial that describes how to select #unique (#distinct) values from #Excel tables with the Reshape.XL add-in.
Aug 11, 2019   |  By Milos Gregor
How use use the Complete function for making explicit missing values from implicit in Excel spreadsheet.
Jul 30, 2019   |  By Milos Gregor
This video tutorial introduces four simple-to-use Reshape.XL functions for work with missing values (empty cells) - Drop_NA, Select_NA, Fill_NA & Replace_NA.