Why i chose to use Grammarly
This article is a tribute to my assistant in writing without which I can no longer imagine doing it. English is not my…
How to switch from Excel to R
As an Excel user for many years, I’m periodically trying new things in work with data and one of them was R. If…
How to copy the R data frame to Excel and customize your startup
Very often I use RStudio and Excel all together. In that situation, sometimes I want to copy some R results in the Excel…
How to quickly open Windows command prompt
1. Press Win + R keys to launch Run window and type “cmd”. 2. If you are Windows 10 user, then press Win…
How to run R scripts from the Windows command line (CMD)
R is great for data transformation, modeling, etc. automatization. In my case, I was collecting data and using library RDCOMClient to send summary…
How to fix it: Excel 2016 restarting immediately after opening xlsm file
This kind of problem when Excel crashes do not happen very often, but with no recovery options it can make you feel frustrated.…
How to get LiveChat API data with Microsoft Excel or Power BI
Here is an example with getting LiveChat transcripts right into Microsoft Excel Power Query or Power BI. Chat conversations are not the most…
How much you can do with PivotTable in 5 minutes?
A few years ago I was participating in an Excel PivotTable contest, where the goal was to make the best PivotTable you can…
How to generate date and time interval list using Power Query
One thing I love about Microsft Power Query is the ability to make lists. It means that you can generate data without some…
How to copy a sharp picture from Excel without blurry effect
Imagine – you copy beautiful chart as a picture from Excel to Outlook message and it becomes blurry. The same thing with PowerPoint…