Cleaning data part 3 of 3 – Find and Replace as well as the Text to Column function

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 that we have exported data from, for example, an accounting system or saved data in file format such as csv. Want to read the post in Swedish? Click here Look […]

Cleaning data part 2 of 3 – Having numbers formated as text?

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. The reason why we encounter numbers in text format is often due to the fact that we have exported data from, for example, an accounting system or received external data. […]

How to Clean Data in Excel and 4 examples of Absolute and Relative Cell Reference

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 report basis. We will look at this in the upcoming posts and it does not have to be so complicated or time consuming if you know the tricksūüėČ. Want to […]

How to use Emojis in Excel and how to succeed with the IF-function

A couple of weeks ago we announced our very first guestblogger Carl Stiller.¬†Carl has a¬†Master’s degree in economics¬†and has many years of experience working as a¬†controller. In our collaboration Carl will showcase¬†real examples taken from his working life¬†where Excel is a key tool!Head on to Index where we have posted an¬†introductory interview¬†with Carl and also […]

How to use the Quick Access Toolbar in Excel and my personal favourites

Want to read the post in Swedish? Click here Welcome back, in today’s quite easy post we will take a look at my favourites in the quick access toolbar where we easily can save our favourite commands. Since we use some commands belonging to the various menu tabs more than others and it is not […]