This article is a tribute to my assistant in writing without which I can no longer imagine doing it. English is not my native language, neither I learn it at school, and that is the reason why it is great to have a helping hand from a brilliant tool called Grammarly.
Month: October 2018
How to switch from Excel to R
As an Excel user for many years, I’m periodically trying new things to work with data and one of them was R. If you are interested in R, then here are a few tips and inspirational words that worked for me and may work for you.
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 spreadsheet, and, depending on the amount of data that I want to copy, there are different solutions to that process.
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 + X to open Quick Link menu and press C. 3. If you are the RStudio user, then switch to Terminal in your Console pane.
How to run R scripts from the Windows command line (CMD)
R is excellent for data transformation, modeling, etc. automatization. It is possible to run R scripts from the command line. In my case, I was collecting data and using library RDCOMClient to send summary information to colleges with Microsoft Outlook, but I needed it to do that automatically. It is possible to run R scripts… Continue reading How to run R scripts from the Windows command line (CMD)
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. Here is the solution that helped me and I hope you too.
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 convenient data what you can get through the API, because results are divided into pages, each containing 25 chats. So in the further post is a simple method of how to make… Continue reading How to get LiveChat API data with Microsoft Excel or Power BI
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 under 5 minutes. I don’t know how good was mine, but in this video is a bunch of interesting stuff going on. My goal was to do as much as I can,… Continue reading How much you can do with PivotTable in 5 minutes?
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 additional source. I will show you how to make list with the last seven days and 15 minute time intervals. It is useful when you combine it with data, where several periods… Continue reading How to generate date and time interval list using Power Query
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 – sometimes you want some static chart or table image, but picture quality becomes a real problem. As you see in post title image, I have a solution and it’s pretty simple.