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.
Category: Excel
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.
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 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 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 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.
Probably simplest and fastest way how to make a histogram in Excel
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… Continue reading Probably simplest and fastest way how to make a histogram in Excel