How to add leading zeros in R, Power Query, DAX or Excel
Here are multiple examples of how to add leading zeros in different ways and places. In these examples, I will add them to…
How to quickly build R data frame from scratch with Excel
If you know some of the Excel text functions, you can quickly build R data frame from scratch. Also, you should understand how…
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 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 calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different…
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 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.…
