How to run R script from another R script and use as a source
Here is a solution with running R script from another R script and using as a source. It comes handy when R script…
Latest Posts
How to run R script from another R script and use as a source
Here is a solution with running R script from another R script and using as a source. It comes handy when R script…
How to run Excel file from Windows 10 Task Scheduler
Sometimes, when Excel file contains macros that can run automatically when the file opens, there is a need to do that periodically and…
How to run Excel macro on file opening
Here is how to run Excel macro automatically every time you open the file in a few easy steps.
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when…
Incomplete final line found on Rprofile.site when installing from GitHub
I was stumbling on this “incomplete final line found on Rprofile” error while installing d3rain package with the following code remotes::install_github(“daranzolin/d3rain”). In one…
How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
How to animate Excel chart in PowerPoint
Data visualizations are a great way to present your data, but sometimes you need to add some animation effects in PowerPoint to make…
Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a…
How to create a flexible calendar table with Power Query
Here is an example of how to generate calendar based on two input values – date of the first day and date of…
Reader PicksAll posts
How to run R script from another R script and use as a source
Here is a solution with running R script from another R script and using as a source. It comes handy when R script…
How to run Excel file from Windows 10 Task Scheduler
Sometimes, when Excel file contains macros that can run automatically when the file opens, there is a need to do that periodically and…
How to run Excel macro on file opening
Here is how to run Excel macro automatically every time you open the file in a few easy steps.
How to create group index with Power Query or R
It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when…
Incomplete final line found on Rprofile.site when installing from GitHub
I was stumbling on this “incomplete final line found on Rprofile” error while installing d3rain package with the following code remotes::install_github(“daranzolin/d3rain”). In one…
How to generate time intervals or date sequence in R
In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For…
How to animate Excel chart in PowerPoint
Data visualizations are a great way to present your data, but sometimes you need to add some animation effects in PowerPoint to make…
Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a…
How to create a flexible calendar table with Power Query
Here is an example of how to generate calendar based on two input values – date of the first day and date of…
How to categorize and group data in time intervals with Power Query
If you have DateTime or time column in your data, then sometimes there is a desire to analyze it by time intervals. With…