Milos GregorOnline app for COVID-19 data analysis and visualizationI had this project ready for a long time, but I didn’t have time to inform more about it. It is a free web application where you can…Jun 7, 2020Jun 7, 2020
Milos GregorHow to Rename Table ColumnsTable columns renaming is easy if you do it directly in a spreadsheet. Different it is inside the Reshape.XL add-in.Sep 29, 2019Sep 29, 2019
Milos GregorFAQ: Is Reshape.XL an alternative to Power Query?Add-in Power Query is a comprehensive tool that has been created for tasks where basic Excel functionality is not enough.Aug 12, 2019Aug 12, 2019
Milos GregorHow to Select and Reorder Excel Data ColumnsSometimes it happens that we work with large datasets — datasets that contain tens to hundreds of columns.May 22, 2019May 22, 2019
Milos Gregor2 Interesting Functions For Excel Table SortingOne of the most important spreadsheet functions is to sort table values by selected columns.May 12, 2019May 12, 2019
Milos GregorFormat Variables in Reshape.XLVariable formatting is an important part of the data preparation prior to statistical processing.Apr 1, 2019Apr 1, 2019
Milos GregorHow to Pivot and Unpivot Excel DataData pivoting / unpivoting using the Reshape.XL add-in.Mar 14, 2019Mar 14, 2019
Milos GregorReshape.XL 1.1 is AvailableExcel add-in for data wrangling was updated.Feb 24, 2019Feb 24, 2019
Milos GregorProcess and Summarize Excel Data in GroupsGroup By alternative from SQL for ExcelFeb 18, 2019Feb 18, 2019