Hello, I hope you have a nice working week. This post discusses PivotTables, calculated fields as well includes a tip regarding the equivalent in Power
PivotTables are something that all Excel users should master well and one of the first things one should consider learning. In this lesson, out of
Doughnut charts can be a perfect tool to visualize results or percentage of achieved goals.The charts can be a bit complicated to put together if
Correlation indicates in statistics the strength and direction of a relationship between two or more variables. The correlation is often stated with a correlation coefficient.
Is it…? Is it worth the time you need to spend before you learn the function… and even after? There is a lot you can
Pasting reports … should it be that hard to get it right?🤔 If we have now prepared a report numerically and need to insert it
We have now come to the post for the powerful function SUMPRODUCT… my favourite function. I became acquainted with this feature 12 years ago, setting
If you want to learn Microsoft Excel’s new super function XLOOKUP, a good tip is to try to use the function every time you intend
We have now come to the first posts that deal with reporting, I will show the most common types of reports and how to use
Today we continue to go through how to “wash data”. The reason why we encounter amounts in non-numeric format is often due to the fact
Want the post in Swedish? Click here Today we will continue with washing data and addressing the problem when the amount is in text format.
Clean data! Sounds maybe not so fun but a must to be able to use the raw data we have obtained as our analysis or
