Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a simple VBA code to your Personal.xsb file and create a shortcut that you like.
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 environments.
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.
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.
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,…
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.
Histograms are useful for data distribution visualization, and there are many possible ways how to make an Excel PivotTable histogram. Some may prefer the Histogram option in Data Analysis Add-In or the FREQUENCY function for this task. But I think that the easiest way is to do that with PivotTable. Here is how to do…