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.…
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 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…
